The quality improvement committee of Macomb Community Hospital wanted to study MS-DRG 689, Kidney and Urinary Tract Infections with MCC, because of the wide variations of LOS and total charges. The committee asked you to prepare a profile of patients discharged from MS-DRG 689 for the month of June 2020. A summary of the patients discharged from MS-DRG was prepared using the facility's HDM database.

Case	Principal Diagnosis	Age	LOS	Discharge Destination	Charges	Payer
1	N39.0	54.5	4	HOMEIV	$8,851	MEDICAID
2	N39.0	28.2	7	HOMEHEALTH	$18,966	MEDICARE
3	N10	45.5	4	HOME	$4,372	MANAGED CARE
4	N10	27.9	3	HOMEHEALTH	$7,121	GOV MNGD CARE
5	N10	38.8	3	HOME	$13,355	MEDICAID
6	N10	68.1	4	HOME	$15,854	MANAGED CARE
7	N39.0	88.5	6	SNF	$22,373	MEDICARE
8	N39.0	27.8	7	HOMEHEALTH	$11,381	GOV MNGD CARE
9	N30.00	52.6	2	HOME	$4,084	MEDICAID
10	N39.0	81.9	6	HOMEHEALTH	$17,025	MEDICARE
11	N10	23.3	3	HOME	$5,039	MEDICAID
12	N39.0	90.1	5	HOMEHEALTH	$17,411	MEDICARE
13	N39.0	91.3	1	DIED	$5,302	MEDICARE
14	N39.0	74.1	4	DIED	$11,092	MEDICARE
15	N39.0	82.3	12	SNF	$23,341	MEDICARE
16	N10	74.7	4	HOMEHEALTH	$16,277	MEDICARE
17	N39.0	71.2	5	HOMEHEALTH	$9,240	MEDICARE
18	N39.0	79.3	7	SNF	$21,050	MEDICARE
19	N30.00	33.3	5	HOME	$7,085	GOV MNGD CARE
20	N10	74.1	13	ACUTECARE	$49,487	MEDICAID
21	N39.0	65.7	2	HOMEHEALTH	$8,980	MEDICARE
22	N39.0	83.1	5	SNF	$11,650	MEDICARE
23	N39.0	77.0	5	SNF	$12,295	MEDICARE
24	N39.0	81.2	7	HOMEHEALTH	$23,745	MEDICARE
25	N39.0	43.3	10	HOMEHEALTH	$25,138	MEDICARE
26	N39.0	80.5	3	SNF	$10,092	MEDICARE
27	N39.0	25.6	3	HOMEIV	$8,722	MEDICAID
28	N39.0	61.4	2	SNF	$6,670	MEDICAID
29	N39.0	76.0	8	SNF	$17,741	GOV MNGD CARE
30	N30.00	44.4	4	HOME	$10,800	MANAGED CARE
31	N10	44.8	2	HOME	$10,916	MEDICAID
32	N39.0	61.2	8	SNF	$32,796	MEDICARE

The committee had the following questions regarding the data. You must show your work in preparing the answers. Remember your rules for creating charts and graphs. Round to two decimal places when appropriate.

1. What was the average length of stay?
2. What was the average gross charge?
3. What was the average patient age?
4. What was the average age of patients discharged to a skilled nursing facility?
5. What was the average age of patients discharged home?
6. What was the gross death rate?
7. Prepare a pie chart showing patient discharges by discharge destination. The pie chart should reflect the percentages of patients.
8. Prepare a bar graph of the principal diagnosis volumes and codes.