PHD ONLY
ki1127
documents--excel_exercise_week_6_tda_1-1-2-1.xlsxInpatient service days by unit
| Inpatient service days by unit and by month, 2005. | ||
| Unit 1 | Unit 2 | |
| Month | Inpatient Service Days | Inpatient Service Days |
| January | 167 | 170 |
| February | 127 | 180 |
| March | 167 | 152 |
| April | 115 | 180 |
| May | 198 | 137 |
| June | 142 | 189 |
| July | 167 | 128 |
| August | 122 | 175 |
| September | 185 | 121 |
| October | 131 | 180 |
| November | 185 | 174 |
| December | 163 | 102 |
| Mean | 155.75 | 157.33 |
| Median | 165 | 170 |
| Mode | 167 | 180 |
| Variance | 759.66 | 816.24 |
| Exercise | ||
| 1. Calculate the mean (round to two decimal points), median, and mode of the inpatient service days for Unit 1, and for Unit 2. | ||
| 2. Select the most appropriate method to display the data and insert that graph ot table into this sheet. | ||
| 3. Calculate the variance between the 2 units. | ||
| Tip | ||
| To obtain Summary Statistics: | ||
| 1. On the Tools menu, select Data Analysis. | ||
| 2. Select "Descriptive Statistics". Click "OK". | ||
| 3. Highlight the range for Input data (Unit 1). | ||
| 4. Highlight the range of cells where you want output to be shown. | ||
| 5. Select "Summary Statistics". Click "OK". | ||
| 6. Repeat the steps 1 through 5 for Unit 2. | ||
| To run each individual mean, median, and mode: | ||
| 1. On the Insert menu, select Function. | ||
| 2. Under Select a function, select AVERAGE. Click "OK". | ||
| 3. Highlight data from Unit 1, Inpatient service days. Click "OK". | ||
| 4. Repeat steps 1-3 for MEDIAN and MODE. | ||
Inpatient Service Days By Unit and By Month, 2005
Inpatient Service Days
January February March April May June July August September October November December 167 127 167 115 198 142 167 122 185 131 185 163 Inpatient Service Days
January February March April May June July August September October November December 170 180 152 180 137 189 128 175 121 180 174 102
Complication and infection rate
| Complication and infection rates by month, Hospital A, 2005. | |||||
| Date | Total Discharges | Complications | Complication Rate | Infections | Infection Rate |
| January | 430 | 3 | 0.70% | 12 | 2.79% |
| February | 403 | 2 | 0.50% | 15 | 3.72% |
| March | 427 | 5 | 1.17% | 14 | 3.28% |
| April | 485 | 4 | 0.82% | 15 | 3.09% |
| May | 476 | 2 | 0.42% | 11 | 2.31% |
| June | 469 | 1 | 0.21% | 16 | 3.41% |
| July | 432 | 3 | 0.69% | 18 | 4.17% |
| August | 411 | 3 | 0.73% | 13 | 3.16% |
| September | 493 | 2 | 0.41% | 16 | 3.25% |
| October | 440 | 4 | 0.91% | 19 | 4.32% |
| November | 485 | 1 | 0.21% | 16 | 3.30% |
| December | 422 | 4 | 0.95% | 21 | 4.98% |
| Total | |||||
| Exercise | |||||
| 1. Calculate monthly and annual complication rates (round to two decimal points). | |||||
| 2. Calculate monthly and annually infection rates (round to two decimal points). | |||||
| 3. Select the most appropriate method to display the data and insert that graph or table into this sheet. |
