Problem 1

Use Excel to develop two simple regression models for the Hospital Database at a 5% significance level.

Model 1: Predict the number of Personnel by the number of Births

Model 2: Predict number of Personnel by number of Beds

PART 1: Perform a simple linear regression analysis in Excel for both models and output the results.Include the Regression Statistics, ANOVA, and table of Coefficients for each model.

PART 2: Perform a test for the overall model for model 1 and model 2.Clearly state the hypotheses, the p-value, and your decision and conclusion for each model.

PART 3: For model 1 and model 2, write the model using the Excel output.

PART 4: Perform a residual analysis using Excel on each model.How many residuals are within 1 standard error for each model?(Do not output all residuals, use your Excel output to answer this question).

PART 5: Which model (1 or 2) is stronger at predicting number of Personnel?Why?

mostly need help with explanation part 1-5

\f\f\f\f