link for data

https://1drv.ms/x/s!AsaOu_mw2MEmiGXI3zLqMEK3V2mo?e=NfmaoP

Excel Tasks: Using the Infection Risk dataset determine the following measures of central tendency.

• Mean
• Median
• Mode
• Standard deviation

Once you've found these measures, find a regression model that predicts the infection risk of patients using the other data recorded:

• Determine which columns might influence the chance that a patient is infected while they are in the hospital.
• Run a multiple regression that creates a model that predicts the infection risk of a patient using the columns you indicated.

Analysis of Results:

A. What is the typical age of a participant of this study? What is the range of patient ages that are within three standard deviations of the mean?

B. What variables will you use from the data to predict infection risk?

C. Is your regression model a good predictor of infection risk? Are all of the variables you selected statistically significant?