dence Interval for the Population Mean Description : ent study shows data for delivery times of international shipments for a logistics company. The company pro eiving multiple complaints that the delivery time is exceeding 7 days , the quality assurance team decided to de if they should adjust the delivery time the company promises customers with . We will find the average and ents . We will find values from the probability table using excel functions to construct confidence intervals usi a conclusion about the population . We will also analyze the width of the confidence levels . Assume that the selected ions : I reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values urpose of grading the project, you are required to perform the following tasks: Instructions Start Excel. Download and open the workbook named: Confidence Interval for the Population Mean Start n cell B3 , find the average delivery time for the sample of shipments from the Data sheet . n cell B4, find the standard deviation of the delivery times for the sample of shipments from the Data sheet In cell B5 , find the size of the sample of shipments from the Data sheet Hint : use the COUNT function To build the confidence Interval for the m of the delivery Data s the appropriate probab menu in cell B6 In cell B7, find the score from the appropriate probability table to construct a 90% confidence interval. Hint: use the T.INV.2T function. In cell B8, nd the margin of error at the 90% confidence level. Hint : use the CONFIDENCE .T function n cell B9 , find the the upper limit for the mean at the 90 % confidence level . n cell B10 , find the lower limit for the mean at the 90 % confidence level . Based on the number in cell B9 and B10 , we can be 90 % confident that : Choose the correct answer from the dropdown menu in cell B11. In cell B12, find the width of the confidence interval at the 90% confidence level. In cell B13, find the score from the appropriate probability table to construct a 99% confidence interval. n cell B14, find the margin of error at the 99% confidence level. In cell B15 , find the upper limit for the mean at the 99 % confidence level . n cell B16 , find the lower limit for the mean at the 99 % confidence level In cell B17, find the width of the confidence interval at the 99% confidence level. by comparing width confidence interval 1 90 % and 99 1 99 70 , what can conclude about th width of the e 318 Based on the upper and lower limit values for a 90 % confidence level , should the quality assurance team consider recom customers that they deliver international shipments within 7 days? Choose the correct answer from the dropdown menu Based on the upper and lower li limit values for a 99 % confidence level , should the quality assurance team consider recom customers that they deliver international shipments within 7 days? Choose the correct answer from the dropdown menu What options does the quality assurance team have to reduce their margin of error for the 99% confidence interval? Ch