Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A householdappliance manufacturer wants to analyze the relationship between total sales and the company's three primary means of advertising, by type, for each of 10
A householdappliance manufacturer wants to analyze the relationship between total sales and the company's three primary means of advertising, by type, for each of 10 randomly 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. 0 Click the icon to view the computer output. K 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. 0 A. 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, 0 B. A multiple linear regression model appears to be appropriate because the predictor variables seem to have a linear relationship with one another. 0 c. 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. 0 D. 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 = + 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, $4.6 million, and $5.4 million, respectively. The predicted total sales is $ million. (Round to two decimal places as needed.) The regression equation is SALES = 266 + 6.73TV + 3.21MAG + 4.50RADIO Predictor Coef SE Coef = P Constant 266.44 16.16 16.49 0.000 TV 6.730 1.329 5.07 0.002 MAG 3.211 1.623 1.98 0.095 RADIO 4.500 3.660 1.23 0.265 S = 4.367 R-SQ = 91.2% R-SQ(adj) = 86.8% Analysis of Variance Source DF SS MS F P Regression 3 1189.11 396.37 20.78 0.001 Residual Error 6 114.43 19.07 Total CO 1303.54
Step 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