Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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 clearly

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Cost Accounting

Authors: William Lanen, Shannon Anderson, Michael Maher

3rd Edition

9780078025525, 9780077517359, 77517350, 978-0077398194

More Books

Students also viewed these Accounting questions

Question

Show that P{Ta Answered: 1 week ago

Answered: 1 week ago