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

1) Plot the data using either the histogram function in excel or by hand.

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

PLEASE SHOW HOW TO MAKE THE HISTOGRAM IN EXCEL

Answer 1

Since no specific ranges are mentioned, we could choose a range ourselves. However the best practice is to choose a comparatively reasonable range. From the data we can see that the minimum value is 84 and maximum value is 224. This means we can make a total range of 80-230 and divide them into 5 equal parts with a range of 30 each. This means it will be 80 to 109, 110 to 139, and so on. Till we reach 229.

Now, in order to do this, we need to create the upper ranges called the bins. The picture below should describe what is meant.

Next, we open the data tab and choose “Data Anlaysis”. From the list, choose “Histogram” as the option.

Use the raw data as input range and the Bin data as the bin. Check the box to generate chart output.

Finally click ok to generate the result