Your final project entails
systematic extraction of decision-aiding insights from a dataset
(SampleDataSet.xlsx) provided to you in the Doc Sharing area. The goal
of this project is to provide you with hands-on experience in conducting and
interpreting different types of statistical analysis. The focus of your
analysis will be on marketing strategies and analysis-related topics. At times,
you will be expected to conduct additional research on topics that are not
adequately covered in your text, for example, data due diligence.
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
Name your worksheet SU_MBA5008_W4_A4_,xls
by Sunday, April 13, 2014.Project_DataSet.xlsx