Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help with parts a-e on question #1. Make sure to show your work for full credit. 1. A sales manager collected data on weekly
Please help with parts a-e on question #1.
Make sure to show your work for full credit. 1. A sales manager collected data on weekly gross revenue (y, $1000s), television advertising (x1, $1000s), and newspaper advertising (X2, $1000s) for Showtime Movie Theaters. Please use the following Minitab output to help you answer the questions. Regression Analysis: Weekly Gross Revenue versus Televison Advertising, Newspaper Advertising Regression Equation Weekly Gross Revenue 83.23 + 2.290 Televison Advertising + 1.301 Newspaper Advertising Coefficients Term Constant SE T P- Coef Coef Value Value VIF 83.23 1.57 52.88 0.000 Televison Advertising 2.290 0.304 7.53 0.001 1.45 Newspaper Advertising 1.301 0.321 4.06 0.010 1.45 Model Summary S R-sq R-sq(adj) R-sq(pred) 0.642587 91.90% 88.66% 68.19% Analysis of Variance Source Regression Televison Advertising Newspaper Advertising Error Total F P- DF Adj ss Adj MS Value Value 2 23.435 11.7177 28.38 0.002 1 23.425 23.4247 56.73 0.001 6.795 6.7953 16.46 0.010 5 2.065 0.4129 7 25.500 1 SRES TRES HI COOK -1.62463035 -2.1148304 0.63293866 1.51708824 -1.07750463 -1.09986911 0.64517604 0.70369154 1.22455448 1.3090166 0.30141025 0.21566058 -0.36807947 -0.33377339 0.22646981 0.01322193 1.09775575 1.12702538 0.26175005 0.14242084 -0.39943251 -0.36310345 0.14012225 0.00866635 - 1.1206967 -1.15837163 0.6603374 0.81390384 1.08039791 1.1037203 0.13179554 0.05906428 Here SRES - Standardized residual, TRES - Studentized deleted residuals, HI - leverage values, COOK - Cook's distance. a) Develop an estimated regression equation to predict Weekly Gross Revenue (y) using Television Advertising (x1) and Newspaper Advertising (x2) as the independent variables. b) Interpret the coefficients of the Television Advertising (X1) c) Interpret the coefficients of the Newspaper Advertising (X2) d) Are there any outliers? Please use each of the two methods of standardized residuals, standardized deleted residuals SEPERATELY to detect outliers. Explain them clearly. e) Are there any influential observations? Please use each of the two methods of leverages, and Cook's Distances SEPERATELY to detect influential observations. Explain them clearly. Make sure to show your work for full credit. 1. A sales manager collected data on weekly gross revenue (y, $1000s), television advertising (x1, $1000s), and newspaper advertising (X2, $1000s) for Showtime Movie Theaters. Please use the following Minitab output to help you answer the questions. Regression Analysis: Weekly Gross Revenue versus Televison Advertising, Newspaper Advertising Regression Equation Weekly Gross Revenue 83.23 + 2.290 Televison Advertising + 1.301 Newspaper Advertising Coefficients Term Constant SE T P- Coef Coef Value Value VIF 83.23 1.57 52.88 0.000 Televison Advertising 2.290 0.304 7.53 0.001 1.45 Newspaper Advertising 1.301 0.321 4.06 0.010 1.45 Model Summary S R-sq R-sq(adj) R-sq(pred) 0.642587 91.90% 88.66% 68.19% Analysis of Variance Source Regression Televison Advertising Newspaper Advertising Error Total F P- DF Adj ss Adj MS Value Value 2 23.435 11.7177 28.38 0.002 1 23.425 23.4247 56.73 0.001 6.795 6.7953 16.46 0.010 5 2.065 0.4129 7 25.500 1 SRES TRES HI COOK -1.62463035 -2.1148304 0.63293866 1.51708824 -1.07750463 -1.09986911 0.64517604 0.70369154 1.22455448 1.3090166 0.30141025 0.21566058 -0.36807947 -0.33377339 0.22646981 0.01322193 1.09775575 1.12702538 0.26175005 0.14242084 -0.39943251 -0.36310345 0.14012225 0.00866635 - 1.1206967 -1.15837163 0.6603374 0.81390384 1.08039791 1.1037203 0.13179554 0.05906428 Here SRES - Standardized residual, TRES - Studentized deleted residuals, HI - leverage values, COOK - Cook's distance. a) Develop an estimated regression equation to predict Weekly Gross Revenue (y) using Television Advertising (x1) and Newspaper Advertising (x2) as the independent variables. b) Interpret the coefficients of the Television Advertising (X1) c) Interpret the coefficients of the Newspaper Advertising (X2) d) Are there any outliers? Please use each of the two methods of standardized residuals, standardized deleted residuals SEPERATELY to detect outliers. Explain them clearly. e) Are there any influential observations? Please use each of the two methods of leverages, and Cook's Distances SEPERATELY to detect influential observations. Explain them clearlyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started