MATH 810 APPLIED STATISTICS. ANALYSIS OF PATIENT OUTCOMES – 75 points

profileBarras
MATH810-ProjectIIData.xlsx

Data

PatientID Gender Age_Range Procedure Outcome Satisfaction WouldRec LTV
689696 F 55 to 74 Bariatric Short Somewhat Satisfied Y 154
711225 M 75 to 90 Oncology Short Somewhat Satisfied N 117
517064 F 90+ Bariatric Long Very Satisfied Y 128
627571 F 18 to 34 Cardiovascular Short Very Satisfied Y 87
130260 F 55 to 74 Bariatric Short Very Satisfied Y 85
336668 F 55 to 74 Oncology Short Very Satisfied Y 107
23610 M 75 to 90 Bariatric Short Somewhat Dissatisfied N 83
529336 F 35 to 54 Orthopedic Short Very Satisfied Y 138
147827 M 35 to 54 Oncology Short Somewhat Dissatisfied Y 98
890289 M 55 to 74 Cardiovascular LongInf Somewhat Dissatisfied N 127
588764 F 35 to 54 Orthopedic Short Somewhat Dissatisfied Y 89
470999 F 75 to 90 Oncology Short Very Satisfied N 81
981341 F 75 to 90 Orthopedic Short Very Satisfied N 100
611485 M 55 to 74 Cardiovascular Short Somewhat Satisfied Y 83
776374 F 35 to 54 Orthopedic Short Very Dissatisfied Y 102
744565 F 18 to 34 Cardiovascular Short Somewhat Satisfied N 77
960549 F 55 to 74 Orthopedic LongInf Very Dissatisfied N 96
666347 M 55 to 74 Cardiovascular Short Somewhat Satisfied N 119
629285 F 55 to 74 Cardiovascular Long Somewhat Satisfied N 101
225024 F 35 to 54 Oncology Short Somewhat Satisfied N 126
222153 M 18 to 34 Cardiovascular Short Very Satisfied N 116
474705 F 18 to 34 Cardiovascular Short Somewhat Dissatisfied N 112
302299 M 35 to 54 Oncology Short Very Dissatisfied N 101
15950 F 35 to 54 Oncology Short Very Satisfied Y 84
802479 M 75 to 90 Orthopedic Short Somewhat Satisfied N 143
269326 F 55 to 74 Cardiovascular Short Somewhat Dissatisfied N 124
95764 M 35 to 54 Orthopedic Short Very Dissatisfied N 85
279307 F 55 to 74 Orthopedic Short Somewhat Satisfied Y 88
224908 F 75 to 90 Oncology Short Somewhat Satisfied Y 124
423095 F 18 to 34 Bariatric Short Very Dissatisfied N 110
183088 F 55 to 74 Cardiovascular Long Somewhat Satisfied N 83
183352 F 35 to 54 Orthopedic Short Very Satisfied Y 133
445170 F 55 to 74 Orthopedic Short Somewhat Satisfied Y 111
153632 M 55 to 74 Oncology Short Very Satisfied N 105
380218 M 75 to 90 Oncology Short Somewhat Satisfied Y 67
866880 F 55 to 74 Cardiovascular Short Somewhat Dissatisfied N 128
994209 M 75 to 90 Cardiovascular Long Somewhat Satisfied N 62
644627 F 55 to 74 Orthopedic Long Very Dissatisfied N 74
92148 M 55 to 74 Bariatric Short Somewhat Dissatisfied Y 170
346405 F 35 to 54 Cardiovascular Short Somewhat Satisfied Y 134
534630 M 35 to 54 Oncology Short Somewhat Satisfied N 171
365219 M 75 to 90 Orthopedic Short Somewhat Satisfied N 98
311943 F 55 to 74 Orthopedic Short Very Satisfied N 105
419161 F 55 to 74 Oncology Short Very Satisfied Y 85
247874 F 55 to 74 Orthopedic Short Somewhat Satisfied Y 143
668685 M 55 to 74 Cardiovascular Short Very Satisfied N 72
751647 F 55 to 74 Oncology Short Somewhat Dissatisfied N 55
403987 F 75 to 90 Orthopedic Short Somewhat Satisfied Y 51
378115 F 35 to 54 Cardiovascular Short Very Satisfied Y 119
51707 M 90+ Orthopedic Short Very Satisfied N 108
591781 M 75 to 90 Oncology Long Very Satisfied N 126
864459 F 55 to 74 Oncology Short Very Dissatisfied N 137
940880 M 75 to 90 Orthopedic Short Somewhat Satisfied N 100
253188 F 75 to 90 Cardiovascular Short Somewhat Satisfied N 115
233984 F 18 to 34 Orthopedic Short Somewhat Dissatisfied N 146
274747 F 90+ Cardiovascular Short Very Satisfied N 99
422416 M 55 to 74 Oncology Short Somewhat Satisfied Y 105
118410 F 75 to 90 Oncology Short Somewhat Dissatisfied Y 123
36513 F 55 to 74 Oncology Short Very Satisfied N 124
908688 M 75 to 90 Oncology Short Somewhat Satisfied N 83
518919 F 35 to 54 Oncology Short Somewhat Dissatisfied N 112
134496 F 55 to 74 Cardiovascular Short Somewhat Satisfied N 134
56222 M 55 to 74 Bariatric Short Very Satisfied N 123
306947 F 55 to 74 Oncology Long Somewhat Dissatisfied N 133
420775 F 55 to 74 Oncology Short Somewhat Satisfied N 109
670981 M 55 to 74 Oncology Short Very Satisfied Y 110
236692 F 18 to 34 Bariatric Short Very Satisfied Y 120
642524 M 75 to 90 Cardiovascular Short Somewhat Dissatisfied Y 64
920532 F 75 to 90 Bariatric Short Somewhat Satisfied N 165
397133 M 35 to 54 Bariatric Short Somewhat Dissatisfied N 112
488955 F 55 to 74 Cardiovascular Short Somewhat Satisfied Y 82
957414 M 18 to 34 Orthopedic LongInf Somewhat Satisfied Y 59
555617 F 55 to 74 Bariatric Short Somewhat Satisfied N 85
763284 F 75 to 90 Cardiovascular Short Somewhat Satisfied N 103
501683 F 18 to 34 Orthopedic Short Very Dissatisfied Y 66
774829 F 18 to 34 Cardiovascular LongInf Very Satisfied N 100
380159 F 55 to 74 Oncology Short Somewhat Satisfied N 98
766653 F 35 to 54 Orthopedic Short Somewhat Satisfied N 113
486833 M 75 to 90 Cardiovascular Short Somewhat Satisfied Y 69
454919 F 75 to 90 Oncology Short Somewhat Satisfied Y 119
182036 F 75 to 90 Orthopedic Short Somewhat Dissatisfied N 118
483734 F 75 to 90 Orthopedic Short Somewhat Dissatisfied Y 67
81729 M 55 to 74 Cardiovascular Short Very Satisfied Y 102
31962 M 75 to 90 Cardiovascular Short Very Satisfied Y 67
22424 M 35 to 54 Orthopedic Long Somewhat Dissatisfied Y 89
340724 M 18 to 34 Cardiovascular Long Somewhat Dissatisfied N 84
633049 F 55 to 74 Oncology Short Very Satisfied Y 78
301498 F 18 to 34 Cardiovascular Short Somewhat Satisfied Y 115
423545 F 18 to 34 Bariatric Long Somewhat Dissatisfied N 94
980886 F 35 to 54 Orthopedic Short Somewhat Satisfied N 81
198906 F 35 to 54 Orthopedic Long Somewhat Satisfied Y 104
470373 F 35 to 54 Oncology LongInf Very Dissatisfied N 116
836673 M 75 to 90 Cardiovascular Short Somewhat Dissatisfied Y 105
686871 F 75 to 90 Bariatric Short Very Satisfied Y 82
587067 F 90+ Cardiovascular Long Somewhat Satisfied N 116
46186 M 35 to 54 Cardiovascular Short Somewhat Satisfied Y 118
513196 F 18 to 34 Orthopedic Short Somewhat Dissatisfied N 131
102500 F 55 to 74 Oncology Short Somewhat Satisfied N 126
358552 F 75 to 90 Orthopedic Short Somewhat Satisfied N 87
594078 F 55 to 74 Orthopedic Short Somewhat Satisfied N 126
936071 F 55 to 74 Bariatric Short Very Satisfied N 124
412467 F 55 to 74 Oncology Short Somewhat Satisfied N 98
548795 F 18 to 34 Orthopedic Short Somewhat Satisfied N 84
849024 M 35 to 54 Cardiovascular Short Very Satisfied N 90
332919 F 75 to 90 Cardiovascular Short Very Satisfied Y 98
657229 M 90+ Orthopedic Short Somewhat Satisfied N 75
998114 F 35 to 54 Orthopedic Short Somewhat Satisfied Y 95
239108 F 75 to 90 Cardiovascular LongInf Somewhat Satisfied Y 96
489501 M 55 to 74 Cardiovascular Short Somewhat Satisfied Y 92
419115 M 35 to 54 Oncology Short Somewhat Satisfied Y 122
298934 F 35 to 54 Bariatric Short Very Dissatisfied Y 110
600568 F 55 to 74 Oncology Short Very Dissatisfied N 116
711406 F 35 to 54 Cardiovascular Short Somewhat Dissatisfied N 131
113700 F 75 to 90 Cardiovascular Short Somewhat Satisfied N 82
160464 M 55 to 74 Bariatric Short Very Satisfied Y 88
366228 M 90+ Bariatric Long Somewhat Satisfied N 127
115680 M 75 to 90 Oncology Short Somewhat Satisfied N 141
545959 M 55 to 74 Cardiovascular Short Very Satisfied N 91
64809 F 35 to 54 Oncology Short Very Satisfied N 96
550086 M 75 to 90 Orthopedic Long Somewhat Dissatisfied N 50
979567 M 35 to 54 Bariatric Short Very Dissatisfied Y 120
34649 F 55 to 74 Oncology Short Somewhat Satisfied Y 140
921037 F 18 to 34 Oncology Short Somewhat Dissatisfied N 74
828646 F 55 to 74 Orthopedic Short Very Dissatisfied N 79
281393 M 55 to 74 Cardiovascular Short Somewhat Satisfied Y 95
226937 F 55 to 74 Bariatric LongInf Somewhat Satisfied Y 94
953413 F 55 to 74 Oncology Long Somewhat Satisfied Y 81
525480 F 35 to 54 Oncology Short Somewhat Dissatisfied N 73
634145 F 90+ Orthopedic Short Somewhat Satisfied N 102
16719 F 55 to 74 Cardiovascular Short Very Satisfied Y 35
611529 F 55 to 74 Oncology Short Somewhat Dissatisfied Y 143
167029 F 55 to 74 Cardiovascular Short Somewhat Satisfied N 152
781507 M 35 to 54 Bariatric Long Very Dissatisfied N 105
718850 F 18 to 34 Bariatric Short Very Satisfied Y 148
102950 M 90+ Oncology Short Very Satisfied N 125
776041 M 75 to 90 Oncology Short Somewhat Satisfied N 137
831298 M 75 to 90 Cardiovascular Short Somewhat Satisfied N 77
991447 M 18 to 34 Orthopedic LongInf Very Satisfied Y 103
379628 F 55 to 74 Bariatric Short Somewhat Dissatisfied Y 120
734265 M 35 to 54 Oncology Short Somewhat Satisfied N 97
950263 F 18 to 34 Cardiovascular Short Somewhat Satisfied Y 48
789697 F 75 to 90 Orthopedic LongInf Very Satisfied N 67
520894 F 75 to 90 Orthopedic Short Somewhat Satisfied N 71
661891 F 55 to 74 Bariatric Short Very Satisfied N 116
918379 M 18 to 34 Cardiovascular Short Somewhat Satisfied Y 93
310947 M 55 to 74 Oncology Short Somewhat Satisfied Y 114
637807 F 55 to 74 Orthopedic Short Very Satisfied N 78
912961 F 18 to 34 Cardiovascular Long Very Satisfied N 160
590059 F 75 to 90 Orthopedic Short Somewhat Satisfied Y 75
278245 M 75 to 90 Orthopedic LongInf Somewhat Dissatisfied N 119
86328 M 75 to 90 Bariatric Long Somewhat Satisfied N 58
832527 M 55 to 74 Orthopedic Short Somewhat Satisfied Y 92
917142 F 55 to 74 Cardiovascular Long Very Satisfied Y 96
725221 F 18 to 34 Cardiovascular Short Very Satisfied N 117
499339 F 55 to 74 Oncology Short Very Satisfied Y 101
254543 F 55 to 74 Oncology Short Very Dissatisfied N 94
752219 M 55 to 74 Cardiovascular Short Very Satisfied N 71
629855 F 35 to 54 Oncology Short Somewhat Satisfied Y 78
894756 M 75 to 90 Oncology Short Very Satisfied N 114
787681 F 55 to 74 Cardiovascular Short Very Dissatisfied N 71
483611 F 90+ Oncology Short Somewhat Satisfied Y 33
159601 F 75 to 90 Bariatric Short Very Satisfied N 105
748792 M 18 to 34 Oncology Short Somewhat Dissatisfied N 76
840067 M 55 to 74 Cardiovascular Short Somewhat Dissatisfied N 137
506682 F 18 to 34 Orthopedic Short Very Satisfied Y 105
492369 F 75 to 90 Orthopedic Short Somewhat Satisfied N 54
720691 F 55 to 74 Oncology Long Very Satisfied N 117
893143 M 35 to 54 Cardiovascular Long Somewhat Satisfied N 118
662013 M 55 to 74 Cardiovascular Short Very Satisfied N 91
140065 M 18 to 34 Cardiovascular Short Somewhat Satisfied N 134
389411 M 18 to 34 Orthopedic LongInf Very Satisfied N 106
851612 M 35 to 54 Bariatric Short Very Satisfied N 86
23653 F 35 to 54 Bariatric Long Very Satisfied Y 86
22856 F 55 to 74 Cardiovascular Short Somewhat Dissatisfied N 100
230909 M 18 to 34 Oncology Short Somewhat Dissatisfied N 139
842463 M 75 to 90 Bariatric Long Somewhat Satisfied N 95
115948 F 75 to 90 Cardiovascular Short Somewhat Satisfied Y 86
175166 M 55 to 74 Oncology Short Somewhat Satisfied N 111
469145 F 55 to 74 Cardiovascular Long Somewhat Satisfied Y 57
422519 F 75 to 90 Bariatric Short Very Satisfied N 134
584351 M 55 to 74 Cardiovascular Short Somewhat Satisfied N 53
499857 M 35 to 54 Orthopedic Long Somewhat Satisfied N 99
4115 F 55 to 74 Bariatric Long Very Satisfied Y 104
308286 F 55 to 74 Bariatric Short Somewhat Satisfied N 113
330265 F 55 to 74 Orthopedic Short Somewhat Satisfied N 65
540448 M 55 to 74 Oncology Short Somewhat Dissatisfied N 131
741722 M 55 to 74 Bariatric Short Somewhat Satisfied N 81
745909 M 55 to 74 Cardiovascular Short Somewhat Satisfied Y 126
455659 F 35 to 54 Oncology Long Somewhat Satisfied Y 128
537313 M 75 to 90 Orthopedic Long Somewhat Satisfied N 116
884799 M 55 to 74 Orthopedic Short Very Satisfied Y 89
495059 F 35 to 54 Cardiovascular Short Somewhat Satisfied N 117
577754 F 75 to 90 Cardiovascular Short Somewhat Satisfied Y 71
467199 F 55 to 74 Cardiovascular Short Somewhat Satisfied Y 114
739215 F 90+ Bariatric Long Somewhat Satisfied N 144
40237 F 75 to 90 Oncology Short Very Satisfied Y 132
452631 F 90+ Cardiovascular Short Very Satisfied N 101
822856 F 90+ Oncology Long Very Dissatisfied N 93
623282 F 75 to 90 Cardiovascular Short Somewhat Satisfied Y 129
240799 M 55 to 74 Oncology Short Somewhat Dissatisfied Y 90
272884 M 55 to 74 Orthopedic Short Somewhat Satisfied Y 95
540976 F 55 to 74 Cardiovascular Short Very Satisfied Y 84
166253 F 35 to 54 Orthopedic Short Very Satisfied N 95
800325 F 75 to 90 Orthopedic Long Very Satisfied N 79
283858 M 55 to 74 Oncology Short Somewhat Satisfied Y 75
747641 M 18 to 34 Oncology LongInf Very Satisfied N 93
223389 M 55 to 74 Oncology Long Somewhat Satisfied N 125
532529 M 75 to 90 Oncology Short Very Dissatisfied Y 141
166211 F 75 to 90 Cardiovascular Short Somewhat Satisfied N 88
870696 F 75 to 90 Cardiovascular Short Somewhat Dissatisfied N 135
867710 F 55 to 74 Orthopedic LongInf Somewhat Satisfied N 62
157075 F 55 to 74 Oncology Short Very Dissatisfied N 99
617248 F 75 to 90 Cardiovascular Short Very Satisfied N 89
88011 F 75 to 90 Bariatric Long Very Satisfied Y 89
808028 M 55 to 74 Cardiovascular Short Somewhat Satisfied N 116
475790 M 75 to 90 Orthopedic Short Very Dissatisfied N 109
409054 M 55 to 74 Orthopedic Short Somewhat Satisfied Y 110
257403 F 75 to 90 Cardiovascular Short Very Dissatisfied N 75
280463 F 75 to 90 Bariatric Long Very Satisfied N 139
270818 F 75 to 90 Cardiovascular Short Somewhat Dissatisfied N 77
554256 M 35 to 54 Cardiovascular Short Very Dissatisfied Y 134
770185 F 18 to 34 Cardiovascular Short Very Dissatisfied N 97
547501 F 90+ Bariatric Short Somewhat Satisfied N 116
29275 M 18 to 34 Cardiovascular Short Very Dissatisfied N 120
846028 M 75 to 90 Oncology Short Somewhat Satisfied N 121
253440 F 18 to 34 Oncology Short Somewhat Dissatisfied N 46
955299 F 55 to 74 Bariatric Long Somewhat Satisfied N 141
690109 M 18 to 34 Cardiovascular Short Somewhat Satisfied Y 86
547575 M 55 to 74 Cardiovascular Short Somewhat Satisfied N 105
587145 M 55 to 74 Bariatric Short Somewhat Satisfied Y 143
117582 F 18 to 34 Orthopedic Short Very Satisfied N 50
862229 M 55 to 74 Orthopedic Short Very Satisfied Y 67
827378 F 55 to 74 Orthopedic Short Very Satisfied N 90
979804 F 75 to 90 Oncology Short Somewhat Satisfied N 118
343018 F 90+ Oncology Short Somewhat Satisfied Y 140
247596 M 75 to 90 Cardiovascular Short Somewhat Dissatisfied N 92
298781 F 90+ Bariatric Short Very Satisfied N 86
508314 F 55 to 74 Orthopedic Short Very Dissatisfied N 72
172557 M 75 to 90 Cardiovascular Short Somewhat Satisfied Y 93
12027 F 55 to 74 Oncology Short Somewhat Satisfied N 113
3871 F 55 to 74 Cardiovascular Short Somewhat Satisfied N 112
490503 M 35 to 54 Oncology Short Somewhat Satisfied N 72
719671 F 55 to 74 Bariatric Short Somewhat Dissatisfied N 152
996477 M 75 to 90 Cardiovascular Short Somewhat Satisfied Y 120
130495 M 35 to 54 Oncology Long Somewhat Satisfied N 82
319943 M 55 to 74 Oncology Short Somewhat Satisfied N 119
671159 M 55 to 74 Oncology Short Very Dissatisfied N 121
416905 F 55 to 74 Orthopedic Long Somewhat Dissatisfied N 120
81949 F 18 to 34 Orthopedic Short Very Dissatisfied N 127
523183 F 35 to 54 Orthopedic Short Somewhat Dissatisfied N 92
117231 F 75 to 90 Orthopedic Short Very Satisfied N 147
643647 F 55 to 74 Bariatric Short Very Dissatisfied Y 96
367527 F 75 to 90 Oncology Long Somewhat Satisfied N 118
817784 F 75 to 90 Orthopedic Long Somewhat Satisfied N 53
531065 F 75 to 90 Bariatric Short Very Satisfied Y 124
655773 F 90+ Cardiovascular LongInf Very Satisfied Y 77
650008 M 55 to 74 Orthopedic Short Somewhat Satisfied Y 106
758199 F 18 to 34 Cardiovascular Short Somewhat Satisfied N 73
696409 M 75 to 90 Oncology Short Very Satisfied N 96
909003 F 75 to 90 Bariatric Long Somewhat Dissatisfied N 89
725367 M 75 to 90 Bariatric Short Somewhat Satisfied N 97
686782 M 90+ Oncology Short Somewhat Satisfied Y 112
188435 F 75 to 90 Oncology Short Somewhat Satisfied Y 75
201428 F 55 to 74 Oncology Short Somewhat Satisfied N 79
668942 F 18 to 34 Oncology Long Very Satisfied Y 97
182554 F 55 to 74 Cardiovascular Short Very Dissatisfied N 124
115307 F 75 to 90 Orthopedic Short Very Satisfied N 108
472716 F 55 to 74 Cardiovascular Short Somewhat Satisfied Y 107
116802 F 75 to 90 Orthopedic Short Somewhat Dissatisfied N 123
401121 M 35 to 54 Orthopedic Short Very Satisfied Y 138
618216 M 55 to 74 Bariatric LongInf Somewhat Satisfied N 102
201456 M 55 to 74 Cardiovascular Short Very Satisfied Y 106
417317 F 75 to 90 Oncology Short Somewhat Satisfied N 143
931167 M 75 to 90 Bariatric Short Somewhat Satisfied N 102
715064 F 18 to 34 Oncology Short Very Satisfied N 109
153630 M 35 to 54 Orthopedic LongInf Very Satisfied Y 92
673848 F 75 to 90 Cardiovascular Short Very Satisfied N 123
98662 M 90+ Oncology Long Somewhat Satisfied N 58
127535 F 75 to 90 Cardiovascular Short Somewhat Satisfied N 106
957158 F 55 to 74 Orthopedic Short Somewhat Dissatisfied N 73

Definitions

Variable Description / Definition
PatientID Anonymous patient numerical identifier
Gender M = male; F = female
Age_Range 18 to 34, 35 to 54, 55 to 74, 75 to 90, and 90+
Procedure Bariatric, Orthopedic, Cardiovascular, or Oncology
Outcome Short = Average or shorter than expected length of stay (possibly outpatient); Long = Longer than expected stay, but no post-procedure infection(s); LongInf = Longer than expected stay with post-procedure infection(s)
Satisfaction Very Dissatisfied, Somewhat Dissatisfied, Somewhat Satisfied, and Very Satisfied (post-procedure patient reported data)
WouldRec Y = Yes, N = No (post-procedure patient reported data)
LTV Lifetime Value Index of patient to health system profitability; predictive model assigned by health system analytics team; 100 = average patient value (200 = twice the average patient value, 80 = 80% of average patient value, etc.)