The file on the course's website called Intersection_data.xls contains collision records for 100 intersections. A number of potential explanatory (independent) variables are also measured. Develop a collision prediction model and show your analysis steps. Attempt the following model forms:
b] A Non-linear model with Gaussian error
Calculate also the mean and variance of the number collisions observed across the imaginary reference population matching each one of the 100 intersections. You will need to attach the software output or the Excel file you used to conduct regression analysis.
Major AAD Minor AAD pdo sev tot fat inj 24138 1550 33 32 65 O 32 22864 19083 99 69 168 69 21040 15944 96 103 199 103 21566 15561 56 56 112 56 13937 12062 14 8 22 8 6 27496 16528 146 129 275 128 7 71952 9477 127 144 271 144 8 32713 7313 77 82 159 82 9 26410 2301 9 11 20 11 10 17883 7033 33 30 63 29 11 25734 6555 49 44 93 44 12 50497 13291 60 80 140 79 13 50602 17670 45 53 98 53 14 17864 5306 17 19 36 19 15 51497 27346 134 110 244 110 16 50665 46868 395 429 824 429 17 40592 17750 167 160 327 160 18 59323 6850 26 45 71 45 19 43097 37903 396 518 914 518 20 28008 2000 9 15 24 15 21 39825 31260 201 234 435 233 22 34632 30104 170 138 308 138 23 33232 11023 49 98 147 98 24 39413 36813 164 170 334 O P P O O O P O P O P H O O P N O O O N O O O O O P O O O O O O O O P O P O O O P O O O C 170 25 45623 44106 229 314 543 314 26 45232 28948 69 93 162 93 27 44229 38302 204 281 485 279 28 40740 19955 186 205 391 205 29 32679 17261 180 177 357 177 30 21214 1313 9 13 22 13 31 42262 20492 197 297 494 295 32 15341 10097 72 66 138 65 33 23517 10112 65 54 119 54 34 35396 6063 59 63 122 63 35 23127 10997 87 114 201 113 36 65969 3641 65 91 156 90 37 29030 11187 99 107 206 107 38 34355 24453 155 210 365 209 39 23405 21199 180 217 397 217 40 39938 13325 70 123 193 122 41 50035 16294 203 268 471 268 42 26668 1500 7 12 19 12 43 37974 1991 21 58 79 58 44 52837 27113 306 323 629 322 45 53033 16327 260 295 555 294 46 35425 30080 164 218 382 21847 35939 7350 65 71 136 71 48 54845 2763 48 46 94 49 22902 20008 69 80 149 80 50 22250 17782 34 24 58 24 51 48284 25524 25 29 54 29 52 25524 3100 35 41 76 53 29570 25524 102 132 234 132 54 14508 3125 26 16 42 15 55 55823 2000 18 21 39 21 56 60111 5350 27 41 68 41 57 24918 21568 122 178 300 177 58 57782 11399 131 183 314 183 59 34163 29370 105 173 278 173 60 35153 1600 18 43 61 43 61 37820 24090 286 313 599 313 62 40951 35477 235 320 555 319 63 45063 22273 393 489 882 489 64 61331 20001 239 234 473 234 65 36095 17601 81 108 189 107 66 38081 32817 211 292 503 292 67 18386 6540 33 26 59 26 68 36526 3700 43 46 89 46 69 24287 18174 112 118 230 118 70 18008 2391 24 27 51 O H H H O O O O O O O O O H O O O O O H H H N O O O O O H O O H O O O O H O O P O O O O O O O 27 71 31148 28875 143 193 336 191 72 27880 25338 154 151 305 150 73 31331 29501 122 174 296 173 74 43900 11630 204 204 408 203 75 32013 5350 38 44 82 44 76 47020 3175 45 63 108 63 77 15321 12175 60 56 116 56 78 37388 22669 165 231 396 231 79 41618 2825 19 29 48 29 80 48188 27866 340 322 662 321 81 52332 19314 198 183 381 183 82 33376 23413 130 148 278 148 83 50525 3619 43 60 103 60 84 32900 11136 31 53 84 53 85 39250 21874 136 177 313 177 86 25435 24125 106 130 236 130 87 41414 27247 119 178 297 178 88 38969 1130 34 56 90 56 89 27160 9399 124 172 296 172 90 34974 27893 194 234 428 233 91 26331 23273 203 259 462 258 92 43213 11843 75 119 194 118 93 66364 8028 131 153 284 15394 36251 3688 50 61 111 61 95 29279 2802 24 29 53 29 96 33063 5563 43 96 139 96 97 11314 2675 18 24 42 24 98 29900 3222 20 40 60 38 99 20050 2188 16 13 29 13 100 19638 13425 86 95 181 95
