can this problem be solved in excel? if so can you please show me how to get the answer through excel

x Book 9.x/sx X Bb Blackboard Collaborate Ultra - E X > Bb Collaborate - Wednesday ses: X Do Homework - Duaa Ashkar X C Recal That To Construct A Confic X + X - > C A mathxl.com/Student/PlayerHomework.aspx?homeworkld=5811 11022&questionld=9&flushed=false&cld=6139192&back=https://www.mathxl.com/Student/DoAssignments.aspx?tc_profile_.. Business Statistics - BUS 3700-01 Duaa Ashkar & | 11/10/20 4:56 PM Homework: Chap 12 Homework Save Score: 0 of 15 pts 9 of 14 (14 complete) HW Score: 60.08%, 48.07 of 80 pts X 12.2.19-T Question Help Recall that to construct a confidence interval for the mean when the population standard deviation is unknown, the population must follow the normal probability distribution. To test this condition, the following data show a random sample of weekly visits by patients to a chiropractic office. Complete parts a and b below. Click the icon to view the weekly patient visit data. State tit appropiait null anu antemauve nypoleses. CHOOSE The CUITcut anIsWel UCIOW. A. Ho: The number of weekly patient visits does not follow the normal distribution. Hj: The number of weekly patient visits follows the normal distribution. J B. Ho: The mean number of weekly patient visits is 101.9 Observed weekly patient visits - X H1: The mean number of weekly patient visits is greater than 101.9. C. He: The number of weekly patient visits follows the normal distribution. Hy: The number of weekly patient visits does not follow the normal distribut 75 98 112 130 130 115 116 126 126 73 79 85 75 O D. Ho: The mean number of weekly patient visits is 101.9. 70 71 84 100 97 98 97 89 Hy : The mean number of weekly patient visits is less than 101.9. 92 103 107 101 111 111 115 114 115 110 110 124 105 Use the following intervals to calculate the chi-square test statistic, x2. Interval 1: 2 5 -1.0 Print Done Interval 2: - 1.0