Question

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. What can you conclude from the study?

The number of personnel is not adding significant predictability to the number of births in a hospital. The number of births is not adding significant predictability to the number of personnel in a hospital. The number of personnel is adding significant predictability to the number of births in a hospital. The number of births is adding significant predictability to the number of personnel in a hospital.

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

Answer 1

Solution-

We have to predict the number of Personnel by the number of Births.

From the Summary Output provided -

Intercept = 390.6214398

Slope = 0.538734917

The regression equation is

Number of personals = 390.6214398 + ( 0.538734917 × Number of births )

Also, From ANOVA F value is very large and also p- value is less than significance level.

So, we can conclude

The number of births is adding significant predictability to the number of personals in a hospitals.