Calculate the average charge for all patients

Reference no: EM133625638

Assignment: Applied Sciences Health Information Technology

Real-World Case 14.1-Chapter 14, page 469, textbook from HIT 121: HIM Technology, An Applied Approach, 6th Ed.

Review Chapter 14: Healthcare Statistics--what do you recall? This is a review

A summary of the patients discharged from MS-DRG 689 at Community Hospital is presented in the table below.

Data for Real-World Case 14.1
Case	Principal Diagnosis	Principal Procedure	Age	LOS	Discharge Destination	Charges	Payer
1	599.0	38.93	53.5	4	HOMEIV	$8,851	MEDICAID
2	599.0	45.13	28.2	7	HOMEHEALTH	$18,966	MEDICARE
3	590.8		45.5	3	HOME	$4,370	MANAGED CARE
4	590.8	86.27	27.9	3	HOMEHEALTH	$7,121	GOV MNGD CARE
5	590.8		38.8	3	HOME	$13,350	MEDICAID
6	590.8	45.23	67.1	4	HOME	$15,854	MANAGED CARE
7	599.0	39.95	88.5	6	SNF	$22,373	MEDICARE
8	599.0		27.8	6	HOMEHEALTH	$11,381	GOV MNGD CARE
9	590.1		52.6	2	HOME	$4,082	MEDICAID
10	599.0		81.9	6	HOMEHEALTH	$17,025	MEDICARE
11	590.8		23.3	3	HOME	$5,039	MEDICAID
12	599.0	43.11	90.1	5	HOMEHEALTH	$17,411	MEDICARE
13	599.0	99.6	91.3	1	UNKNOWN	$5,302	MEDICARE
14	599.0	88.72	73.1	4	HOME	$11,091	MEDICARE
15	599.0		81.3	12	SNF	$23,341	MEDICARE
16	590.8	45.16	74.7	4	HOMEHEALTH	$16,277	MEDICARE
17	599.0		71.2	5	HOMEHEALTH	$9,239	MEDICARE
18	599.0		79.3	7	SNF	$21,050	MEDICARE
19	590.1		31.3	4	HOME	$7,085	GOV MNGD CARE
20	590.8	38.93	74.1	13	ACUTECARE	$49,487	MEDICAID
21	599.0		65.7	2	HOMEHEALTH	$8,980	MEDICARE
22	599.0	86.27	83.1	5	SNF	$11,651	MEDICARE
23	599.0		77.0	5	SNF	$12,295	MEDICARE
24	599.0	99.04	81.2	7	HOMEHEALTH	$23,745	MEDICARE
25	599.0		43.3	10	HOMEHEALTH	$25,130	MEDICARE
26	599.0		81.5	3	SNF	$10,092	MEDICARE
27	599.0	38.93	25.6	3	HOMEIV	$8,722	MEDICAID
28	599.0		61.4	2	SNF	$6,670	MEDICAID
29	599.0	45.13	76.0	8	SNF	$17,741	GOV MNGD CARE
30	590.1		44.4	4	HOME	$10,800	MANAGED CARE
31	590.8		44.8	2	HOME	$10,916	MEDICAID
32	599.0	45.13	61.2	8	SNF	$32,796	MEDICARE

Task

Question A. Calculate the length of stay for all patients.

Question B. Calculate the average length of stay for Medicare patients.

Question C. Calculate the average charge for all patients.

Question D. Calculate the average charge for Medicaid patients.

Question E. Calculate the average age of all patients.

Question F. Calculate the average age of patients discharged to skilled nursing facilities.

Question G. Calculate the average age of patients discharged home.

Question H. Calculate the ratio of Medicare patients to Medicaid patients.

Reference no: EM133625638

Questions Cloud

Explain sources of leadership power and contribution : Global Leadership and Organisational Behaviour - Critically evaluate contemporary leadership theories (transformational, transactional, or charismatic)

Discuss what options the subcontractor can take to ensure : Under what circumstances are videos on the Internet subject. Discuss what options the subcontractor can take to ensure that no copyright violation occurs.

Summarize interaction between dopamine and psychiatric : Summarize the complex interaction between dopamine and psychiatric disorders encompasses both an excessive and a deficient amount of dopamine.

Discusses the impact of the ehr system on quality outcomes : Discusses the impact of the EHR system on quality outcomes. Discusses how the EHR system can be integrated into a health information system.

Calculate the average charge for all patients : Calculate average charge for all patients. Calculate the average age of all patient. Calculate average age of patients discharged to skilled nursing facilities.

What you hope to improve upon using action learning program : What would you hope to improve upon using an action learning program? Do you think action learning would help you improve in these areas?

Explain diagnosis and use one citation from required reading : LED 420- For each of the three scenarios, explain your diagnosis and use at least one citation from the required readings to support your diagnosis.

Analysis of current workplace practices and behaviour : Analysis of current workplace practices and behaviour and Provide a description of how the current organisational culture is perceived

How did community grow closer or more distant after event : What happened to the community during this time? How did the community grow closer or more distant after the event?

User Account

All Pages