2: Prepare a table displaying the data shown below. The hospital administration would like a breakdown of the discharges shown above by payer classification. For example, Medicare, Medicaid, Blue Cross/Blue Shield, Other 3rd Party and Self-pay (Include totals by columns and rows) (6 points)

Medicine: 2,224 Discharges

Medicare = 1,503

Medicaid = 244

Blue Cross/Blue Shield = 142 Other 3rd Party = 250

Self Pay = 85

Surgery: 1,555 Discharges

Medicare = 755

Medicaid = 345

Blue Cross/Blue Shield = 230 Other 3rd Party = 200

Self Pay = 25

Obstetrics: 946 Discharges

Medicare = 0

Medicaid = 205

Blue Cross/Blue Shield = 165 Other 3rd Party = 505

Self Pay = 71

Newborn: 938 Discharges

Medicare = 0

Medicaid = 205

Blue Cross/Blue Shield = 165 Other 3rd Party = 505

Self Pay = 63

3: Your local county public health department shows the following number of patients who had an abortion during the past ten years who were under the age of 21. Construct a table of the data with two columns. (10 points)

Year	Number	Year	Number
2002	775	2007	1,156
2003	872	2008	1,306
2004	849	2009	1,458
2005	1,095	2010	1,546
2006	1,150	2011	1,945

4: Your hospitals Utilization Review Coordinator performed a review of ancillary services used for patients in MS-DRG 552 (Medical Back Problems without MCC). Construct a consolidated table for the following data test by location. Data is for January 1, 20XX to December 31, 20XX. (10 pts)

Treatment/Test Service/Number of tests/treatments

Spine x-ray	Family Practice =	278	Orthopedics = 278	Neurology =	276
CXR	Family Practice =	240	Orthopedics = 207	Neurology =	130
EMG	Family Practice =	102	Orthopedics = 200	Neurology =	257
ECG	Family Practice =	241	Orthopedics = 180	Neurology =	43
Valium	Family Practice =	257	Orthopedics = 187	Neurology =	198

Analgesics	Family Practice =	137	Orthopedics = 236	Neurology = 221
Codeine	Family Practice =	141	Orthopedics = 41	Neurology = 57

5: Review the following table "Population by Sex in Five-Year Age Groups" and answer the questions below. (6 points)

POPULATION BY SEX IN TEN-YEAR AGE GROUPS

Age	1996			2006
Group	Total	Male	Female	Total	Male	Female
0-9	280,875	143,194	137,681	306,123	156,679	149,444
10-19	349,552	178,712	170,850	321,995	165,160	156,835
20-29	296,500	148,936	147,564	400,542	206,258	194,284
30-39	193,731	97,536	95,195	354,645	178,753	175,892
40-49	193,141	95,466	97,675	213,832	108,450	105,382
50-59	189,085	94,102	94,983	198,548	97,453	101,095
60-69	138,250	67,484	70,766	179,037	86,540	92,497
70-79	84,464	35,577	47,887	112,023	49,475	62,458
80-89+	40,412	16,123	24,289	49,330	17,106	32,224

What is the youngest age group where there are more females than males in the population for

1996

2006

Which age group has the most people for

1996

2006

What percent of the population in the 80-89+ age group were females for

1996

2006

6: The following were the ages at diagnosis of patients entered into the Elliot Bay Memorial Hospital's Cancer Registry during 20xx. Construct a frequency distribution including Age, Frequency, and Cumulative Frequency, using 10 as a class size. Be sure to include the title (also include year and N) and source of the data. Use classes 90-99, 80-89, etc. Start with the oldest age group at the top of the table and then go down in descending order. If other combinations are used, the entire question will be marked as incorrect (23 points)

78, 44, 89, 3, 16, 88, 80, 75, 66, 62, 78, 22, 77, 78, 44, 34, 36, 21, 2, 89, 90, 99, 66, 87,

90, 72, 77, 34, 9, 33, 78, 79, 72, 45, 22, 23, 99, 65, 62, 98, 23, 74, 76, 65, 62, 54, 43, 50,

12, 92, 72, 64, 76, 11, 75, 90, 73.

Age	Frequency	Cum. Freq.
90-99