Week 3 - Descriptive Analysis

Suppose that the average waiting time for a patient at a physician’s office is just over 29 minutes. 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 (See the attached) 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.

1. What do the mean and median patient wait times for offices with a wait-tracking system? What do the mean and median patient wait times for offices without a wait-tracking system?

2. 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?

3. Create a box plot for patient wait times for offices without a wait-tracking system.

4. Create a box plot for patient wait times for offices with a wait-tracking system.

5. Do offices with a wait-tracking system have shorter patient wait times than offices without a wait-tracking system? Explain.

6. Considering only offices without a wait-tracking system, what is the z-score for the 10th patient in the sample (wait time=37 minutes)?

7. Considering only offices with a wait-tracking system, what is the z-score for the 6th patient in the sample (wait time=37 minutes)? How does this z-score compare with the z-score you calculated for part a?

8. Based on z-scores, do the data for offices without a wait-tracking system contain any outliers? Based on z-scores, do the data for offices without a wait-tracking system contain any outliers?

Note:- Input excel file attached

Suppose that the average waiting time for a patient at a physician’s office is just over 29 minutes. 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 (See the attached) 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.

1. What do the mean and median patient wait times for offices with a wait-tracking system? What do the mean and median patient wait times for offices without a wait-tracking system?

2. 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?

3. Create a box plot for patient wait times for offices without a wait-tracking system.

4. Create a box plot for patient wait times for offices with a wait-tracking system.

5. Do offices with a wait-tracking system have shorter patient wait times than offices without a wait-tracking system? Explain.

6. Considering only offices without a wait-tracking system, what is the z-score for the 10th patient in the sample (wait time=37 minutes)?

7. Considering only offices with a wait-tracking system, what is the z-score for the 6th patient in the sample (wait time=37 minutes)? How does this z-score compare with the z-score you calculated for part a?

8. Based on z-scores, do the data for offices without a wait-tracking system contain any outliers? Based on z-scores, do the data for offices without a wait-tracking system contain any outliers?

Note:- Input excel file attached