Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SEMO is trying to forecast the number of people who attend graduation (i.e., family and friends) based on the number of students who have completed
SEMO is trying to forecast the number of people who attend graduation (i.e., family and friends) based on the number of students who have completed their degree requirements. You have input the data into Excel and obtained the following output. State the regression model that should be used for forecasting, comment on the significance of the model, and predict graduation attendance when 1,200 students have completed degrees. SUMMARY OUTPUT Regression Statistics Multiple R 0.993460507 R Square 0.986963779 Adjusted R 0.983704724 Square Standard 118.4951302 Error Observations 6 ANOVA df SS MS F Significance F Regression 1 4252168.95 4252168.95 302.8373984 6.40076E-05 Residual 4 56164.38356 14041.09589 Total 5 4308333.333 Standard Coefficients t Stat P-value Lower 95% UpF Error Intercept -879.4520548 325.1931885 -2.704398757 0.053848475 -1782.333091 23.4 X Variable 1 5.287671233 0.303850315 17.40222395 6.40076E-05 4.444047512 6.1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started