Reference no: EM133016406

Reality TV and cosmetic surgery

(The Excel data set for this assignment is posted on the 2ksb inside the folder files). How much influence does the media have on one's decision to undergo cosmetic surgery? In the study, psychologists asked 170 college students about their impressions of reality TV shows featuring cosmetic surgeries. The psychologists used multiple regression to model desire to have cosmetic surgery (y), as a function of gender (x1), self-esteem (x2), body satisfaction (x3), and impression of reality TV (x4).  

1. Using Excel, construct scatter plots for (y and x4), (y and x3), (y and x2). Attach your output from Excel. Please interpret the Pearson's correlation coefficient described in each scatter plot.
2. Using excel, please estimate the unknown parameters (β1, β2,β3, and β4) and write the least square prediction equation. Attach output from Excel.
3. Interpret each parameter estimate (b0, b1, b2, b3, and b4) in English.
4. Is there sufficient evidence that the overall model is satisfactory for predicting desire to have cosmetic surgery? (test using α=0.01). Please highlight in the attached excel file the appropriate F-value which assesses overall model fit.
5. Please conduct hypothesis test to determine whether desire to have cosmetic surgery decreases as the level of body satisfaction increases (α=0.05). highlight in excel relevant information for this hypothesis.
6. Interpret the value of R2.
7. Please use the model developed in part (b) to estimate the desire to have cosmetic surgery when x1=0, x2=7, x3= 2, and x4=5.  
8. Find estimate for the standard deviation of error term and interpret this value.