this is the excel data

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. x Ben seadsheel 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 walt tracking system? Round your answers to 1 decimal place, Without Wait With Wait Tracking System Tracking System Mean Median 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 With Wait Tracking System Tracking System Back Ney (hp) 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 (1) Offices with a wait tracking system have substantially longer patient wait times than offices without a wait tracking system. (u) omces with a wait tracking system have substantially shorter patient wait times than offices without a wait tracking system (m) 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 2-score for the tenth patient in the sample (to 2 decimals)? e. Considering only offices with a wait tracking system, what is the 2-score for the sixth patient in the sample (to 2 decimals)? How does this t-score compare with the score you calculated for part (d)? (1) The T-score for the sixth patient in the sample who visited an office with a wait tracking system could not be compared with the score Calculator for nart Idf Back hp tine score for the sixth patient in the sample who visited an ortice with a wait tracking system could not be compared with the score calculated for part (d). (II) The score for the sixth patient in the sample who visited an orfica with a wait tracking system is much larger only because that patient is part of a sample with a smaller mean. (III) The T-score for the sixth patient in the sample who visited an office with a walt tracking system is much larger only because that patient is part of a sample with a smaller standard deviation. (lv) The 2-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 or a sample with a smaller mean and a smaller standard deviation. Choose the correct answer. 1. Based on 2-scores, do the data for offices without a wait tracking system contain any outliers? Round your answers to 2 decimal places. Patient's Tracking System Tracking System Without Wait With Wait 2-scores 1st 2nd 3rd 4th 5th 6th Back hp 10th Based on 2-scores, do the data for offices with a wait tracking system contain any outliers? Check My Work Reset Problem Back hp General Paste lil LE Copy Format Painter Clipboard BIUROA - $ % % 8 Font Alignment Number D G Without Walt Tracking System F With Walt Tracking System Fom Part a Mean A Without Walt Tracking System 25 66 17 19 31 43 12 23 17 36 B With Walt Tracking System 31 11 13 19 12 36 8 14 12 15 Median Part b Variance Standard Deviation Part d Z-score, 10th patient Parte Z-score, 6th patient Part 1 1st Patient's Z-Score 2nd Patient's Z-Score 3rd Patient's Z-Score Ath Datan 7 CM Data + on Mode: Automatic Workbook Statistics hp LL 191 181 $ % Format Painter Clipboard 2008 Unda Font Alignment Number E3 B C D G Part d Z-score, 10th patient 12 13 14 15 -6 7 8 9 Parte Z-score, 6th patient 2 Part 1 1st Patient's Z-Score 2nd Patient's Z-Score 3rd Patient's Z-Score 4th Patient's Z-Score 5th Patient's Z-Score 6th Patient's Z-Score 7th Patient's Z-Score 8th Patient's Z-Score 9th Patient's Z-Score 10th Patient's Z-Score Data + ulation Mode: Automatic Workbook Statistics hp 1 I X Cut Arial 10 Paste BI U Dab [Copy * Format Painter Clipboard Font Undo E3 fx D Without Walt Tracking System 25 B With Walt Tracking System 31 11 13 19 Part a Mean 66 17 1 2 3 4 5 6 7. 8 9 10 Median 19 31 12 43 Part b Variance 12 23 17 36 36 8 14 12 15 Standard Devi 12 13 14 Part d Z-score, 10th 15 Parte Z-score. 6th pa 12 CHCO 3 Part f 1st Patient's Z 2nd Patient's Z 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. x Ben seadsheel 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 walt tracking system? Round your answers to 1 decimal place, Without Wait With Wait Tracking System Tracking System Mean Median 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 With Wait Tracking System Tracking System Back Ney (hp) 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 (1) Offices with a wait tracking system have substantially longer patient wait times than offices without a wait tracking system. (u) omces with a wait tracking system have substantially shorter patient wait times than offices without a wait tracking system (m) 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 2-score for the tenth patient in the sample (to 2 decimals)? e. Considering only offices with a wait tracking system, what is the 2-score for the sixth patient in the sample (to 2 decimals)? How does this t-score compare with the score you calculated for part (d)? (1) The T-score for the sixth patient in the sample who visited an office with a wait tracking system could not be compared with the score Calculator for nart Idf Back hp tine score for the sixth patient in the sample who visited an ortice with a wait tracking system could not be compared with the score calculated for part (d). (II) The score for the sixth patient in the sample who visited an orfica with a wait tracking system is much larger only because that patient is part of a sample with a smaller mean. (III) The T-score for the sixth patient in the sample who visited an office with a walt tracking system is much larger only because that patient is part of a sample with a smaller standard deviation. (lv) The 2-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 or a sample with a smaller mean and a smaller standard deviation. Choose the correct answer. 1. Based on 2-scores, do the data for offices without a wait tracking system contain any outliers? Round your answers to 2 decimal places. Patient's Tracking System Tracking System Without Wait With Wait 2-scores 1st 2nd 3rd 4th 5th 6th Back hp 10th Based on 2-scores, do the data for offices with a wait tracking system contain any outliers? Check My Work Reset Problem Back hp General Paste lil LE Copy Format Painter Clipboard BIUROA - $ % % 8 Font Alignment Number D G Without Walt Tracking System F With Walt Tracking System Fom Part a Mean A Without Walt Tracking System 25 66 17 19 31 43 12 23 17 36 B With Walt Tracking System 31 11 13 19 12 36 8 14 12 15 Median Part b Variance Standard Deviation Part d Z-score, 10th patient Parte Z-score, 6th patient Part 1 1st Patient's Z-Score 2nd Patient's Z-Score 3rd Patient's Z-Score Ath Datan 7 CM Data + on Mode: Automatic Workbook Statistics hp LL 191 181 $ % Format Painter Clipboard 2008 Unda Font Alignment Number E3 B C D G Part d Z-score, 10th patient 12 13 14 15 -6 7 8 9 Parte Z-score, 6th patient 2 Part 1 1st Patient's Z-Score 2nd Patient's Z-Score 3rd Patient's Z-Score 4th Patient's Z-Score 5th Patient's Z-Score 6th Patient's Z-Score 7th Patient's Z-Score 8th Patient's Z-Score 9th Patient's Z-Score 10th Patient's Z-Score Data + ulation Mode: Automatic Workbook Statistics hp 1 I X Cut Arial 10 Paste BI U Dab [Copy * Format Painter Clipboard Font Undo E3 fx D Without Walt Tracking System 25 B With Walt Tracking System 31 11 13 19 Part a Mean 66 17 1 2 3 4 5 6 7. 8 9 10 Median 19 31 12 43 Part b Variance 12 23 17 36 36 8 14 12 15 Standard Devi 12 13 14 Part d Z-score, 10th 15 Parte Z-score. 6th pa 12 CHCO 3 Part f 1st Patient's Z 2nd Patient's Z