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)
12.6		10.2		9.0		9.5
8.5		6.4		12.8		12.7
10.2		11.7		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.4		9.0
8.0		7.5		10.4		10.8
7.5		8.4

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

Fall = ________ + __________ July

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.)

Predictor	Coefficient	SE Coefficient	t	p-value
Constant
July

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.)   

Source	DF	SS	MS	F	p-value
Regression
Residual Error
Total

     

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

There is ____________ between attendance at the Fall Festival and the fireworks. (a substantial connection) (no substantial connection)

Answer 1

Using Toolpak data analysis in Excel:

First enter data:

Steps: Data-->Data Analysis

Select Fall data in Input Y Range and July in Input X Range.

Tick the lables becuase we selecting data with variable name and then click to OK.

Output:

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

Fall = 1.562 + 0.804 July

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.)

Predictor	Coefficient	SE Coefficient	t	P-value
Constant	1.562	1.377	1.13	0.277
July	0.804	0.143	5.61	0.000

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.)   

Source	DF	SS	MS	F	P-value
Regression	1	46.282	46.282	31.48	0.000
Residual Error	13	19.115	1.470	0	0
Total	14	65.397	0	0	0

There is a substantial connection between attendance at the Fall Festival and the fireworks.