A mental health agency measured the selfesteem score for ran

A mental health agency measured the self-esteem score for randomly selected individuals with disabilities who were involved in some work activity within the past year. The spreadsheet named Self Esteem provides the data including each individuals self-esteem measure (y), years of education (YrsEdu), age, months worked in the last 6 years (MonWork), marital status dummy variables (MS2, MS3, MS4) indicating if the individual is single, married, separated, or divorced, and a support level (SL) dummy variable indicating if the level of job support (counseling, etc) was provided directly (1) or indirectly (0). Regarding marital status, if single all MS indicators are 0, while MS2 = 1 indicates married, MS3 = 1 indicates separated, and MS4 = 1 indicates divorced.

a. 3 points:In cell N4, use Excel’s “Correlation” Data Analysis tool to construct a correlation matrix for all the variables. Note that the categories in columns I and J should not be included since the data are already represented as dummy variables in columns E through H.

b. 3 points: Considering the correlation between self-esteem and each x variable identify the three variables that, based on correlation with y alone, should be considered as best candidates for inclusion in the model. Shade the appropriate cells containing the correlation values in yellow. Ignore any multicollinearity concerns for this part.

c. 3 points: With cell N19 as the upper left hand corner of the output, fit the full regression model. (Do not include a residual plot)

d. 4 points: Considering the regression output from part c, shade (in yellow) the name of any x variable that appears significant and should remain in the model. Also shade the t stat and p-value. Consider the p-value small if it is less than 0.05.

e. 3 points: Partial Regression Model: With cell N51 the upper left hand corner of the output, fit the model including only the x variable(s) that were found to be significant in part d. (Do not include a residual plot)

f. 4 points: Comment on the impact of each independent variable in the partial regression model from part e on Self Esteem. Provide your comments in Cells N66:T78.

Solution