Question

# The lengths of stay of 20 patients hospitalized with a digestive dis- order are as follows:...

The lengths of stay of 20 patients hospitalized with a digestive dis- order are as follows: 10, 4, 5, 8, 5, 7, 9, 11, 4, 3, 6, 9, 8, 5, 13, 4, 6, 8, 9, 3 Similarly, the lengths of stay of 15 patients hospitalized with coro- nary heart disease are as follows: 11, 13, 16, 12, 5, 8, 9, 5, 6, 7, 4, 8, 9, 7, 8

Use Excel to find the mean, the mode, the median, the standard deviation, the range, and the co- efficient of skewness for both sets of data.

In addition, use Excel to find the 1st quartile, the 3rd decile, and the 40th percentile.

 10 11 4 13 5 16 8 12 5 5 7 8 9 9 11 5 4 6 3 7 6 4 9 8 8 9 5 7 13 8 4 6 8 9 3 Mean 6.85 8.533333 =AVERAGE(H7:H26) Mode 4 8 =MODE(H7:H26) Median 6.5 8 =MEDIAN(H7:H26) SD 2.72534 3.180496 =STDEV.P(H7:H26) Skewness 0.443824 0.824516 =SKEW(H7:H26) 1 st quartile 4.75 6.5 =QUARTILE(H7:H26,1) 3rd Decile 5 7 =PERCENTILE(H7:H26,0.3) 40th Percentile 5.6 7.6 =PERCENTILE(H7:H26,0.4)

#### Earn Coins

Coins can be redeemed for fabulous gifts.