Compute confidence intervals using Excel. You will submit a single Excel file that includes your results for all of the exercises.

Computing Confidence

In the following exercises, you will compute confidence intervals using Excel. You will submit a single Excel file that includes your results for all of the exercises. For each exercise, including the output from Toolpak, and make sure that you clearly show the following:

Confidence level
Whether you should use a normal distribution or t-distribution
Confidence interval in interval form, i.e.,
Confidence interval in the margin of error form, i.e., the sample mean ± margin of error.

A health care professional wants to determine the systolic blood pressure of individuals with hypertension who take Atenolol. Thirty such individuals have an average systolic blood pressure of 105, with a sample standard deviation of 23. Find the 95% confidence interval for mean systolic blood pressure for hypertensive individuals who take Atenolol.