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)
10.6		8.8		9.0		9.5
8.5		6.4		10.0		9.8
12.5		10.8		7.5		6.6
9.0		10.2		10.0		10.1
5.5		6.0		6.0		6.1
12.0		11.1		12.0		11.3
8.0		7.5		10.5		8.8
7.5		8.4

  Click here for the Excel Data File

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?

rev: 10_17_2017_QC_CS-102203

Answer 1

Please check the given data is same or not?

July	Fall festival
10.6	8.8
8.5	6.4
12.5	10.8
9	10.2
5.5	6
12	11.1
8	7.5
7.5	8.4
9	9.5
10	9.8
7.5	6.6
10	10.1
6	6.1
12	11.3
10.5	8.8

Fall= 1.721+0.762 july

Coefficients

Term	Coef	SE Coef	T-Value	P-Value	VIF
Constant	1.72	1.12	1.53	0.149
July	0.762	0.119	6.42	0.000	1.00

ANOVA table
Source	SS	df	MS	F	p-value
Regression	36.677	1	36.677	41.25	0.000
Residual	11.559	13	0.889
Total	48.236	14

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

Yes, the amount spent on fireworks related to attendance at the Fall Festival.

Reject null hypothesis. There is sufficient evidenec that amount spent on fireworks related to attendance at the Fall Festival.