Question

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 singles sold($000). The marketing manager is arguing that the company should spend more money on advertising, while a market researcher suggests it should focus more on making its brand and product more distinct from its competitors.

The company has divided the United Stated into 26 marketing districts. In each district it collected information (Please check the Data for Homework on Moodle) 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.

Please conduct regression analysis and demand estimation (show all five steps and the details), then give the managers some suggestions.

(For computing elasticity, assume Adv=8. Number of accounts=30, number of competitors=12, market potential=8)

Sales	Ad Dollars	Number of accounts	Number of Competitors	Potential
79.3	5.5	31	10	8
200.1	2.5	55	8	6
163.2	8	67	12	9
200.1	3	50	7	16
146	3	38	8	15
177.7	2.9	71	12	17
30.9	8	30	12	8
291.9	9	56	5	10
160	4	42	8	4
339.4	6.5	73	5	16
159.6	5.5	60	11	7
86.3	5	44	12	12
237.5	6	50	6	6
107.2	5	39	10	4
155	3.5	55	10	4
291.4	8	70	6	14
100.2	6	40	11	6
135.8	4	50	11	8
223.3	7.5	62	9	13
195	7	59	9	11
73.4	6.7	53	13	5
47.7	6.1	38	13	10
140.7	3.6	43	9	17
93.5	4.2	26	8	3
259	4.5	75	8	19
331.2	5.6	71	4	9

Answer 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.995
R Square	0.989
Adjusted R Square	0.987
Standard Error	9.604
Observations	26.000

ANOVA
	df	SS	MS	F	Significance F
Regression	4	176777.06	44194.27	479.10	2.65E-20
Residual	21	1937.14	92.24
Total	25	178714.20

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	178.320	12.96	13.76	0.00	151.37	205.27	151.37	205.27
Ad Dollars	1.807	1.08	1.67	0.11	-0.44	4.06	-0.44	4.06
Number of accounts	3.318	0.16	20.37	0.00	2.98	3.66	2.98	3.66
Number of Competitors	-21.185	0.79	-26.89	0.00	-22.82	-19.55	-22.82	-19.55
Potential	0.325	0.47	0.69	0.50	-0.65	1.30	-0.65	1.30

regression equation

Sales = 178.32 + 1.81*(Ad Dollars) + 3.32*(Number of accounts ) - 21.18*(Number of Competitors) + 0.32*(Potential)

R Square

0.98

good relatipnship

sales at  Adv=8. Number of accounts=30, number of competitors=12, market potential=8

sales =178.32+(1.807*8)+(3.318*30)-(21.185*12)+(0.325*8)

=40.71

please revert back for doubt