Question

Data on advertising expenditures and revenue (in thousands of dollars) for the Restaurant follow.

Advertising Expenditures	Revenue
1	20
2	33
4	45
6	40
10	53
14	54
20	55

Let x equal advertising expenditures and y equal revenue. Complete the estimated regression equation below.

y = 1.47 + 30.87

Test whether revenue and advertising expenditures are related at a .05 level of significance.

SSE =

SST =

SSR =

MSR =

MSE=

F test statistic =

P-value =

Answer 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.8328
R Square	0.6936
Adjusted R Square	0.6323
Standard Error	7.8548
Observations	7
ANOVA
	df	SS	MS	F	Significance F
Regression	1	698.370	698.370	11.319	0.020
Residual	5	308.487	61.697
Total	6	1006.857
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	30.196	4.793	6.300	0.001	17.874	42.518
X Variable 1	1.555	0.462	3.364	0.020	0.367	2.743

__________________________________________________

I have used Excel DATA > DATA ANALYASIS > REGRESSION > SELECT THE DATA > OK

========================================================

SSE = 308.487

SST = 1006.857

SSR = 698.370

MSR = 698.370

MSE = 61.697

F STATS = 11.319

p-VALUE = 0.020