https://mobidrive.com/sharelink/x/7M6aXbXYm0apSlUhCksNkk72dtrbMHT6UDpMMCBDWQWu

Excel Tasks:Using the Medical Expenses dataset, please compute the following in Excel.

• Calculate mean, standard deviation, and the z-score for each individual value.
• Use this data to determine whether the values are outliers.
• Use the Countif function to find how many outliers there are in your data.

Next create a regression model that will predict medical expenses by the other variables listed in each column.

Analysis of Results:

1. Are all the variables statistically significant in predicting the medical expenses of a patient?

1. What equation would you use to predict the medical expenses of a patient who is not part of this sample?

1. Use the equation from (2) to predict the medical expenses of someone who is 34, female, 32 BMI, 2 children, and a smoker.

Do you think this model would accurately predict the medical costs of a patient given the following information? If not, what additional predictors could the model include to improve the prediction? Could the data be adjusted