A company has recorded data on the weekly sales for its product (y), the unit price of the competitor's product (x₁), and advertising expenditures (x₂). The data resulting from a random sample of 7 weeks follows. Use Excel's Regression Tool to answer the following questions. A)What is the estimated regression equation? B)Determine whether the model is significant overall. Use $\alpha$ = 0.10. C)Determine if price is significantly related to sales. Use $\alpha$= 0.10. D)Determine if advertising is significantly related to sales. Use $\alpha$ = 0.10. E)Find and interpret the multiple coefficient of determination.

Question

Quizplus · Accepted Answer

The Answer of A company has recorded data on the weekly sales for its product (y), the unit price of the competitor's product (x₁), and advertising expenditures (x₂). The data resulting from a random sample of 7 weeks follows. Use Excel's Regression Tool to answer the following questions. A)What is the estimated regression equation? B)Determine whether the model is significant overall. Use $\alpha$ = 0.10. C)Determine if price is significantly related to sales. Use $\alpha$= 0.10. D)Determine if advertising is significantly related to sales. Use $\alpha$ = 0.10. E)Find and interpret the multiple coefficient of determination.

A Company Has Recorded Data on the Weekly Sales for Its