Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following analysis to answer the next two questions: Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair

image text in transcribed
Use the following analysis to answer the next two questions: Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair retailers, such as Lowe's and Home Depot, and commercial contractors. The owner is interested in studying the effects of several variables on the value of shingles sold ($000). The company has divided the United States into 26 marketing districts. In each district, it collected information on the following variables: volume of sales (in thousands of dollars), advertising dollars (in thousands), number of active accounts, number of competing brands, and a rating of district potential. A multiple regression analysis is conducted to find the best predictors of sales. Here is the partial output: Regression Statistics Multiple R 0.994565 583 R Square 5.989160699 Adjusted R Square 0.98709607 Standard Error 3.604406 128 Observations 26 ANOVA df 55 M5 Regression 4 176777.0615 44194.26538 479.0985835 Residual 21 1937.136959 92.24461707 Total 25 178714.1985 Coefficients Standard Error T Stor P-value Intercept 178.3203403 12.9603193 13.75894654 5.620018-12 Ad Dollars 1.807064337 1.08 1039338 1.67 159905 7 0.109439581 Number of accounts 3.31 7833433 0.162891757 20.3683 323 2.603158-15 Number of Competitors 21.18498417 0.787938989 -26.88657937 9.41469E-18 Potential D.3245 12401 D.46 7 764444 0.693751749 D.495440937 Here is the correlation matrix for the data: Sales Ad Dollars Number of accounts Number of Competitors Potential Sales Ad Dollars 0.158868405 Number of accounts 0.782844123 0.1725 50617 1 Number of Competitors -0.832980593 -0.038251573 -0.324287511 1 Potential D.407269529 -0.0705 647 0.468212872 0.202060353 9. The best predictor of sales is probably... A) advertising dollars spent. B) number of accounts. C) number of competitors. D) district potential rating. 10. Which of these statements is not correct? A) The significant predictors are also those most highly correlated with sales. B) Since Number of Competitors is very weakly correlated with Sales, that predictor should probably be dropped from the model. C) Ad Dollars spent has only a weak positive relationship with Sales. D) As the number of competitors increases, the number of accounts decreases

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

Strategic Management Theory And Practice

Authors: John A. Parnell

4th Edition

1452234981, 9781452234984

More Books

Students also viewed these General Management questions