Obtain descriptive statistics using excel


Diagnosis related groups are employed in payment for health care of medicare funded patients. Int he creationof the DRGs, suppose that the lengths of stay for 50 patients in one of proposed groups were the following.

S. No

Group 1

Group 2

Group 3

Group 4

1

1

2

3

5

2

1

2

4

5

3

2

2

4

5

4

2

3

4

6

5

2

3

5

6

6

6

8

13

18

7

7

9

15

19

8

7

9

15

19

9

8

10

17

20

10

8

12

17

23

11

26

43

   

12

29

49

   

13

31

52

   

14

34

67

   

15

36

96

   

Compute the mean, standard deviation, coefficient of variation and five key percentiles for such data. Are these data skewed Do the patients in this DRG appear to have homogeneous lengths of stay? Which measures if any must be sued in description of these data? Describe your answer.

Request for Solution File

Ask an Expert for Answer!!
Basic Statistics: Obtain descriptive statistics using excel
Reference No:- TGS018005

Expected delivery within 24 Hours