Use MS Excel or another spreadsheet program to address the following problem A pilot study was carried out in 1991 at Northwestern Memorial Hospital in Chicago to compare two different methods of care management for geriatric patients who were transferred from the emergency room to the geriatric ward. The two methods were "usual care" and "geriatric team care". The assignment of patients to the two groups was done at random: 58 patients were assigned to the "usual care" (control group) and 50 to the "geriatric team care" group (treatment group). The two groups were compared on various outcome measures. The table provides data on hospitalization costs for a subsample of 30 patients from each group. Hospitalization Costs (in dollars) for Geriatric Patients Control Group 2969 3151 3565 478 1203 3626 605 1204 4382 626 714 1323 2150 45767284 818 2700 9319 12664 6953 6963 7829 3739 175394148 8681 7062 23237 26677 32913 Treatment Group 5928 912 8635 1706 1882 528 2697 3186 3217 3590 2391 2829 1651 9615 15225 6502432 3039 6267 73651289 1708 3345 1998 4153 6018 6790 1130 13890 19083 Create a report using MS Word or some other word processing program that included the following sections Introduction Section Problem Statement Descriptive Statistics o Plot the Data - choose scatter, box-whisker or histogram o Describe the quality of the data - Observations o Calculate any of the Descriptive Statistics qualities, discussed in Chapter 3, that you think will be useful in understanding this problem (mean, mode, etc.) Conduct a Preliminary Analysis using Tools Covered in Class o Choose your methods O Do not just use the Data Analysis tool from Excel - you need to show your work . Conclusions - summarize and evaluate your results Use MS Excel or another spreadsheet program to address the following problem A pilot study was carried out in 1991 at Northwestern Memorial Hospital in Chicago to compare two different methods of care management for geriatric patients who were transferred from the emergency room to the geriatric ward. The two methods were "usual care" and "geriatric team care". The assignment of patients to the two groups was done at random: 58 patients were assigned to the "usual care" (control group) and 50 to the "geriatric team care" group (treatment group). The two groups were compared on various outcome measures. The table provides data on hospitalization costs for a subsample of 30 patients from each group. Hospitalization Costs (in dollars) for Geriatric Patients Control Group 2969 3151 3565 478 1203 3626 605 1204 4382 626 714 1323 2150 45767284 818 2700 9319 12664 6953 6963 7829 3739 175394148 8681 7062 23237 26677 32913 Treatment Group 5928 912 8635 1706 1882 528 2697 3186 3217 3590 2391 2829 1651 9615 15225 6502432 3039 6267 73651289 1708 3345 1998 4153 6018 6790 1130 13890 19083 Create a report using MS Word or some other word processing program that included the following sections Introduction Section Problem Statement Descriptive Statistics o Plot the Data - choose scatter, box-whisker or histogram o Describe the quality of the data - Observations o Calculate any of the Descriptive Statistics qualities, discussed in Chapter 3, that you think will be useful in understanding this problem (mean, mode, etc.) Conduct a Preliminary Analysis using Tools Covered in Class o Choose your methods O Do not just use the Data Analysis tool from Excel - you need to show your work . Conclusions - summarize and evaluate your results
