A Household Appliance Manufacturer Wants To Analyze The Relationship Between Total Sales And The Company S Three Primary 1 (73.48 KiB) Viewed 35 times
A household appliance manufacturer wants to analyze the relationship between total sales and the company's three primary means of advertising, by type, for each of 10 randorrily selected sales periods. All data are in millions of dollars. A multiple regression analysis on the data using the variables television, magazine, and radio advertising expenditures as predictor variables for sales was performed. Complete parts a) though c) below. Click the icon to view the computer output. Click the icon to view the scatterplot matrix. a. Use the scatterplot matrix to assess whether a multiple linear regression model might be appropriate for predicting sales. Choose the correct answer below. OA. A multiple linear regression model does not appear to be appropriate because the predictor variables do not seem to have a linear relationship with one another. OB. A multiple linear regression model appears to be appropriate because the predictor variables seem to have a linear relationship with one another OC. A multiple linear regression model does not appear to be appropriate because sales does not seem to have a linear relationship with each of the predictor variables OD. A multiple linear regression model appears to be appropriate because sales seems to have a linear relationship with each of the predictor variables. b. Use the computer output to obtain the sample regression equation for sales in terms of television, magazine, and radio advertising expenditures. SALES-O+Tv+MAG+ RADIO (Type integers or decimals.) c. Apply the sample regression equation to predict total sales if the amounts spent on television, magazine, and radio advertising are $9.5 million, 54.6 million, and $5.4 million, respectively. The predicted total sales is $ million. (Round to two decimal places as needed.)
- > Computer Output The regression equation is SALES = 266 + 6.73TV +3.21MAG + 4.50RADIO Predictor Coef SE Coef T Р Constant 266.44 16.16 16.49 0.000 TV 6.730 1.329 5.07 0.002 MAG 3.211 1.98 0.095 1.623 3.660 RADIO 4.500 1.23 0.265 S = 4.367 R-SQ = 91.2% R-SQ(adj) = 86.8% Analysis of Variance DF F 20.78 P 0.001 3 Source Regression Residual Error Total MS 396.37 19.07 SS 1189.11 114.43 1303.54 6 9
- X Scatterplot Matrix SCATTERPLOT MATRIX - ADVERTISING DATA 376.625 354.875 SALES 9.525 7.375 TV 5.175 MAG 3.525 6.025 5.275 RADIO 354.875 376.625 7.375 9.525 3.525 5.175 5.275 6.025 Print Done
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!