Please help me submit answers on an excel sheet as well.

Suppose that the average waiting time for a patient at a physician's office is just over 29 minutes. In order to address the issue of long patient wai some physicians' ofces are using wait-tracking systems to notify patients of expected wait times. Patients can adjust their arrival times based on information and spend less time in waiting rooms. The following data show wait times (in minutes) for a sample of patients at offices that do not h tracking system and wait times for a sample of patients at ofces with a wait-tracking system. Without Wait With Wait- Tracking System Tracking System 23 3 1 62 10 15 13 21 17 32 1 1 45 35 10 10 26 2 16 1 1 35 16 (a) What are the mean and median patient wait times for ofces with a wait-tracking system? If required, round your answer to two decimal places. Mean = Median What are the mean and median patient wait times for ofces without a wait-hacking system? If required, round your answer to two decimal places. Mean = Median (b) What are the variance and standard deviation of patient wait times for offices with a wait-tracking system? If required, round your answer to two decimal places. Do not round intermediate calculations. Variance = Standard deviation = DD What are the variance and standard deviation of patient wait times for visits to ofces without a waittracking system? If required, round your answer to two decimal places. Do not round intermediate calculations. Variance = Standard deviation = DD (c) Choose the correct box plot for patient wait times for offices without a wait-tracking system. (i) value an Value 30 30 20 20 10 10 Patients wait time with Wat-Tracking System Patients wait time without Wat-Tracking System (iii) Value (iv) Value 60 60 (i) [ Value (ii) LValue -60 -30 -50 -40 -20 -30 -10 -20 -10 Patients wait time with Wait-Tracking System Patients wait time without Wait-Tracking System (iii) LValue (iv) [Value -60 -30 -50 -40 -20 -30 -20 -10 -10 Patients wait time with Wait-Tracking System Patients wait time with Wait-Tracking System - Select your answer -(e) Do offices with a wait-tracking system have shorter patient wait times than offices without a wait-tracking system? - Select your answer - + Explain. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank