In this section, you will conduct correlation and regression analyses using the

In this section, you will conduct correlation and regression analyses using the

SampleDataSet.xlsx

In this section, you will conduct correlation and regression analyses using the provided SampleDataSet.xlsx.

  • Correlation: Compute a correlation matrix that includes all continuous variables. Identify all individual correlations that are significant at the 95 percent level.
  • Regression: Build a multiple regression model to explain the variability in the median school year. Describe the goodness of fit of your model and summarize your findings. Select at least four to seven similar independent variables from the remaining forty-nine measures and justify your selection.

Submit your response in Microsoft Excel.