My Home MS Excel Activity 8 Courses Catalog and Study Tools Rental Options College Success Tips Question 1 0/10 Submit Video The average waiting time for a patient at an El Paso physician's office is just over 29 minutes, well above the national average of 21 minutes. In fact, El Paso has the longest physician's office waiting times in the United States. In order to address the issue of long patient wait times, some physician's 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 Excel Online file below contains the data showing wait times (minutes) for a sample of patients at offices that do not have an office tracking system and wait times for a sample of patients at offices with an office tracking system. Construct a spreadsheet to answer the following questions. Career Success Tips Open spreadsheet ? Help B Give Feedback a. What are the mean and median patient wait times for offices with a wait tracking system? What are the mean and median patient wait times for offices without a wait tracking system? Round your answers to 1 decimal place. Mean Median Without Wait Tracking System With Wait Tracking System b. What are the variance and standard deviation of patient wait times for offices with a wait tracking system? What are the variance and standard deviation of patient wait times for visits to offices without a wait tracking system? Please round the answers to 2 decimal place. Without Wait Tracking System With Wait Tracking System Variance Standard deviation c. Do offices with a wait tracking system have shorter patient wait times than offices without a wait tracking system? (i) Offices with a wait tracking system have substantially longer patient wait times than offices without a wait tracking system. (ii) Offices with a wait tracking system have substantially shorter patient wait times than offices without a wait tracking system. (iii) Offices with a wait tracking system have about the same patient wait times as offices without a wait tracking system. Choose the correct option. d. Considering only offices without a wait tracking system, what is the z-score for the tenth patient in the sample (to 2 decimals)? e. Considering only offices with a wait tracking system, what is the z-score for the sixth patient in the sample (to 2 decimals)? How does this z-score compare with the z-score you calculated for part (d)? (i) The z-score for the sixth patient in the sample who visited an office with a wait tracking system could not be compared with the z-score calculated for part (d). Back Nex My Home MS Excel Activity 8 Courses Question 1 0/10 Catalog and Study Tools Submit Rental Options College Success Tips Career Success Tips Help Give Feedback Variance Tracking System Tracking System Standard deviation c. Do offices with a wait tracking system have shorter patient wait times than offices without a wait tracking system? (i) Offices with a wait tracking system have substantially longer patient wait times than offices without a wait tracking system. (ii) Offices with a wait tracking system have substantially shorter patient wait times than offices without a wait tracking system. (iii) Offices with a wait tracking system have about the same patient wait times as offices without a wait tracking system. Choose the correct option. d. Considering only offices without a wait tracking system, what is the z-score for the tenth patient in the sample (to 2 decimals)? e. Considering only offices with a wait tracking system, what is the z-score for the sixth patient in the sample (to 2 decimals)? How does this z-score compare with the z-score you calculated for part (d)? (i) The z-score for the sixth patient in the sample who visited an office with a wait tracking system could not be compared with the z-score calculated for part (d). (ii) The z-score for the sixth patient in the sample who visited an office with a wait tracking system is much larger only because that patient is part of a sample with a smaller mean. (iii) The z-score for the sixth patient in the sample who visited an office with a wait tracking system is much larger only because that patient is part of a sample with a smaller standard deviation. (iv) The z-score for the sixth patient in the sample who visited an office with a wait tracking system is much larger because that patient is part of a sample with a smaller mean and a smaller standard deviation. Choose the correct answer. f. Based on z-scores, do the data for offices without a wait tracking system contain any outliers? Round your answers to 2 decimal places. Patient's z-scores 1st 2nd 3rd 4th 5th 6th 7th 8th 9th 10th Without Wait Tracking System With Wait Tracking System MMMM Based on z-scores, do the data for offices with a wait tracking system contain any outliers? Back Next A-Z Offi A+