1. Engineering
  2. Mechanical Engineering
  3. using excel find the value of the 95 confidence interval...

Question: using excel find the value of the 95 confidence interval...

Question details

Using Excel, find the value of the 95% confidence interval for a single sample using both the z variable and the students t-distribution where the mean is 10.00 with a standard deviation of 0.50. When calculating the confidence interval for the z-value, assume any value of n is a large sample, and when calculating the confidence interval for the for the students t-distribution, assume any value of n is a small sample. Compute the confidence intervals for: a. n 50 b. n 100 c. n 1000 (Be sure to list the Excel formulas you used to obtain the z and t-values.)

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution