Question

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.

Answer 1

	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.725344	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)