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.5 | 7.2 | 9.0 | 9.5 | ||||
8.5 | 6.4 | 9.4 | 12.6 | ||||
11.4 | 11.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 | 12.9 | 12.5 | ||||
8.0 | 7.5 | 13.5 | 11.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?
4th of July ($000) | Fall Festival (000) |
9.5 | 7.2 |
8.5 | 6.4 |
11.4 | 11.4 |
9 | 10.2 |
5.5 | 6 |
12 | 11.1 |
8 | 7.5 |
7.5 | 8.4 |
9 | 9.5 |
9.4 | 12.6 |
7.5 | 6.6 |
10 | 10.1 |
6 | 6.1 |
12.9 | 12.5 |
13.5 | 11.8 |
...........................................................................................................................................................
Determine the regression equation. (Round your answers to 3 decimal places.)
Fall = 1.230+0.851*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.)
Coefficients
Term | Coef | SE Coef | T-Value | P-Value | |
Constant | 1.230 | 1.531 | 0.804 | 0.436 | |
4th of July ($000) | 0.851 | 0.160 | 5.332 | 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 | SS | df | MS | F | p-value |
Regression | 55.941 | 1.000 | 55.941 | 28.435 | 0.000 |
Residual | 25.575 | 13.000 | 1.967 | ||
Total | 81.516 | 14.000 |
Is the amount spent on fireworks related to attendance at the Fall Festival?
There is sufficient evidence to conclude that the amount spent on fireworks related to attendance at the Fall Festival
Get Answers For Free
Most questions answered within 1 hours.