• 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

all the parts to this problem:

• 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?

I don't understand part 1-5 using excel, can you please elaborate on each part? using the information I give

\f\f\f\f