BA 3010 Ch 4
Md
copy_of_chapter_4_homework2.xlsxQ1
| Gender | Job | Status | Children | |
| a) | Male | |||
| Female | ||||
| b) | ||||
| c) | ||||
| d) | ||||
| e) | ||||
| f) |
Q2
| Value of | Value of | Value of | ||
| Price of Oil | Probability | Location 1 | Location 2 | Location 3 |
| more than $150 per bbl. | 10% | 28.7 | 45.2 | 14.5 |
| $120 to $150 per bbl. | 25% | 15.3 | 30.6 | 12.6 |
| $80 to $120 per bbl. | 50% | 12.2 | 1.8 | 8.4 |
| $50 to $80 per bbl. | 10% | 8.4 | -10.2 | 6.3 |
| less than $50 per bbl. | 5% | 1.2 | -27.0 | 5.7 |
Q3
| Hours spent at the local tavern each week by marketing and operations management majors | |||
| Hours per week | Probability | Average GPA, marketing majors | Average GPA, ops. mgmt. majors |
| 0 | 0.19 | 3.43 | 3.23 |
| 1 to 3 | 0.12 | 3.28 | 3.17 |
| 4 to 6 | 0.19 | 3.14 | 3.11 |
| 7 to 9 | 0.23 | 3.00 | 3.05 |
| 10 to 12 | 0.18 | 2.81 | 2.98 |
| 13 to 15 | 0.06 | 2.65 | 2.84 |
| 15 or more | 0.03 | 2.49 | 2.69 |
Q4
| Survey of Local Workers with regard to Beer-Drinking Preferences | ||
| Worker | Type Christopher J. Zappe: W = white-collar worker B = blue-collar worker | Preference Christopher J. Zappe: L = prefers to drink light beer R = prefers to drink regular beer N = prefers not to drink beer |
| 1 | B | R |
| 2 | W | N |
| 3 | W | L |
| 4 | B | R |
| 5 | B | R |
| 6 | B | R |
| 7 | B | L |
| 8 | B | L |
| 9 | B | R |
| 10 | B | L |
| 11 | B | L |
| 12 | B | L |
| 13 | W | L |
| 14 | B | L |
| 15 | W | R |
| 16 | B | R |
| 17 | B | L |
| 18 | W | R |
| 19 | B | R |
| 20 | W | L |
| 21 | B | R |
| 22 | W | R |
| 23 | B | L |
| 24 | B | L |
| 25 | B | R |
| 26 | B | R |
| 27 | B | N |
| 28 | W | L |
| 29 | B | R |
| 30 | W | L |
| 31 | W | R |
| 32 | B | R |
| 33 | B | N |
| 34 | B | L |
| 35 | B | L |
| 36 | W | L |
| 37 | B | R |
| 38 | W | R |
| 39 | B | R |
| 40 | B | L |
| 41 | B | R |
| 42 | B | L |
| 43 | W | L |
| 44 | B | L |
| 45 | W | N |
| 46 | W | N |
| 47 | W | L |
| 48 | B | R |
| 49 | B | R |
| 50 | B | L |
| 51 | W | L |
| 52 | B | N |
| 53 | B | R |
| 54 | W | L |
| 55 | B | R |
| 56 | W | R |
| 57 | W | R |
| 58 | B | R |
| 59 | W | L |
| 60 | B | L |
| 61 | W | R |
| 62 | B | R |
| 63 | B | L |
| 64 | W | R |
| 65 | B | R |
| 66 | B | R |
| 67 | W | R |
| 68 | W | L |
| 69 | B | R |
| 70 | W | R |
| 71 | B | L |
| 72 | B | L |
| 73 | W | L |
| 74 | B | R |
| 75 | W | R |
| 76 | B | L |
| 77 | W | L |
| 78 | B | R |
| 79 | B | L |
| 80 | W | L |
| 81 | B | R |
| 82 | B | L |
| 83 | B | L |
| 84 | B | L |
| 85 | B | R |
| 86 | W | R |
| 87 | W | L |
| 88 | W | L |
| 89 | B | L |
| 90 | B | L |
| 91 | W | L |
| 92 | B | R |
| 93 | W | R |
| 94 | B | L |
| 95 | B | R |
| 96 | W | N |
| 97 | W | L |
| 98 | B | L |
| 99 | W | L |
| 100 | B | R |
| 101 | W | R |
| 102 | B | N |
| 103 | B | L |
| 104 | B | R |
| 105 | B | L |
| 106 | W | L |
| 107 | B | R |
| 108 | B | R |
| 109 | B | L |
| 110 | B | L |
| 111 | B | R |
| 112 | B | L |
| 113 | W | R |
| 114 | W | R |
| 115 | B | R |
| 116 | B | L |
| 117 | W | L |
| 118 | B | R |
| 119 | B | L |
| 120 | B | L |
| 121 | B | L |
| 122 | W | R |
| 123 | W | R |
| 124 | B | R |
| 125 | W | L |
| 126 | B | R |
| 127 | B | L |
| 128 | B | L |
| 129 | W | R |
| 130 | W | L |
| 131 | W | L |
| 132 | B | L |
| 133 | B | L |
| 134 | W | L |
| 135 | B | R |
| 136 | B | L |
| 137 | B | R |
| 138 | B | L |
| 139 | B | L |
| 140 | W | L |
| 141 | W | L |
| 142 | B | L |
| 143 | B | L |
| 144 | B | R |
| 145 | W | R |
| 146 | W | L |
| 147 | B | L |
| 148 | B | R |
| 149 | B | N |
| 150 | B | L |
| 151 | B | N |
| 152 | B | L |
| 153 | W | L |
| 154 | B | R |
| 155 | W | R |
| 156 | W | N |
| 157 | W | L |
| 158 | B | L |
| 159 | B | L |
| 160 | B | R |
| 161 | B | L |
| 162 | B | L |
| 163 | B | R |
| 164 | B | R |
| 165 | W | R |
| 166 | B | R |
| 167 | W | L |
| 168 | B | R |
| 169 | B | R |
| 170 | B | L |
| 171 | W | L |
| 172 | B | L |
| 173 | B | L |
| 174 | W | L |
| 175 | W | R |
| 176 | B | L |
| 177 | B | N |
| 178 | W | L |
| 179 | B | L |
| 180 | W | L |
| 181 | W | N |
| 182 | B | L |
| 183 | W | R |
| 184 | B | L |
| 185 | W | R |
| 186 | B | L |
| 187 | B | R |
| 188 | B | R |
| 189 | B | R |
| 190 | W | L |
| 191 | W | R |
| 192 | W | L |
| 193 | W | L |
| 194 | B | R |
| 195 | B | L |
| 196 | B | R |
| 197 | W | R |
| 198 | B | R |
| 199 | B | L |
| 200 | B | L |
| 201 | W | R |
| 202 | B | N |
| 203 | W | R |
| 204 | B | L |
| 205 | B | L |
| 206 | B | N |
| 207 | W | R |
| 208 | B | L |
| 209 | B | R |
| 210 | B | L |
| 211 | B | R |
| 212 | B | L |
| 213 | B | R |
| 214 | W | R |
| 215 | W | R |
| 216 | W | R |
| 217 | W | L |
| 218 | W | R |
| 219 | B | R |
| 220 | W | R |
| 221 | B | L |
| 222 | W | L |
| 223 | W | L |
| 224 | B | R |
| 225 | W | N |
| 226 | B | L |
| 227 | W | R |
| 228 | W | L |
| 229 | B | L |
| 230 | B | R |
| 231 | B | N |
| 232 | W | R |
| 233 | W | L |
| 234 | B | R |
| 235 | W | L |
| 236 | B | L |
| 237 | B | L |
| 238 | B | R |
| 239 | B | R |
| 240 | W | R |
| 241 | W | R |
| 242 | W | R |
| 243 | W | L |
| 244 | B | L |
| 245 | W | R |
| 246 | W | L |
| 247 | B | R |
| 248 | B | R |
| 249 | B | L |
| 250 | W | R |
| 251 | W | L |
| 252 | B | N |
| 253 | B | R |
| 254 | W | L |
| 255 | B | L |
| 256 | B | R |
| 257 | B | L |
| 258 | W | L |
| 259 | B | R |
| 260 | B | R |
| 261 | B | L |
| 262 | B | L |
| 263 | B | R |
| 264 | B | R |
| 265 | W | N |
| 266 | W | R |
| 267 | B | L |
| 268 | B | L |
| 269 | B | R |
| 270 | B | L |
| 271 | B | L |
| 272 | B | L |
| 273 | B | R |
| 274 | B | R |
| 275 | B | R |
| 276 | B | R |
| 277 | W | R |
| 278 | B | N |
| 279 | W | L |
| 280 | B | N |
| 281 | B | L |
| 282 | W | R |
| 283 | B | R |
| 284 | B | R |
| 285 | B | R |
| 286 | W | L |
| 287 | B | L |
| 288 | W | L |
| 289 | W | R |
| 290 | W | L |
| 291 | W | L |
| 292 | B | R |
| 293 | B | N |
| 294 | B | R |
| 295 | B | R |
| 296 | B | R |
| 297 | B | L |
| 298 | B | R |
| 299 | B | R |
| 300 | W | N |
| 301 | B | R |
| 302 | W | L |
| 303 | B | R |
| 304 | B | L |
| 305 | B | R |
| 306 | B | R |
| 307 | B | R |
| 308 | W | N |
| 309 | B | N |
| 310 | W | L |
| 311 | B | R |
| 312 | B | R |
| 313 | B | L |
| 314 | B | R |
| 315 | B | L |
| 316 | B | R |
| 317 | B | R |
| 318 | W | L |
| 319 | W | L |
| 320 | B | R |
| 321 | B | R |
| 322 | B | R |
| 323 | B | R |
| 324 | B | R |
| 325 | B | L |
| 326 | B | R |
| 327 | W | N |
| 328 | B | L |
| 329 | W | L |
| 330 | B | R |
| 331 | W | L |
| 332 | W | L |
| 333 | B | L |
| 334 | B | L |
| 335 | B | R |
| 336 | W | L |
| 337 | W | L |
| 338 | B | R |
| 339 | B | L |
| 340 | B | R |
| 341 | W | L |
| 342 | B | R |
| 343 | B | R |
| 344 | W | R |
| 345 | W | R |
| 346 | B | R |
| 347 | W | R |
| 348 | W | R |
| 349 | W | L |
| 350 | B | L |
| 351 | W | L |
| 352 | B | R |
| 353 | W | L |
| 354 | B | L |
| 355 | W | R |
| 356 | W | R |
| 357 | B | L |
| 358 | B | R |
| 359 | W | R |
| 360 | B | R |
| 361 | W | L |
| 362 | B | L |
| 363 | B | L |
| 364 | B | R |
| 365 | W | L |
| 366 | B | L |
| 367 | B | R |
| 368 | W | R |
| 369 | B | R |
| 370 | B | L |
| 371 | B | L |
| 372 | W | R |
| 373 | W | L |
| 374 | W | R |
| 375 | B | L |
| 376 | W | L |
| 377 | B | L |
| 378 | B | L |
| 379 | W | L |
| 380 | B | R |
| 381 | B | N |
| 382 | W | N |
| 383 | B | N |
| 384 | B | L |
| 385 | W | L |
| 386 | W | R |
| 387 | B | R |
| 388 | W | L |
| 389 | B | L |
| 390 | B | L |
| 391 | W | L |
| 392 | B | R |
| 393 | W | L |
| 394 | W | L |
| 395 | B | L |
| 396 | W | R |
| 397 | W | L |
| 398 | B | R |
| 399 | B | R |
| 400 | B | R |
Q5
| Table1: Marginal probability distributions of school and gender | ||||
| BPA | 25% | |||
| HSS | 40% | |||
| Education | 15% | |||
| NSM | 20% | |||
| Male | 35% | |||
| Female | 65% | |||
| Table 2: Joint probability distribution of school and gender | ||||
| BPA | HSS | Educ. | NSM | |
| Male | 10% | 10% | 4% | |
| Female | 15% | 30% | 9% | |
| Table 3: Conditional probability distribution of school given gender | ||||
| BPA | HSS | Educ. | NSM | |
| Male | 28.57% | 11.43% | 31.43% | |
| Female | 23.08% | 16.92% | 13.85% | |
| Table 4: Conditional probability distribution of gender given school | ||||
| BPA | HSS | Educ. | NSM | |
| Male | 40.00% | 25.00% | 26.67% | |
| Female | 60.00% | 75.00% | 45.00% |
Q6
| Fatal occupational injuries by event or exposure, 2012 | ||||||
| men | women | |||||
| Homicide | 364 | 99 | 463 | |||
| Roadway | 972 | 72 | 1044 | |||
| Falls, slips, trip | 610 | 58 | 668 | |||
| Struck by object or equip | 491 | 18 | 509 | |||
| Other | 1608 | 91 | 1699 | |||
| 4045 | 338 | 4383 | ||||
| men | women | |||||
| Homicide | 8.3% | 2.3% | ||||
| Roadway | 22.2% | 1.6% | ||||
| Falls, slips, trip | 13.9% | 1.3% | ||||
| Struck by object or equip | 11.2% | 0.4% | ||||
| Other | 36.7% | 2.1% | ||||
| 100.0% | ||||||
| men | women | |||||
| Homicide | 9.0% | 29.3% | ||||
| Roadway | 24.0% | 21.3% | ||||
| Falls, slips, trip | 15.1% | 17.2% | ||||
| Struck by object or equip | 12.1% | 5.3% | ||||
| Other | 39.8% | 26.9% | ||||
| 100.0% | 100.0% | |||||
| men | women | |||||
| Homicide | 78.6% | 21.4% | 100.0% | |||
| Roadway | 93.1% | 6.9% | 100.0% | |||
| Falls, slips, trip | 91.3% | 8.7% | 100.0% | |||
| Struck by object or equip | 96.5% | 3.5% | 100.0% | |||
| Other | 94.6% | 5.4% | 100.0% |
_PalUtilTempWorksheet
| 1 |
_STDS_DGD6678DE
| Name | Data Set #1 | StatTools Version that generated sheet, Major | 7 | StatTools Version that generated sheet, Minor | 0 | StatTools Version that generated sheet, Revision | 0 | Min. StatTools Version to Read Sheet, Major (note ST versions before 1.1.1 don't perform forward compatibility check) | 1 | Min. StatTools Version to Read Sheet, Minor | 0 | Min. StatTools Version to Read Sheet, Revision | 0 | Min. StatTools version to not put up warning about extra info, Major | 1 | Min. StatTools version to not put up warning about extra info, Minor | 0 | Min. StatTools version to not put up warning about extra info, Revision | 0 |
| GUID | DGD6678DE | ||||||||||||||||||
| Format Range | TRUE | ||||||||||||||||||
| Variable Layout | Columns | ||||||||||||||||||
| Variable Names In Cells | TRUE | ||||||||||||||||||
| Variable Names In 2nd Cells | FALSE | ||||||||||||||||||
| Data Set Ranges | ERROR:#VALUE! | ||||||||||||||||||
| Data Sheet Format | 2 | ||||||||||||||||||
| Formula Eval Cell | 1 | ||||||||||||||||||
| Num Stored Vars | 5 | ||||||||||||||||||
| 1 : Info | VG1AC7CE791C3606C2 | var1 | ST_DataSet1 | TRUE | 0 | 4 | 1 | ||||||||||||
| 1 : Ranges | ERROR:#VALUE! | ||||||||||||||||||
| 1 : MultiRefs | |||||||||||||||||||
| 2 : Info | VG228368052189BA30 | var2 | ST_Gender | TRUE | 0 | 4 | 0 | ||||||||||||
| 2 : Ranges | ERROR:#VALUE! | ||||||||||||||||||
| 2 : MultiRefs | |||||||||||||||||||
| 3 : Info | VG19F18CB22D4BACEB | var3 | ST_Job | TRUE | 0 | 4 | 0 | ||||||||||||
| 3 : Ranges | ERROR:#VALUE! | ||||||||||||||||||
| 3 : MultiRefs | |||||||||||||||||||
| 4 : Info | VGB047C9D10021150 | var4 | ST_Status | TRUE | 0 | 4 | 0 | ||||||||||||
| 4 : Ranges | ERROR:#VALUE! | ||||||||||||||||||
| 4 : MultiRefs | |||||||||||||||||||
| 5 : Info | VG13D9503121821274 | var5 | ST_Children | TRUE | 0 | 4 | 0 | ||||||||||||
| 5 : Ranges | ERROR:#VALUE! | ||||||||||||||||||
| 5 : MultiRefs |
