Question: Based on the regression model, forecast the expected production volume when there are 112 factory workers. HOME INSERT DATA fx A B C D E
Based on the regression model, forecast the expected production volume when there are 112 factory workers. HOME INSERT DATA fx A B C D E G 1 SUMMARY OUTPUT Dependent Variable: Expected Production 2 Production Volume (# units produced] Volume 3 Regression Statistics 4 Multiple R 0.7587 5 R Square 0.5756 6 Adjusted R Square 0.5521 7 Standard Error 14,994.93 8 Observations 20 ANOVA 10 dif MS F Significance F 11 Regression 5.49E+09 5.49E+09 24.42 0.0001 12 Residual 18 4.05E+09 2.25E+08 13 Total 19 9.54E+09 14 Coefficients Standard Error t Stat P-value Lower 95%% Upper 959 5 Intercept 64,720.33 36,722.07 -1.76 0.0950 -141,870.54 12 429.80 16 Number of Workers 1,638.96 331.69 4.94 0.0001 942.13 2,335.8 17 18 19 RESET SAVE SUBMIT Attempts left: 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
