Statistics Question

profileIgotyou
week_4_team_project_data.xlsx

Profit

Month Actual Profit Target Profit
January $1,036,729 $1,100,000
February $1,147,892 $1,400,000
March $1,289,493 $1,400,000
April $1,074,336 $1,400,000
May $1,356,121 $1,600,000
June $1,401,798 $1,600,000
July $1,745,623 $1,200,000
August $1,936,485 $1,600,000
September $1,965,392 $1,500,000
October $2,708,349 $2,300,000
November $2,397,351 $2,300,000
December $2,203,472 $2,200,000

Inpatient Census

Month Percentage of Beds Filled
January 85%
February 83%
March 68%
April 71%
May 62%
June 66%
July 59%
August 83%
September 82%
October 93%
November 90%
December 86%

Inpatient Falls

Day Percentage of Inpatient Falls
1 0.9%
2 1.3%
3 1.8%
4 3.8%
5 4.2%
6 6.9%
7 1.8%
8 0.6%
9 1.3%
10 1.7%
11 7.1%
12 5.7%
13 1.1%
14 1.6%
15 4.2%
16 7.8%
17 6.7%
18 5.7%
19 7.1%
20 7.9%
21 1.1%
22 7.8%
23 2.2%
24 3.3%
25 7.5%
26 0.1%
27 6.7%
28 4.1%
29 5.3%
30 3.1%
31 0.6%
32 7.4%
33 5.0%
34 0.5%
35 5.3%
36 1.6%
37 7.4%
38 0.2%
39 3.8%
40 7.4%
41 6.3%
42 2.1%
43 0.2%
44 3.3%
45 7.3%
46 6.5%
47 1.4%
48 7.0%
49 7.9%
50 3.9%
51 2.6%
52 6.8%
53 5.4%
54 0.2%
55 7.2%
56 7.3%
57 1.7%
58 1.5%
59 3.2%
60 4.7%
61 2.3%
62 4.2%
63 6.8%
64 2.2%
65 7.9%
66 4.7%
67 6.3%
68 1.6%
69 3.7%
70 7.7%
71 6.4%
72 1.1%
73 3.0%
74 0.8%
75 5.1%
76 0.4%
77 5.1%
78 2.5%
79 6.9%
80 2.7%
81 3.1%
82 6.6%
83 2.1%
84 5.5%
85 7.1%
86 2.8%
87 6.1%
88 3.4%
89 1.5%
90 0.6%
91 2.0%
92 2.6%
93 2.5%
94 2.9%
95 7.0%
96 5.3%
97 6.2%
98 1.9%
99 2.7%
100 4.4%
101 1.0%
102 7.4%
103 6.3%
104 2.4%
105 3.5%
106 4.0%
107 5.7%
108 0.2%
109 2.8%
110 6.8%
111 4.1%
112 7.0%
113 5.5%
114 7.9%
115 1.0%
116 3.6%
117 0.9%
118 1.7%
119 3.2%
120 5.3%
121 7.5%
122 5.9%
123 4.4%
124 4.1%
125 4.7%
126 4.4%
127 4.3%
128 2.0%
129 5.8%
130 0.4%
131 3.4%
132 0.8%
133 4.8%
134 1.4%
135 6.9%
136 2.4%
137 4.9%
138 6.1%
139 4.6%
140 4.2%
141 6.1%
142 4.3%
143 7.4%
144 2.6%
145 5.6%
146 6.3%
147 6.1%
148 7.2%
149 2.7%
150 6.9%
151 1.7%
152 5.1%
153 5.5%
154 5.9%
155 6.9%
156 5.9%
157 5.2%
158 5.9%
159 0.6%
160 4.1%
161 5.8%
162 4.8%
163 4.8%
164 4.2%
165 1.4%
166 8.0%
167 3.3%
168 2.2%
169 5.8%
170 5.6%
171 8.0%
172 4.0%
173 1.7%
174 4.7%
175 6.6%
176 6.0%
177 3.1%
178 4.5%
179 3.2%
180 4.6%
181 1.7%
182 5.0%
183 4.1%
184 5.2%
185 6.6%
186 1.1%
187 1.1%
188 2.8%
189 5.5%
190 5.0%
191 5.4%
192 1.2%
193 6.6%
194 0.0%
195 6.4%
196 1.7%
197 6.9%
198 5.8%
199 5.7%
200 5.2%
201 5.8%
202 5.4%
203 1.2%
204 5.6%
205 5.9%
206 1.4%
207 6.7%
208 4.4%
209 7.1%
210 1.4%
211 5.5%
212 6.3%
213 0.3%
214 6.8%
215 4.2%
216 2.0%
217 7.2%
218 4.8%
219 6.0%
220 3.8%
221 4.4%
222 7.4%
223 3.3%
224 1.6%
225 1.9%
226 7.0%
227 2.9%
228 3.2%
229 2.1%
230 5.7%
231 7.4%
232 1.1%
233 5.8%
234 4.7%
235 4.9%
236 5.3%
237 7.9%
238 4.5%
239 3.9%
240 3.0%
241 3.9%
242 0.3%
243 5.3%
244 5.1%
245 6.2%
246 7.1%
247 3.2%
248 2.4%
249 4.8%
250 2.2%
251 3.9%
252 0.3%
253 5.8%
254 3.2%
255 2.2%
256 7.7%
257 2.6%
258 3.1%
259 0.5%
260 0.5%
261 5.4%
262 2.8%
263 1.2%
264 5.8%
265 0.2%
266 6.9%
267 2.8%
268 5.5%
269 2.5%
270 0.1%
271 1.8%
272 1.2%
273 5.0%
274 0.5%
275 6.4%
276 7.9%
277 0.3%
278 1.3%
279 1.4%
280 7.5%
281 6.2%
282 6.6%
283 4.1%
284 5.9%
285 2.9%
286 6.7%
287 1.2%
288 0.0%
289 4.8%
290 1.9%
291 0.3%
292 7.8%
293 0.3%
294 0.5%
295 3.1%
296 5.5%
297 0.2%
298 3.6%
299 6.1%
300 6.9%
301 5.4%
302 6.6%
303 3.0%
304 0.8%
305 7.1%
306 5.9%
307 7.6%
308 4.2%
309 0.7%
310 0.8%
311 6.2%
312 4.5%
313 3.6%
314 4.1%
315 3.5%
316 0.4%
317 2.3%
318 0.4%
319 6.7%
320 1.5%
321 5.8%
322 5.2%
323 7.0%
324 5.4%
325 7.7%
326 2.3%
327 4.2%
328 4.7%
329 2.7%
330 6.8%
331 5.1%
332 0.6%
333 5.7%
334 2.7%
335 1.7%
336 5.9%
337 0.3%
338 0.2%
339 3.2%
340 5.3%
341 7.0%
342 1.3%
343 0.6%
344 7.0%
345 6.2%
346 0.4%
347 2.0%
348 1.9%
349 7.7%
350 7.1%
351 0.3%
352 5.2%
353 4.4%
354 3.2%
355 4.3%
356 4.1%
357 5.5%
358 4.0%
359 2.9%
360 2.0%
361 5.6%
362 0.4%
363 1.4%
364 7.6%
365 5.8%

Patient Satisfaction

Department Satisfaction
Cardiac Intensive Care Unit 87%
Intensive Care Unit 85%
Cardiac Step-Down Unit 92%
Orthopedic 88%
Oncology 80%
Nephrology & Renal 83%
Emergency Department 52%
Psych 77%
Materinity 95%
Neurology 87%

ED Wait Times

Person Wait Time (in minutes)
1 57
2 81
3 83
4 107
5 144
6 94
7 190
8 51
9 30
10 93
11 145
12 68
13 114
14 18
15 88
16 79
17 123
18 130
19 153
20 15
21 172
22 27
23 117
24 173
25 18
26 26
27 193
28 59
29 171
30 95
31 76
32 24
33 171
34 42
35 139
36 134
37 94
38 56
39 66
40 40
41 168
42 102
43 186
44 104
45 23
46 95
47 78
48 56
49 60
50 195
51 21
52 33
53 129
54 113
55 145
56 50
57 74
58 99
59 129
60 183
61 90
62 17
63 188
64 41
65 122
66 120
67 55
68 80
69 101
70 108
71 190
72 166
73 145
74 49
75 156
76 48
77 95
78 82
79 119
80 96
81 145
82 150
83 79
84 63
85 166
86 112
87 136
88 88
89 69
90 114
91 163
92 61
93 138
94 85
95 94
96 146
97 97
98 62
99 88
100 37
101 152
102 125
103 136
104 87
105 89
106 88
107 129
108 141
109 26
110 30
111 56
112 195
113 122
114 194
115 163
116 66
117 115
118 55
119 148
120 59
121 113
122 125
123 95
124 94
125 93
126 62
127 126
128 142
129 161
130 95
131 71
132 167
133 29
134 72
135 45
136 52
137 178
138 75
139 29
140 138
141 122
142 170
143 77
144 73
145 83
146 190
147 133
148 64
149 145
150 62
151 187
152 54
153 65
154 172
155 78
156 21
157 93
158 179
159 146
160 111
161 164
162 96
163 42
164 120
165 96
166 119
167 59
168 100
169 40
170 104
171 27
172 182
173 194
174 100
175 104
176 85
177 73
178 24
179 50
180 47
181 87
182 35
183 50
184 60
185 27
186 78
187 74
188 132
189 119
190 152
191 129
192 108
193 180
194 191
195 152
196 140
197 46
198 50
199 34
200 21
201 121
202 163
203 176
204 56
205 194
206 145
207 150
208 37
209 68
210 30
211 54
212 187
213 31
214 112
215 87
216 110
217 29
218 192
219 81
220 186
221 136
222 58
223 96
224 182
225 95
226 77
227 19
228 21
229 74
230 45
231 65
232 103
233 116
234 181
235 181
236 44
237 173
238 47
239 75
240 104
241 91
242 50
243 69
244 38
245 110
246 83
247 114
248 56
249 39
250 183
251 127
252 88
253 154
254 74
255 121
256 87
257 159
258 113
259 88
260 87
261 169
262 182
263 109
264 24
265 148
266 99
267 119
268 182
269 47
270 50
271 107
272 175
273 114
274 50
275 180
276 116
277 37
278 178
279 188
280 44
281 184
282 149
283 174
284 127
285 62
286 68
287 122
288 44
289 67
290 23
291 63
292 191
293 94
294 55
295 121
296 36
297 144
298 62
299 151
300 138
301 165
302 157
303 118
304 169
305 99
306 46
307 163
308 50
309 155
310 64
311 81
312 120
313 191
314 52
315 165
316 163
317 191
318 96
319 85
320 138
321 85
322 190
323 60
324 135
325 114
326 74
327 33
328 35
329 40
330 185
331 39
332 92
333 76
334 36
335 129
336 143
337 141
338 26
339 32
340 123
341 34
342 188
343 31
344 175
345 147
346 20
347 137
348 99
349 168
350 66
351 161
352 164
353 170
354 90
355 109
356 35
357 25
358 158
359 122
360 186
361 67
362 16
363 88
364 121
365 164
366 151
367 193
368 106
369 162
370 88
371 42
372 59
373 146
374 193
375 73
376 17
377 174
378 118
379 128
380 63
381 116
382 155
383 160
384 104
385 178
386 146
387 76
388 140
389 81
390 15
391 60
392 165
393 120
394 93
395 152
396 101
397 112
398 166
399 73
400 148
401 165
402 168
403 32
404 123
405 130
406 94
407 98
408 167
409 178
410 194
411 57
412 173
413 78
414 184
415 148
416 163
417 160
418 38
419 75
420 148
421 171
422 91
423 149
424 17
425 186
426 69
427 169
428 61
429 166
430 186
431 80
432 133
433 78
434 80
435 133
436 69
437 139
438 110
439 19
440 37
441 145
442 192
443 89
444 65
445 177
446 154
447 142
448 164
449 98
450 152
451 106
452 72
453 150
454 45
455 179
456 102
457 190
458 194
459 24
460 172
461 27
462 92
463 23
464 101
465 173
466 183
467 145
468 159
469 22
470 100
471 182
472 112
473 98
474 113
475 47
476 115
477 55
478 138
479 167
480 140
481 187
482 190
483 111
484 76
485 154
486 113
487 51
488 78
489 153
490 80
491 80
492 162
493 98
494 78
495 89
496 170
497 142
498 151
499 30
500 116
501 86
502 178
503 141
504 73
505 107
506 113
507 83
508 65
509 158
510 21
511 94
512 54
513 83
514 126
515 105
516 150
517 156
518 97
519 47
520 181
521 95
522 133
523 28
524 172
525 15
526 156
527 55
528 181
529 121
530 87
531 26
532 20
533 26
534 63
535 153
536 161
537 60
538 35
539 141
540 66
541 103
542 56
543 53
544 58
545 77
546 80
547 41
548 191
549 93
550 17
551 122
552 104
553 149
554 55
555 195
556 114
557 37
558 169
559 74
560 109
561 36
562 41
563 130
564 142
565 83
566 30
567 128
568 67
569 164
570 53
571 178
572 16
573 76
574 128
575 114
576 61
577 113
578 133
579 149
580 191
581 181
582 85
583 81
584 180
585 51
586 159
587 106
588 66
589 137
590 180
591 109
592 122
593 121
594 126
595 45
596 62
597 33
598 165
599 193
600 80
601 87
602 183
603 42
604 116
605 24
606 45
607 85
608 57
609 97
610 146
611 57
612 170
613 140
614 94
615 34
616 129
617 105
618 35
619 175
620 28
621 183
622 88
623 176
624 161
625 99
626 100
627 64
628 37
629 81
630 39
631 63
632 193
633 84
634 84
635 189
636 51
637 78
638 78
639 84
640 136
641 192
642 54
643 58
644 108
645 170
646 186
647 34
648 108
649 142
650 51
651 118
652 88
653 91
654 194
655 41
656 164
657 71
658 155
659 111
660 21
661 168
662 65
663 109
664 76
665 91
666 137
667 60
668 115
669 95
670 15
671 183
672 72
673 126
674 116
675 110
676 186
677 51
678 114
679 123
680 32
681 84
682 38
683 85
684 104
685 94
686 167
687 139
688 112
689 100
690 18
691 52
692 41
693 122
694 122
695 21
696 168
697 46
698 111
699 115
700 150
701 123
702 66
703 182
704 186
705 193
706 128
707 18
708 170
709 149
710 149
711 87
712 173
713 134
714 26
715 104
716 127
717 52
718 195
719 72
720 132
721 102
722 22
723 195
724 148
725 62
726 50
727 107
728 103
729 94
730 177
731 46
732 195
733 15
734 179
735 178
736 42
737 109
738 100
739 97
740 158
741 137
742 182
743 192
744 184
745 177
746 186
747 103
748 188
749 113
750 156
751 74
752 147
753 125
754 158
755 98
756 169
757 93
758 23
759 17
760 110
761 121
762 119
763 129
764 17
765 136
766 109
767 87
768 34
769 182
770 69
771 21
772 44
773 170
774 20
775 160
776 177
777 109
778 108
779 88
780 41
781 136
782 58
783 179
784 19
785 179
786 127
787 86
788 17
789 46
790 26
791 181
792 30
793 193
794 93
795 195
796 176
797 139
798 34
799 50
800 177
801 62
802 144
803 154
804 62
805 137
806 125
807 193
808 133
809 60
810 50
811 114
812 111
813 48
814 81
815 135
816 40
817 72
818 111
819 150
820 21
821 194
822 82
823 164
824 141
825 65
826 158
827 69
828 161
829 97
830 77
831 161
832 158
833 166
834 136
835 59
836 38
837 102
838 135
839 17
840 92
841 128
842 88
843 83
844 128
845 45
846 39
847 138
848 39
849 47
850 76
851 105
852 93
853 161
854 193
855 192
856 160
857 38
858 190
859 26
860 53
861 40
862 186
863 155
864 17
865 140
866 22
867 141
868 48
869 21
870 180
871 88
872 174
873 105
874 16
875 110
876 178
877 189
878 98
879 134
880 72
881 93
882 106
883 83
884 28
885 45
886 186
887 137
888 98
889 194
890 97
891 99
892 59
893 190
894 159
895 85
896 187
897 25
898 188
899 187
900 134
901 70
902 90
903 144
904 44
905 130
906 134
907 125
908 58
909 21
910 193
911 93
912 108
913 112
914 176
915 152
916 185
917 92
918 191
919 113
920 42
921 194
922 103
923 146
924 82
925 183
926 180
927 131
928 19
929 39
930 36
931 132
932 131
933 34
934 17
935 139
936 39
937 32
938 64
939 190
940 34
941 179
942 168
943 194
944 150
945 76
946 175
947 148
948 153
949 34
950 149
951 135
952 153
953 119
954 116
955 123
956 47
957 69
958 126
959 164
960 28
961 128
962 142
963 173
964 85
965 33
966 108
967 181
968 104
969 158
970 72
971 128
972 48
973 27
974 160
975 143
976 169
977 32
978 48
979 163
980 90
981 40
982 116
983 67
984 25
985 53
986 183
987 129
988 51
989 92
990 163
991 138
992 26
993 122
994 86
995 88
996 178
997 152
998 89
999 154
1000 162