The below data is needed to answer the question

Use the accompanying Credit Risk data to find the standard deviation of the total assets held by the bank and complete parts a and b. Click here to view the population Credit Risk data. Click here to view the sample Credit Risk data. *+ Za/ 2 Vn and any appropriate Excel functions. Explain the differences as the level of confidence increases. Assuming that the population standard deviation is known, an 85% confidence interval for the mean total assets held in the bank by loan applicants is |] (Use ascending order. Round to two decimal places as needed.) Assuming that the population standard deviation is known, a 95% confidence interval for the mean total assets held in the bank by loan applicants is,|]. (Use ascending order. Round to two decimal places as needed.) Assuming that the population standard deviation is known, a 99% confidence interval for the mean total assets held in the bank by loan applicants is, I. (Use ascending order. Round to two decimal places as needed.) Explain the differences as the level of confidence increases. The 99% confidence interval is than the 95% confidence interval. The 99% confidence interval is than the 85% confidence interval. The 95% confidence interval is than the 85% confidence interval. So, as the level of confidence increases, the interval b. How do the confidence intervals differ if you assume that the population standard deviation is not known but estimated using your sample data? Assuming that the population standard deviation is not known, an 85% confidence interval for the mean total assets held in the bank by loan applicants is, (Use ascending order. Round to two decimal places as needed.) Assuming that the population standard deviation is not known, a 95% confidence interval for the mean total assets held in the bank by loan applicants is| |] (Use ascending order. Round to two decimal places as needed.) Assuming that the population standard deviation is not known, a 99% confidence interval for the mean total assets held in the bank by loan applicants is ].Compare the confidence intervals when assuming the population standard deviation is known and is unknown. The 85% confidence interval assuming the population standard deviation is known is than the 85% confidence interval assuming the population standard deviation is unknown. The 95% confidence interval assuming the population standard deviation is known is than the 95% confidence interval assuming the population standard deviation is unknown. The 99% confidence interval assuming the population standard deviation is known is than the 99% confidence interval assuming the population standard deviation is unknown