Question

Let's assume the following data represents the time from when a patient is discharged from North Shore Hospital to the time the discharged patient's bed is ready to be assigned to a new patient is referred to as the bed assignment turnaround time. If the bed turnaround time is excessive, it can cause problems with patient flow and delay medical procedures throughout the hospital. This can cause long waiting times for physicians and patients, thus creating customer dissatisfaction. The admissions RN has assigned a patient care associate to measure the bed turnaround time for a randomly selected bed each morning, afternoon, and evening for 30 days. Following are the bed turnaround time sample observations.

QUESTION: Calculate the standard deviation and average for the data using excel. (Use the "stdev" and "average" functions you learned in your Statistics class.)

167, 127, 135, 128, 97,

112, 140, 155, 122, 223,

167, 145, 84, 146, 169,

216, 190, 178, 103, 115

104, 122, 105, 167, 98

125, 135, 115, 105, 140

SHOW WORK

Answer 1

We use excel formulas for calculation as shown below:

Average =AVERAGE(D3:H8)=137.8333=137.83 (rounding to two decimals)

Standard deviation=STDEV(D3:H8)=34.69879=34.70 (rounding to two decimals)