We reconsider SteelCo from the previous two problems from a different point of view. Now we assume SteelCo doesn't know its process mean and standard deviation, so it uses sampling. The fileP19_64.xlsxlists 150 randomly sampled rod lengths.

a.Calculate a 95% confidence interval for the population mean length of all rods produced. Round your answers to three decimal places, if necessary.

Lower LimitUpper Limit

b.Continuing parta, find a 95% confidence interval for the population proportion that meet the specifications listed at the top of the spreadsheet (the same as in the previous problem). Round your answers to three decimal places, if necessary.

Lower LimitUpper Limit

c.Using the sample standard deviation found in partaas a best guess for the population standard deviation, how large a sample size is required to achieve a 95% confidence interval for the mean of the form "point estimate plus or minus 0.002"? Round your answer to the nearest whole number, if necessary.

https://docs.google.com/spreadsheets/d/17yq1pd1iTxvQG6wrbGKnzuHKsAKgnD0e1jdgFmpP-wI/edit?usp=sharing