5.12. Row 26 of the Excel file Census Education Data (worksheet 5.12) gives the number of employed persons in the civilian labor force having a specific educational level.

a.Find the probability that an employed person has attained each of the educational levels listed in the data.

b.Suppose that A is the event "An employed per-son has some type of college degree" and B is the event "An employed person has at least some college." Find the probabilities of these events. Are they mutually exclusive? Why or why not?

c.Find the probability P(A or B).

PROBABILITIES Census Education Data High High Not a High School Some College Associate's Bachelor's Advanced Not a High School Some College Associate's Bachelor's Advanced School Grad Graduate No Degree Degree Degree Degree TOTAL School Grad Graduate No Degree Degree Degree Degree 3 Total Persons 29,620,292 58,207,318 29,620,292 12,915,825 28,242,604 13,604,669 172,211,000 a) 4 Age 25-34 4,683, 126 12,553,926 7,792,092 3,423,798 8,382,402 2,439,948 b) A: has some type of college degree 35-44 5.335.440 15, 117,080 8, 136,546 4,134,966 8, 136,546 3,556,960 B: has at least some college 45-54 4,427,540 10,932,618 6,062,324 2,894,930 5,960, 150 3,848,554 55-64 4,562,275 8,301, 115 3,338,250 1, 157,260 2,893, 150 2,047,460 P(A) = 65-74 5,165,297 6,505,772 2,466,474 768,539 1,787,300 1, 179,618 75 and older 5,399,420 4,717,388 1,847, 170 454,688 1, 150,929 625, 196 P(B) = 10 11 Gender 12 Male 14, 168,672 26,607,448 14,086,296 5,683,944 14,086,296 7,743,344 13 Female 15,361,785 31,621,920 15,541,455 7, 186,800 4, 193,930 5,929, 110 14 Race c) P(A or B) = 15 White 23,647,714 49, 181,442 24,953,416 11, 171,006 24,373, 104 11,751,318 16 Black 4,650,240 6,975,360 3,700,816 1,201,312 1,995,728 852.544 17 Other 1,279,740 1,977,78 1,047,060 550,676 1,915,732 992,768 18 Marital Status 19 Never Married 4, 120,320 7,777, 104 4,789,872 1,828,392 5, 124,648 2, 137,416 0 Married, spouse present 15,516, 160 36,382,720 18,084,352 8,346,624 19, 154,432 9,523,712 21 Married, spouse absent 1,847,880 2,368,024 1, 184,012 465,392 670,712 301, 136 22 Separated 1, 188,090 1,667,010 842,715 336, 165 405,240 65,780 23 Widowed 5, 145,683 4,670,488 1,765,010 556,657 977,544 475, 195 24 Divorced 2,968,680 7,003,040 3,806,000 1,674,640 2,340,690 1,217,920 Civilian Labor Force 26 Employed 11,668,755 36,228,706 20,448, 104 0,659 22,115,069 10,890,838 111,242, 131 Unemployed 1,057,310 1,783,63 809,072 317, 193 455, 103 170,089 Not in Labor Force 16,858,244 20,040,098 8,205,834 2,623,634 5,582,200 2,511,990 Total Civilian Labor Force 171,656,534