(15 points ) 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 (x ), self-esteem (x,), body satisfaction (x, ), and impression of reality TV (x,). a. (2 points) Using Excel, construct scatter plots for (y and x.), (y and x;), (y and x;). Attach your output from Excel. Please interpret the Pearson's correlation coefficient described in each scatter plot - b. (2.5 points) Using excel, please estimate the unknown parameters ( , 8,, 8,, and () and write the least square prediction equation. Attach output from Excel. c. (1.5 points) Interpret each parameter estimate (b, b, b,, b,, and b ) in English. d. (2 points) is there sufficient evidence that the overall model is satisfactory for predicting desire to have cosmetic surgery? (test using a=0.01). Please highlight in the attached excel file the appropriate F-value which assesses overall model fit. e. (2 points) Please conduct hypothesis test to determine whether desire to have cosmetic surgery decreases as the level of body satisfaction increases (a=0.05). highlight in excel relevant information for this hypothesis. f. (1.5 points) interpret the value of R?. g. (1.5 points) Please use the model developed in part (b) to estimate the desire to have cosmetic surgery when x, =0, x,=7, x,= 2, and x.=5. h. (2 points) find estimate for the standard deviation of error term and interpret this value