Build regression models for unstacked data Next, you need to build regression models on the unstacked data and compare them with the models with the stacked data. What you need to do:
a. Create a new worksheet called "Regressions for unstacked data"
b. Build regression models on the same variables as in task 3 step b but use each gender's data in "Unstacked Training set".
c. Explicate your regression equations. Explain the coefficients, interceptions in your models.
d. Use the "Unstacked Test set". Compute the mean squared error for the regression models you have built.
e. Build regression models on the same variables as in task 3 step e but use each gender's data in "Unstacked Training set".
f. Explicate your regression equations. Explain the coefficients, interceptions in your models.
g. Use the "Unstacked Test set". Compute the mean squared error for the regression models you have built.
h. Compare the mean squared errors between the stacked data regression models and the findings