Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Michael Sullivan

10th Global Edition

1292121772, 1292121777, 978-1292121772

More Books

Students also viewed these Mathematics questions