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 JulyFall Festival 4th of July Fall Festival $000) (000) ($000) (000) 10.3 10.2 9.0 9.5 8.5 6.4 10.2 12.2 12.2. 12.9 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.5 8. 7.5 12.4 7.5 8.4 10.6 9.4 picture click here for the Excel Data File Determine the regression equation. (Round your answers to 3 decimal places.) Fall = 1 July Complete the given table. (Leave no cells blank - be certain to enter "O" wherever required. Round Coefficient, SE Coefficient, p. value to 3 decimal places and tto 2 decimal places.) Predictor Coefficient SE Coefficient 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 Fto 2 decimal places.) DF SSMS F p-value Source Regression Residual Error Total Is the amount spent on fireworks related to attendance at the Fall Festival? There between attendance at the Fall Festival and the fireworks

Answer 1

i am using minitab to solve the problem.

steps:-

copy the data in minitab stat regression regression fit regression model in responses select fall festival, in continuous predictors select 4 th of july results tick coefficients,analysis of variance okok.

to round off your answer to 3 decimal places right click on the value you want to round off decimal places 3

your minitab output be:-

Regression Analysis: fall festival versus 4 th of july

Analysis of Variance

Source	DF	Adj SS	Adj MS	F-Value	P-Value
Regression	1	47.751	47.751	29.03	0.000
4 th of july	1	47.751	47.751	29.03	0.000
Error	13	21.386	1.645
Lack-of-Fit	11	19.521	1.775	1.90	0.395
Pure Error	2	1.865	0.933
Total	14	69.137

Coefficients

Term	Coef	SE Coef	T-Value	P-Value	VIF
Constant	1.276	1.498	0.85	0.410
4 th of july	0.846	0.157	5.39	0.000	1.00

SOLUTION TO THE PROBLEM:-

a).the regression equation be:-

b).the completed table be:-

predictor	coefficient	SE coefficient	t	p value
constant	1.276	1.498	0.85	0.410
july	0.846	0.157	5.39	0.000

c).the ANOVA table be:-

source	DF	SS	MS	F	p value
regression	1	47.751	47.751	29.03	0.000
residual error	13	21.386	1.545	0	0
total	14	69.137	0	0	0

d).there is significant relationship between attendance at the fall festival and the fireworks.

[ p value of F statistic = 0.000 < 0.05 (alpha).

so, we reject the null hypothesis and conclude that your sample data provide sufficient evidence to conclude that the regression model fits the data better than the model with no independent variables.]

***in case of doubt, comment below. And if u liked the solution, please like.