The director of special events for Sun City believed that the amount of money sp
ID: 3266322 • Letter: T
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.
Complete the given table. (Leave no cells blank - be certain to enter "0" wherever required. Round Coef, SE Coef, P 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 to 3 decimal places and F to 2 decimal places.)
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.
Explanation / Answer
applying regression function of excel on above:
1)
regression equation : Fall =1.638 +0.771*July
2) table:
3)
table:
4) There is substantial connection between attendance at the Fall Festival and the fireworks.
please revert for any clarification needed,
Coefficients Standard Error t Stat P-value constant 1.638 1.619 1.01 0.330 July 0.771 0.169 4.55 0.001