Week 6 Assignment Understanding Confidence Intervals - Excel

QuestionA company wants to determine a confidence interval for the average CPU time of its teleprocessing transactions. A sample of 70 random transactions in milliseconds is given below. Assume that the transaction times follow a normal distribution with a standard deviation of 600 milliseconds. Use Excel to determine a 98% confidence interval for the average CPU time in milliseconds. Round your answers to the nearest integer and use ascending order.A sample of 22 test-tubes tested for number of times they can be heated on a Bunsen burner before they crack is given below. Assume the counts are normally distributed. Use Excel to construct a 99 % confidence interval for . Round your answers to two decimal places and use increasing order.QuestionSuppose scores on exams in statistics are normally distributed with an unknown population mean. A sample of 26 scores is given below. Use Excel to find a 90 % confidence interval for the true mean of statistics exam scores. Round your answers to one decimal place and use increasing order.QuestionSuppose that the scores of bowlers in a particular league follow a normal distribution such that the standard deviation of the population is 12 . Find the 95 % confidence interval