To address the issue of long patient wait times, some physicians' offices are using wait-tracking systems to notify patients of expected wait times. Patients can adjust their arrival times based on this 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 have a wait-tracking system and wait times for a sample of patients at offices with such systems. b Use Excel to do the necessary calculations and answer the questions given below. a. Compare the mean and median of wait times at offices without wait tracking systems and offices with wait tracking systems. Include calculated values in your answer. b. Compare the range, variance, and standard deviation of wait times at offices without wait tracking systems and offices with wait tracking systems. Include calculated values in your answer. c. Compare the coefficient of variation of wait times at offices without wait tracking systems and offices with wait tracking systems. Include calculated values in your answer. d. Compare the 90t" Percentile of wait times at offices without wait tracking systems and offices with wait for tracking systems. Include calculated values in your answer. e. Determine the three quartiles (Quartile 1, Quartile 2, and Quartile 3) and the Inter-quartile range for wait times at offices without wait tracking systems and offices with wait tracking systems. Include calculated values in your answer. f. Develop box plots for the wait times for offices without wait tracking systems and offices with wait tracking systems. Copy and paste the box plots below. Note: Highlight the data for offices without wait tracking systems and offices with wait tracking systems and then insert the box plots so that both the box plots can be on the same chart for better comparison. g. Do you recommend the use of a wait tracking system at the physician's offices? Give reasons for your