dat<-read.csv('https://raw.githubusercontent.com/tmatis12/datafiles/refs/heads/main/RadDat_IMSE.csv')
dat
## Unique.Identifier PatientAge Radiology.Technician CatalogCode Ordering.Physician
## 1 1 75 65 DX Abdomen 2 vw w/single chest 4
## 2 2 87 65 DX Abdomen 2 vw w/single chest 4
## 3 3 35 16 DX Abdomen 2 vw w/single chest 150
## 4 4 51 24 DX Abdomen 2 vw w/single chest 130
## 5 5 67 37 DX Abdomen 2 vw w/single chest 173
## 6 6 54 7 DX Abdomen 2 vw w/single chest 349
## 7 7 34 40 DX Abdomen 2 vw w/single chest 4
## 8 8 65 2 DX Abdomen 2 vw w/single chest 4
## 9 9 67 2 DX Abdomen 2 vw w/single chest 39
## 10 10 40 34 DX Abdomen 2 vw w/single chest 4
## 11 11 92 33 DX Abdomen 2 vw w/single chest 4
## 12 12 76 74 DX Abdomen 2 vw w/single chest 42
## 13 13 67 72 DX Abdomen 2 vw w/single chest 39
## 14 14 82 57 DX Abdomen 2 vw w/single chest 153
## 15 15 71 57 DX Abdomen 2 vw w/single chest 4
## 16 16 50 9 DX Abdomen 2 vw w/single chest 153
## 17 17 39 23 DX Abdomen 2 vw w/single chest 4
## 18 18 66 23 DX Abdomen 2 vw w/single chest 402
## 19 19 70 57 DX Abdomen 2 vw w/single chest 214
## 20 20 53 9 DX Abdomen 2 vw w/single chest 4
## 21 21 66 9 DX Abdomen 2 vw w/single chest 34
## 22 22 66 70 DX Abdomen 2 vw w/single chest 4
## 23 23 34 35 DX Abdomen 2 vw w/single chest 4
## 24 24 50 45 DX Abdomen 2 vw w/single chest 4
## 25 25 47 35 DX Abdomen 2 vw w/single chest 4
## 26 26 15 5 DX Abdomen 2 vw w/single chest 39
## 27 27 21 68 DX Abdomen 2 vw w/single chest 4
## 28 28 65 51 DX Abdomen 2 vw w/single chest 4
## 29 29 71 51 DX Abdomen 2 vw w/single chest 4
## 30 29 71 22 DX Abdomen 2 vw w/single chest 4
## 31 29 71 28 DX Abdomen 2 vw w/single chest 4
## 32 30 66 28 DX Abdomen 2 vw w/single chest 4
## 33 31 47 68 DX Abdomen 2 vw w/single chest 130
## 34 32 49 68 DX Abdomen 2 vw w/single chest 260
## 35 33 61 28 DX Abdomen 2 vw w/single chest 4
## 36 34 92 25 DX Abdomen 2 vw w/single chest 4
## 37 35 78 27 DX Abdomen 2 vw w/single chest 4
## 38 36 28 25 DX Abdomen 2 vw w/single chest 349
## 39 37 71 25 DX Abdomen 2 vw w/single chest 4
## 40 38 47 20 DX Abdomen 2 vw w/single chest 4
## 41 39 51 22 DX Abdomen 2 vw w/single chest 130
## 42 40 26 68 DX Abdomen 2 vw w/single chest 42
## 43 41 84 57 DX Abdomen 2 vw w/single chest 4
## 44 42 58 45 DX Abdomen 2 vw w/single chest 4
## 45 43 86 28 DX Abdomen 2 vw w/single chest 214
## 46 44 50 27 DX Abdomen 2 vw w/single chest 4
## 47 45 27 65 DX Abdomen 2 vw w/single chest 276
## 48 46 37 46 DX Abdomen 2 vw w/single chest 276
## 49 47 38 46 DX Abdomen 2 vw w/single chest 15
## 50 48 26 52 DX Abdomen 2 vw w/single chest 366
## 51 49 54 52 DX Abdomen 2 vw w/single chest 173
## 52 50 39 15 DX Abdomen 2 vw w/single chest 228
## 53 51 19 46 DX Abdomen 2 vw w/single chest 276
## 54 52 66 16 DX Abdomen 2 vw w/single chest 366
## 55 53 57 37 DX Abdomen 2 vw w/single chest 276
## 56 54 24 37 DX Abdomen 2 vw w/single chest 276
## 57 55 72 37 DX Abdomen 2 vw w/single chest 366
## 58 56 20 7 DX Abdomen 2 vw w/single chest 276
## 59 57 46 37 DX Abdomen 2 vw w/single chest 276
## 60 58 29 7 DX Abdomen 2 vw w/single chest 276
## 61 59 43 37 DX Abdomen 2 vw w/single chest 276
## 62 60 34 7 DX Abdomen 2 vw w/single chest 276
## PatientTypeMnemonic Priority OrderDateTime ExamCompleteDateTime FinalDateTime
## 1 IP Routine 12/27/16 10:32 12/27/16 11:19 12/28/16 14:32
## 2 IP Routine 1/13/17 11:44 1/13/17 12:32 1/14/17 16:00
## 3 IP Routine 1/2/17 17:19 1/2/17 18:00 1/3/17 7:44
## 4 IP Routine 11/13/16 10:13 11/14/16 9:34 11/14/16 16:40
## 5 IP STAT 12/13/16 3:22 12/13/16 4:04 12/13/16 3:19
## 6 IP Routine 1/17/17 5:38 1/17/17 7:47 1/17/17 10:55
## 7 IP Routine 10/6/16 10:12 10/6/16 10:54 10/6/16 11:13
## 8 IP Routine 11/17/16 11:59 11/18/16 5:47 11/18/16 7:02
## 9 IP Routine 1/19/17 16:51 1/19/17 17:40 1/20/17 8:08
## 10 IP Routine 1/23/17 15:36 1/23/17 16:23 1/23/17 16:50
## 11 IP Routine 10/9/16 9:52 10/10/16 7:47 10/10/16 8:59
## 12 IP STAT 12/22/16 18:15 12/22/16 19:09 12/23/16 14:22
## 13 IP STAT 1/15/17 17:54 1/15/17 18:44 1/16/17 8:19
## 14 IP Routine 10/15/16 7:38 10/16/16 6:09 10/16/16 8:38
## 15 IP Routine 12/29/16 9:23 12/30/16 5:37 1/10/17 11:19
## 16 IP Routine 1/5/17 5:31 1/5/17 6:35 1/6/17 10:07
## 17 IP Routine 11/14/16 9:15 11/14/16 10:45 11/14/16 13:13
## 18 IP Routine 11/14/16 7:06 11/14/16 8:36 11/14/16 13:11
## 19 IP Routine 4/2/17 6:49 4/2/17 7:55 4/2/17 10:21
## 20 IP Routine 10/4/16 9:09 10/4/16 10:29 10/4/16 20:44
## 21 IP Routine 11/14/16 10:19 11/15/16 5:41 11/15/16 20:47
## 22 IP Routine 11/21/16 17:36 11/21/16 18:45 11/23/16 9:13
## 23 IP Routine 10/8/16 10:06 10/9/16 6:55 10/9/16 7:58
## 24 IP Routine 11/15/16 8:14 11/15/16 9:38 11/15/16 23:18
## 25 IP Routine 11/14/16 9:35 11/14/16 11:14 11/14/16 13:16
## 26 IP Routine 11/30/16 19:14 11/30/16 20:30 12/1/16 8:53
## 27 IP Routine 1/1/17 18:29 1/1/17 19:21 1/2/17 8:19
## 28 IP Routine 11/16/16 11:22 11/17/16 6:36 11/17/16 11:40
## 29 IP Routine 12/27/16 13:21 12/28/16 6:33 1/1/17 16:53
## 30 IP Routine 12/26/16 8:59 12/26/16 9:42 12/26/16 10:22
## 31 IP Routine 12/23/16 9:16 12/23/16 10:22 12/23/16 13:01
## 32 IP Routine 12/8/16 10:18 12/8/16 12:13 12/8/16 17:21
## 33 IP Routine 1/12/17 16:15 1/12/17 16:58 1/13/17 7:41
## 34 IP STAT 1/2/17 16:44 1/2/17 17:28 1/2/17 20:14
## 35 IP Routine 10/15/16 9:21 10/15/16 11:13 10/15/16 17:27
## 36 IP Routine 10/8/16 10:52 10/9/16 8:37 10/9/16 8:54
## 37 IP Routine 1/25/17 7:25 1/25/17 8:55 1/25/17 10:29
## 38 IP STAT 1/28/17 5:09 1/28/17 5:29 1/28/17 4:19
## 39 IP Routine 12/3/16 9:09 12/3/16 10:03 12/3/16 10:12
## 40 IP Routine 1/8/17 19:03 1/8/17 20:18 1/9/17 16:31
## 41 IP Routine 12/7/16 11:12 12/8/16 8:07 12/8/16 10:34
## 42 IP STAT 10/9/16 14:44 10/9/16 15:47 10/9/16 16:30
## 43 IP Routine 2/16/17 15:28 2/17/17 6:04 2/17/17 12:31
## 44 OPOBS Routine 10/29/16 19:10 10/29/16 20:25 10/29/16 22:13
## 45 IP STAT 11/28/16 9:38 11/28/16 10:41 11/28/16 10:44
## 46 OPOBS Routine 12/28/16 10:11 12/28/16 10:44 1/1/17 19:08
## 47 OPEC STAT 12/17/16 18:09 12/17/16 18:49 12/17/16 17:49
## 48 OPEC STAT 2/6/17 10:37 2/6/17 10:58 2/6/17 11:16
## 49 OPEC STAT 3/16/17 8:04 3/16/17 8:24 3/16/17 9:00
## 50 OPOBS STAT 12/18/16 1:33 12/18/16 1:52 12/18/16 1:50
## 51 IP STAT 3/4/17 6:43 3/4/17 7:08 3/4/17 6:27
## 52 OPEC STAT 11/15/16 9:10 11/15/16 9:57 11/15/16 10:03
## 53 OPEC STAT 2/8/17 10:04 2/8/17 10:26 2/8/17 10:40
## 54 OPOBS STAT 10/13/16 21:34 10/13/16 21:54 10/13/16 22:42
## 55 OPEC STAT 3/8/17 7:32 3/8/17 8:18 3/8/17 8:30
## 56 OPEC STAT 12/30/16 11:45 12/30/16 11:59 12/30/16 12:05
## 57 OPEC STAT 11/14/16 4:10 11/14/16 4:23 11/14/16 3:13
## 58 OPEC STAT 10/26/16 11:01 10/26/16 11:14 10/26/16 11:28
## 59 OPEC STAT 10/26/16 7:37 10/26/16 8:07 10/26/16 8:55
## 60 OPEC STAT 10/28/16 8:53 10/28/16 9:29 10/28/16 12:51
## 61 OPEC STAT 10/19/16 7:29 10/19/16 7:44 10/19/16 6:00
## 62 OPEC STAT 10/28/16 13:10 10/28/16 13:38 10/28/16 13:53
## Ordered.to.Complete...Mins Ordered.to.Complete...Hours Loc.At.Exam.Complete Exam.Completed.Bucket Section
## 1 47 0.7833333 GTU 8a-8p DX
## 2 48 0.8000000 GTU 8a-8p DX
## 3 41 0.6833333 3W 8a-8p EC DX
## 4 1401 23.3500000 4W 8a-8p DX
## 5 42 0.7000000 Emergency Ctr 12a-8a EC DX
## 6 129 2.1500000 3E 12a-8a DX
## 7 42 0.7000000 3E 8a-8p DX
## 8 1068 17.8000000 3E 12a-8a EC DX
## 9 49 0.8166667 BICU 8a-8p DX
## 10 47 0.7833333 3W 8a-8p DX
## 11 1315 21.9166667 5E 12a-8a EC DX
## 12 54 0.9000000 BICU 8a-8p DX
## 13 50 0.8333333 BICU 8a-8p DX
## 14 1351 22.5166667 5E 12a-8a EC DX
## 15 1214 20.2333333 3W 12a-8a EC DX
## 16 64 1.0666667 3E 12a-8a EC DX
## 17 90 1.5000000 3W 8a-8p EC DX
## 18 90 1.5000000 3W 8a-8p DX
## 19 66 1.1000000 MICUS 12a-8a DX
## 20 80 1.3333333 3W 8a-8p DX
## 21 1162 19.3666667 3W 12a-8a EC DX
## 22 69 1.1500000 5W 8a-8p EC DX
## 23 1249 20.8166667 3E 12a-8a EC DX
## 24 84 1.4000000 4W 8a-8p DX
## 25 99 1.6500000 MICUN 8a-8p DX
## 26 76 1.2666667 BICU 8p-12a DX
## 27 52 0.8666667 4E 8a-8p EC DX
## 28 1154 19.2333333 3E 12a-8a EC DX
## 29 1032 17.2000000 3W 12a-8a EC DX
## 30 43 0.7166667 3W 8a-8p DX
## 31 66 1.1000000 3W 8a-8p EC DX
## 32 115 1.9166667 3W 8a-8p DX
## 33 43 0.7166667 4W 8a-8p DX
## 34 44 0.7333333 3E 8a-8p EC DX
## 35 112 1.8666667 3W 8a-8p EC DX
## 36 1305 21.7500000 5E 8a-8p EC DX
## 37 90 1.5000000 GTU 8a-8p EC DX
## 38 20 0.3333333 Emergency Ctr 12a-8a EC DX
## 39 54 0.9000000 4W 8a-8p EC DX
## 40 75 1.2500000 4W 8p-12a EC DX
## 41 1255 20.9166667 4W 8a-8p DX
## 42 63 1.0500000 3E 8a-8p EC DX
## 43 876 14.6000000 4W 12a-8a EC DX
## 44 75 1.2500000 5W 8p-12a EC DX
## 45 63 1.0500000 4W 8a-8p DX
## 46 33 0.5500000 4W 8a-8p DX
## 47 40 0.6666667 Emergency Ctr 8a-8p EC DX
## 48 21 0.3500000 Emergency Ctr 8a-8p EC DX
## 49 20 0.3333333 Emergency Ctr 8a-8p EC DX
## 50 19 0.3166667 Emergency Ctr 12a-8a EC DX
## 51 25 0.4166667 Emergency Ctr 12a-8a EC DX
## 52 47 0.7833333 Emergency Ctr 8a-8p EC DX
## 53 22 0.3666667 Emergency Ctr 8a-8p EC DX
## 54 20 0.3333333 Emergency Ctr 8p-12a EC DX
## 55 46 0.7666667 Emergency Ctr 8a-8p EC DX
## 56 14 0.2333333 Emergency Ctr 8a-8p EC DX
## 57 13 0.2166667 Emergency Ctr 12a-8a EC DX
## 58 13 0.2166667 Emergency Ctr 8a-8p EC DX
## 59 30 0.5000000 Emergency Ctr 8a-8p EC DX
## 60 36 0.6000000 Emergency Ctr 8a-8p EC DX
## 61 15 0.2500000 Emergency Ctr 12a-8a EC DX
## 62 28 0.4666667 Emergency Ctr 8a-8p EC DX
## Exam.Room
## 1 DX Rm 1
## 2 DX Rm 1
## 3 DX Rm 5 (EC)
## 4 DX Rm 1
## 5 DX Rm 5 (EC)
## 6 DX Portable
## 7 DX Rm 1
## 8 DX Rm 5 (EC)
## 9 DX Rm 1
## 10 DX Rm 1
## 11 DX Rm 5 (EC)
## 12 DX Portable
## 13 DX Portable
## 14 DX Rm 5 (EC)
## 15 DX Rm 5 (EC)
## 16 DX Rm 5 (EC)
## 17 DX Rm 5 (EC)
## 18 DX Rm 1
## 19 DX Portable
## 20 DX Rm 1
## 21 DX Rm 5 (EC)
## 22 DX Rm 5 (EC)
## 23 DX Rm 5 (EC)
## 24 DX Rm 1
## 25 DX Rm 1
## 26 DX Portable
## 27 DX Rm 5 (EC)
## 28 DX Rm 5 (EC)
## 29 DX Rm 5 (EC)
## 30 DX Rm 1
## 31 DX Rm 5 (EC)
## 32 DX Rm 1
## 33 DX Rm 1
## 34 DX Rm 5 (EC)
## 35 DX Rm 5 (EC)
## 36 DX Rm 5 (EC)
## 37 DX Rm 5 (EC)
## 38 DX Rm 5 (EC)
## 39 DX Rm 5 (EC)
## 40 DX Rm 5 (EC)
## 41 DX Rm 1
## 42 DX Rm 5 (EC)
## 43 DX Rm 5 (EC)
## 44 DX Rm 5 (EC)
## 45 DX Rm 1
## 46 DX Rm 1
## 47 DX Rm 5 (EC)
## 48 DX Rm 5 (EC)
## 49 DX Rm 5 (EC)
## 50 DX Rm 5 (EC)
## 51 DX Rm 5 (EC)
## 52 DX Rm 5 (EC)
## 53 DX Rm 5 (EC)
## 54 DX Rm 5 (EC)
## 55 DX Rm 5 (EC)
## 56 DX Rm 5 (EC)
## 57 DX Rm 5 (EC)
## 58 DX Rm 5 (EC)
## 59 DX Rm 5 (EC)
## 60 DX Rm 5 (EC)
## 61 DX Rm 5 (EC)
## 62 DX Rm 5 (EC)
## [ reached 'max' / getOption("max.print") -- omitted 43570 rows ]
dat<-dat[dat$Ordered.to.Complete...Mins > 0,]
#Question 1
oversixtyfive<-dat[dat$PatientAge> 65,]
oversixtyfive
## Unique.Identifier PatientAge Radiology.Technician CatalogCode Ordering.Physician
## 1 1 75 65 DX Abdomen 2 vw w/single chest 4
## 2 2 87 65 DX Abdomen 2 vw w/single chest 4
## 5 5 67 37 DX Abdomen 2 vw w/single chest 173
## 9 9 67 2 DX Abdomen 2 vw w/single chest 39
## 11 11 92 33 DX Abdomen 2 vw w/single chest 4
## 12 12 76 74 DX Abdomen 2 vw w/single chest 42
## 13 13 67 72 DX Abdomen 2 vw w/single chest 39
## 14 14 82 57 DX Abdomen 2 vw w/single chest 153
## 15 15 71 57 DX Abdomen 2 vw w/single chest 4
## 18 18 66 23 DX Abdomen 2 vw w/single chest 402
## 19 19 70 57 DX Abdomen 2 vw w/single chest 214
## 21 21 66 9 DX Abdomen 2 vw w/single chest 34
## 22 22 66 70 DX Abdomen 2 vw w/single chest 4
## 29 29 71 51 DX Abdomen 2 vw w/single chest 4
## 30 29 71 22 DX Abdomen 2 vw w/single chest 4
## 31 29 71 28 DX Abdomen 2 vw w/single chest 4
## 32 30 66 28 DX Abdomen 2 vw w/single chest 4
## 36 34 92 25 DX Abdomen 2 vw w/single chest 4
## 37 35 78 27 DX Abdomen 2 vw w/single chest 4
## 39 37 71 25 DX Abdomen 2 vw w/single chest 4
## 43 41 84 57 DX Abdomen 2 vw w/single chest 4
## 45 43 86 28 DX Abdomen 2 vw w/single chest 214
## 54 52 66 16 DX Abdomen 2 vw w/single chest 366
## 57 55 72 37 DX Abdomen 2 vw w/single chest 366
## 64 62 79 40 DX Abdomen 2 vw w/single chest 4
## 67 65 66 42 DX Abdomen 2 vw w/single chest 366
## 71 69 72 42 DX Abdomen 2 vw w/single chest 366
## 81 79 92 74 DX Abdomen 2 vw w/single chest 73
## 83 81 82 9 DX Abdomen 2 vw w/single chest 243
## 93 91 83 23 DX Abdomen 2 vw w/single chest 309
## 96 94 78 57 DX Abdomen 2 vw w/single chest 74
## 108 106 84 23 DX Abdomen 2 vw w/single chest 173
## 110 108 88 35 DX Abdomen 2 vw w/single chest 366
## 113 111 68 56 DX Abdomen 2 vw w/single chest 309
## 126 124 72 4 DX Abdomen 2 vw w/single chest 276
## 138 136 81 22 DX Abdomen 2 vw w/single chest 366
## 144 142 84 17 DX Abdomen 2 vw w/single chest 309
## 151 149 68 65 DX Abdomen 2+ vw 117
## 156 154 82 52 DX Abdomen 2+ vw 223
## 157 155 86 37 DX Abdomen 2+ vw 34
## 160 158 70 37 DX Abdomen 2+ vw 214
## 168 165 83 9 DX Abdomen 2+ vw 105
## 172 169 82 9 DX Abdomen 2+ vw 223
## 173 170 70 9 DX Abdomen 2+ vw 214
## 174 171 71 9 DX Abdomen 2+ vw 264
## 176 173 66 14 DX Abdomen 2+ vw 223
## 179 176 82 9 DX Abdomen 2+ vw 223
## 182 179 76 57 DX Abdomen 2+ vw 34
## 183 180 66 68 DX Abdomen 2+ vw 34
## 188 185 89 23 DX Abdomen 2+ vw 314
## 194 191 95 28 DX Abdomen 2+ vw 322
## 197 194 66 28 DX Abdomen 2+ vw 191
## 203 200 82 36 DX Abdomen 2+ vw 4
## 206 203 86 22 DX Abdomen 2+ vw 34
## 210 207 78 20 DX Abdomen 2+ vw 206
## 215 212 70 60 DX Abdomen 2+ vw 236
## 224 221 86 5 DX Abdomen 2+ vw 150
## 233 230 70 65 DX Abdomen 2+ vw 190
## 240 237 71 65 DX Abdomen 2+ vw 295
## 241 238 80 65 DX Abdomen 2+ vw 173
## 249 246 71 46 DX Abdomen 2+ vw 105
## 251 248 92 46 DX Abdomen 2+ vw 309
## PatientTypeMnemonic Priority OrderDateTime ExamCompleteDateTime FinalDateTime
## 1 IP Routine 12/27/16 10:32 12/27/16 11:19 12/28/16 14:32
## 2 IP Routine 1/13/17 11:44 1/13/17 12:32 1/14/17 16:00
## 5 IP STAT 12/13/16 3:22 12/13/16 4:04 12/13/16 3:19
## 9 IP Routine 1/19/17 16:51 1/19/17 17:40 1/20/17 8:08
## 11 IP Routine 10/9/16 9:52 10/10/16 7:47 10/10/16 8:59
## 12 IP STAT 12/22/16 18:15 12/22/16 19:09 12/23/16 14:22
## 13 IP STAT 1/15/17 17:54 1/15/17 18:44 1/16/17 8:19
## 14 IP Routine 10/15/16 7:38 10/16/16 6:09 10/16/16 8:38
## 15 IP Routine 12/29/16 9:23 12/30/16 5:37 1/10/17 11:19
## 18 IP Routine 11/14/16 7:06 11/14/16 8:36 11/14/16 13:11
## 19 IP Routine 4/2/17 6:49 4/2/17 7:55 4/2/17 10:21
## 21 IP Routine 11/14/16 10:19 11/15/16 5:41 11/15/16 20:47
## 22 IP Routine 11/21/16 17:36 11/21/16 18:45 11/23/16 9:13
## 29 IP Routine 12/27/16 13:21 12/28/16 6:33 1/1/17 16:53
## 30 IP Routine 12/26/16 8:59 12/26/16 9:42 12/26/16 10:22
## 31 IP Routine 12/23/16 9:16 12/23/16 10:22 12/23/16 13:01
## 32 IP Routine 12/8/16 10:18 12/8/16 12:13 12/8/16 17:21
## 36 IP Routine 10/8/16 10:52 10/9/16 8:37 10/9/16 8:54
## 37 IP Routine 1/25/17 7:25 1/25/17 8:55 1/25/17 10:29
## 39 IP Routine 12/3/16 9:09 12/3/16 10:03 12/3/16 10:12
## 43 IP Routine 2/16/17 15:28 2/17/17 6:04 2/17/17 12:31
## 45 IP STAT 11/28/16 9:38 11/28/16 10:41 11/28/16 10:44
## 54 OPOBS STAT 10/13/16 21:34 10/13/16 21:54 10/13/16 22:42
## 57 OPEC STAT 11/14/16 4:10 11/14/16 4:23 11/14/16 3:13
## 64 IP Routine 10/29/16 12:16 10/29/16 12:37 10/29/16 13:00
## 67 IP STAT 11/2/16 19:33 11/2/16 20:06 11/2/16 18:58
## 71 IP STAT 3/3/17 19:22 3/3/17 19:53 3/3/17 20:10
## 81 OPEC STAT 4/2/17 16:13 4/2/17 16:35 4/2/17 16:54
## 83 OPOBS STAT 3/28/17 21:43 3/28/17 22:12 3/28/17 21:53
## 93 OPEC STAT 2/25/17 22:46 2/25/17 23:33 2/25/17 22:12
## 96 OPEC STAT 12/4/16 23:41 12/5/16 0:04 12/4/16 23:28
## 108 OPEC STAT 12/5/16 8:05 12/5/16 8:41 12/5/16 8:49
## 110 OPEC STAT 11/23/16 20:06 11/23/16 20:48 11/23/16 19:57
## 113 OPEC STAT 3/3/17 15:54 3/3/17 17:13 3/3/17 18:02
## 126 OPEC STAT 10/2/16 14:39 10/2/16 15:21 10/2/16 16:36
## 138 IP STAT 3/10/17 18:57 3/10/17 19:48 3/10/17 19:56
## 144 OPEC STAT 2/1/17 23:40 2/2/17 0:08 2/1/17 23:10
## 151 IP STAT 2/4/17 10:32 2/4/17 12:35 2/4/17 13:10
## 156 IP Routine 10/14/16 14:38 10/15/16 3:19 10/15/16 8:31
## 157 IP Routine 12/27/16 10:57 12/28/16 5:36 1/1/17 16:46
## 160 IP Routine 4/2/17 21:12 4/3/17 4:44 4/3/17 7:19
## 168 IP Routine 2/27/17 9:03 2/28/17 5:06 2/28/17 7:55
## 172 IP Routine 10/12/16 16:06 10/13/16 5:20 10/13/16 8:09
## 173 IP Routine 4/3/17 6:23 4/4/17 2:11 4/4/17 10:15
## 174 IP Routine 3/6/17 14:07 3/7/17 5:05 3/7/17 8:08
## 176 IP Routine 10/1/16 1:12 10/1/16 5:51 10/1/16 7:46
## 179 IP Routine 10/13/16 7:15 10/14/16 2:06 10/14/16 7:27
## 182 IP Routine 12/28/16 5:52 12/28/16 6:41 1/1/17 0:19
## 183 IP Routine 11/16/16 16:02 11/17/16 6:32 11/17/16 12:22
## 188 IP Routine 2/25/17 10:08 2/25/17 11:23 2/25/17 13:00
## 194 IP STAT 12/14/16 21:56 12/14/16 23:22 12/15/16 8:20
## 197 IP Routine 10/31/16 9:45 10/31/16 11:25 10/31/16 11:42
## 203 IP STAT 10/23/16 16:46 10/23/16 17:13 10/24/16 8:48
## 206 IP Routine 12/28/16 8:36 12/29/16 6:09 12/30/16 16:47
## 210 IP STAT 3/11/17 13:50 3/11/17 15:07 3/11/17 15:09
## 215 OPOBS Routine 11/27/16 15:55 11/27/16 17:04 11/28/16 8:14
## 224 IP Routine 12/25/16 10:03 12/25/16 11:10 12/25/16 11:32
## 233 OPEC STAT 10/6/16 14:41 10/6/16 15:07 10/6/16 15:18
## 240 OPEC STAT 1/8/17 12:54 1/8/17 13:15 1/8/17 15:35
## 241 OPEC STAT 1/9/17 12:33 1/9/17 12:55 1/9/17 13:07
## 249 OPEC STAT 3/15/17 9:48 3/15/17 10:35 3/15/17 10:57
## 251 IP STAT 3/27/17 10:20 3/27/17 10:56 3/27/17 10:59
## Ordered.to.Complete...Mins Ordered.to.Complete...Hours Loc.At.Exam.Complete Exam.Completed.Bucket
## 1 47 0.7833333 GTU 8a-8p
## 2 48 0.8000000 GTU 8a-8p
## 5 42 0.7000000 Emergency Ctr 12a-8a
## 9 49 0.8166667 BICU 8a-8p
## 11 1315 21.9166667 5E 12a-8a
## 12 54 0.9000000 BICU 8a-8p
## 13 50 0.8333333 BICU 8a-8p
## 14 1351 22.5166667 5E 12a-8a
## 15 1214 20.2333333 3W 12a-8a
## 18 90 1.5000000 3W 8a-8p
## 19 66 1.1000000 MICUS 12a-8a
## 21 1162 19.3666667 3W 12a-8a
## 22 69 1.1500000 5W 8a-8p
## 29 1032 17.2000000 3W 12a-8a
## 30 43 0.7166667 3W 8a-8p
## 31 66 1.1000000 3W 8a-8p
## 32 115 1.9166667 3W 8a-8p
## 36 1305 21.7500000 5E 8a-8p
## 37 90 1.5000000 GTU 8a-8p
## 39 54 0.9000000 4W 8a-8p
## 43 876 14.6000000 4W 12a-8a
## 45 63 1.0500000 4W 8a-8p
## 54 20 0.3333333 Emergency Ctr 8p-12a
## 57 13 0.2166667 Emergency Ctr 12a-8a
## 64 21 0.3500000 Emergency Ctr 8a-8p
## 67 33 0.5500000 Emergency Ctr 8p-12a
## 71 31 0.5166667 Emergency Ctr 8a-8p
## 81 22 0.3666667 Emergency Ctr 8a-8p
## 83 29 0.4833333 Emergency Ctr 8p-12a
## 93 47 0.7833333 Emergency Ctr 8p-12a
## 96 23 0.3833333 Emergency Ctr 12a-8a
## 108 36 0.6000000 Emergency Ctr 8a-8p
## 110 42 0.7000000 Emergency Ctr 8p-12a
## 113 79 1.3166667 Emergency Ctr 8a-8p
## 126 42 0.7000000 Emergency Ctr 8a-8p
## 138 51 0.8500000 Emergency Ctr 8a-8p
## 144 28 0.4666667 Emergency Ctr 12a-8a
## 151 123 2.0500000 SICU 8a-8p
## 156 761 12.6833333 MICUS 12a-8a
## 157 1119 18.6500000 SCU 12a-8a
## 160 452 7.5333333 MICUS 12a-8a
## 168 1203 20.0500000 4E 12a-8a
## 172 794 13.2333333 SCU 12a-8a
## 173 1188 19.8000000 MICUS 12a-8a
## 174 898 14.9666667 GTU 12a-8a
## 176 279 4.6500000 3E 12a-8a
## 179 1131 18.8500000 MICUS 12a-8a
## 182 49 0.8166667 3E 12a-8a
## 183 870 14.5000000 3W 12a-8a
## 188 75 1.2500000 SICU 8a-8p
## 194 86 1.4333333 4E 8p-12a
## 197 100 1.6666667 4W 8a-8p
## 203 27 0.4500000 SICU 8a-8p
## 206 1293 21.5500000 SCU 12a-8a
## 210 77 1.2833333 SCU 8a-8p
## 215 69 1.1500000 4W 8a-8p
## 224 67 1.1166667 3E 8a-8p
## 233 26 0.4333333 Emergency Ctr 8a-8p
## 240 21 0.3500000 Emergency Ctr 8a-8p
## 241 22 0.3666667 Emergency Ctr 8a-8p
## 249 47 0.7833333 Emergency Ctr 8a-8p
## 251 36 0.6000000 Emergency Ctr 8a-8p
## Section Exam.Room
## 1 DX DX Rm 1
## 2 DX DX Rm 1
## 5 EC DX DX Rm 5 (EC)
## 9 DX DX Rm 1
## 11 EC DX DX Rm 5 (EC)
## 12 DX DX Portable
## 13 DX DX Portable
## 14 EC DX DX Rm 5 (EC)
## 15 EC DX DX Rm 5 (EC)
## 18 DX DX Rm 1
## 19 DX DX Portable
## 21 EC DX DX Rm 5 (EC)
## 22 EC DX DX Rm 5 (EC)
## 29 EC DX DX Rm 5 (EC)
## 30 DX DX Rm 1
## 31 EC DX DX Rm 5 (EC)
## 32 DX DX Rm 1
## 36 EC DX DX Rm 5 (EC)
## 37 EC DX DX Rm 5 (EC)
## 39 EC DX DX Rm 5 (EC)
## 43 EC DX DX Rm 5 (EC)
## 45 DX DX Rm 1
## 54 EC DX DX Rm 5 (EC)
## 57 EC DX DX Rm 5 (EC)
## 64 EC DX DX Rm 5 (EC)
## 67 EC DX DX Rm 5 (EC)
## 71 EC DX DX Rm 5 (EC)
## 81 EC DX DX Rm 5 (EC)
## 83 EC DX DX Rm 5 (EC)
## 93 EC DX DX Rm 5 (EC)
## 96 EC DX DX Rm 5 (EC)
## 108 EC DX DX Rm 5 (EC)
## 110 EC DX DX Rm 5 (EC)
## 113 EC DX DX Rm 5 (EC)
## 126 EC DX DX Rm 5 (EC)
## 138 EC DX DX Rm 5 (EC)
## 144 EC DX DX Rm 5 (EC)
## 151 DX DX Portable
## 156 DX DX Portable
## 157 EC DX DX Rm 5 (EC)
## 160 EC DX DX Rm 5 (EC)
## 168 EC DX DX Rm 5 (EC)
## 172 EC DX DX Rm 5 (EC)
## 173 DX DX Portable
## 174 EC DX DX Rm 5 (EC)
## 176 EC DX DX Rm 5 (EC)
## 179 DX DX Portable
## 182 EC DX DX Rm 6 (EC)
## 183 EC DX DX Rm 5 (EC)
## 188 DX DX Portable
## 194 EC DX DX Rm 5 (EC)
## 197 DX DX Rm 1
## 203 DX DX Portable
## 206 EC DX DX Rm 5 (EC)
## 210 DX DX Portable
## 215 EC DX DX Rm 5 (EC)
## 224 DX DX Portable
## 233 EC DX DX Rm 5 (EC)
## 240 EC DX DX Rm 5 (EC)
## 241 EC DX DX Rm 5 (EC)
## 249 EC DX DX Rm 5 (EC)
## 251 EC DX DX Rm 5 (EC)
## [ reached 'max' / getOption("max.print") -- omitted 11879 rows ]
quantile(quantile(oversixtyfive$Ordered.to.Complete...Mins,0.25),0.25)
## 25%
## 21
quantile(oversixtyfive$Ordered.to.Complete...Mins,0.75)
## 75%
## 90
time<-oversixtyfive[oversixtyfive$Ordered.to.Complete...Mins>21 & oversixtyfive$Ordered.to.Complete...Mins <90,5]
hist(time,main="Histogram of X-ray time", xlab="Time",col="pink",border="black")
#Question 2
median(dat[dat$Radiology.Technician == 62,5])
## [1] 228
median(dat[dat$Radiology.Technician == 65,5])
## [1] 173
# The median of 62 is greater than the median of 65
#Question 3
summary(dat$Priority)
## Length Class Mode
## 43524 character character
install.packages("dplyr")
## Installing package into 'C:/Users/jamir/AppData/Local/R/win-library/4.4'
## (as 'lib' is unspecified)
## package 'dplyr' successfully unpacked and MD5 sums checked
##
## The downloaded binary packages are in
## C:\Users\jamir\AppData\Local\Temp\RtmpM5kpIF\downloaded_packages
library(dplyr)
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
AgeSTAT<- dat %>% filter(Priority=="STAT")
AgeRoutine<- dat %>% filter(Priority=="Routine")
boxplot(AgeSTAT$PatientAge,AgeRoutine$PatientAge,main="Age of STAT vs. Routine Patients for X-Rays",
names=c("STAT","Routine"),col=c("red","blue"),xlab="Time",ylab="Age")
#Question 4
floorthreetime<- dat %>% filter(Loc.At.Exam.Complete=="3W")
floorfourtime<- dat %>% filter(Loc.At.Exam.Complete=="4W")
mean(floorthreetime$Ordered.to.Complete...Mins)
## [1] 1463.051
mean(floorfourtime$Ordered.to.Complete...Mins)
## [1] 1675.451
#On floor 4W it takes more time to complete an x-ray than it does on floor 3W