SEND EXCEL FILE

1.Compute and interpret the point and interval estimates of parameters.

2.Compute and interpret the length of the interval formed.

3.Solve each problem using Microsoft Excel.

TASKS

Read and understand each item carefully. Identify the appropriate probability distribution and use Microsoft Excel as a tool to solve each problem.

1. The contents, in milliliters (mL), of 16 similar bottles of Bignay Wine are as follows: 498, 490, 502, 500, 500, 492, 493, 501, 503, 489, 495, 504, 500, 500, 496 and 506. Assuming the contents is normally distributed, determine the following:

a. The 95% CI for the mean contents of all the bottles of Bignay Wine.

b. The length of the 95% CI Interval for the mean contents of all the bottles of Bignay Wine.

2.The contents of 10 similar containers of sulfuric acid are 9.8, 10.2, 10.4, 9.8, 10.0, 10.2, 8.5, 8.9, 10.0 and 9.6 liters. Find a 99% confidence interval for the mean content of all such containers, assuming an approximate normal distribution for container contents.

3.A random sample of 100 automobile owners shows that an automobile is driven on the average 23,500km per year, in the state of Virginia, with a standard deviation of 3,900 kilometers.

a. Construct a 99% confidence interval for the average number of km. An automobile is driven annually in Virginia.

b. What can we assert with 99% confidence about the possible size of our error if we estimate the average number of km driven by car owners in Virginia to be 23,500 km per year?

4.An engineer developed a new concrete hollow blocks (CHB) use for house construction. He tested 15 samples for compressive strength, in psi, and obtained the following results: 875, 935, 978, 830, 902, 961, 888, 847, 910, 902, 894, 930, 878, 841 and 839.

a. Find the 90% confidence interval for the mean compressive strength of the new developed CHB.

b. Compute the length of the interval.