Question

# Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file...

Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file on Blackboard) to predict the number of Personnel by the number of Births. Perform a test of the slope. What is the value of the test statistic? Write your answer as a number, round your answer to 2 decimal places.

 SUMMARY OUTPUT Regression Statistics Multiple R 0.697463374 R Square 0.486455158 Adjusted R Square 0.483861497 Standard Error 590.2581194 Observations 200 ANOVA df SS MS F Significance F Regression 1 65345181.8 65345181.8 187.5554252 1.79694E-30 Residual 198 68984120.2 348404.6475 Total 199 134329302 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 390.6214398 54.07601821 7.223561437 1.06764E-11 283.9825868 497.2602928 283.9825868 497.2602928 Births 0.538734917 0.039337822 13.69508763 1.79694E-30 0.461160045 0.616309789 0.461160045 0.616309789