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