Question

The director of special events for Sun City believed that the amount of money spent on fireworks displays on the 4th of July was predictive of attendance at the Fall Festival held in October. She gathered the following data to test her suspicion.

4th of July ($000)		Fall Festival (000)		4th of July ($000)		Fall Festival (000)
9.9		5.7		9.0		9.5
8.5		6.4		9.7		13.1
11.6		12.4		7.5		6.6
9.0		10.2		10.0		10.1
5.5		6.0		6.0		6.1
12.0		11.1		11.6		7.5
8.0		7.5		9.7		10.9
7.5		8.4

Determine the regression equation. (Round your answers to 3 decimal places.)

Complete the given table. (Leave no cells blank - be certain to enter "0" wherever required. Round Coefficient, SE Coefficient, p-value to 3 decimal places and t to 2 decimal places.)

Complete the ANOVA table. (Leave no cells blank - be certain to enter "0" wherever required. Round SS, MS, p-value to 3 decimal places and F to 2 decimal places.)

Is the amount spent on fireworks related to attendance at the Fall Festival?

Answer 1

Appying regression from excel: data-data analysis:

a) y^ =1.825+0.768x   (please try 0.768x+1.825 if slope to be presented first)

b)

	Coefficients	Standard Error	t Stat	P-value
Intercept	1.825	2.582	0.71	0.492
x	0.768	0.280	2.75	0.017

c)

	df	SS	MS	F	Significance F
Regression	1	30.883	30.883	7.54	0.017
Residual	13	53.270	4.098
Total	14	84.153

(please take care of df and SS column values)

d)

since p value <0.05

amount spent on fireworks is related to attendance at the Fall Festival