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, please include 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 margin of error form, i.e., sample mean ± margin of error.