Reference no: EM131181960

Exercise

Using data provided in table 1 (download attached file w1-exercise) and calculate the mean, median, and mode of the LOS of patients seen by each physician (round to one decimal point).

Calculate the variance and standard deviation of LOS by each physician (round to two decimal points). (Please post the solution using the discussion forum or attach your Excel or Word file with Exercise solution with your post).

Length of stay descriptive statistics by physician, 2009.
	Discharge Days (LOS)
Patient	Physician A	Physician B	Physician C	Physician D	Physician E
1	5	6	7	3	4
2	7	9	6	2	6
3	4	8	8	5	3
4	4	4	5	7	7
5	5	7	4	3	3
6	4	12	8	4	5
7	2	10	3	2	6
8	6	5	7	5	3
9	3	6	6	3	8
10	5	8	4	4	5
11	3	9	8	2	9
12	4	6	12	7	4
13	7	13	5	4	3
14	9	5	4	3	6
15	3	7	8	6	4
16	4	7	5	3	7

 

Requriments:

1. Calculate the mean, median, and mode of the LOS of patients seen by each physician (round to one decimal point).
2. Calculate the variance and standard deviation of LOS by each physician (round to two decimal points).