Solve the below problem:
Q. Row 26 of the excel file gives the number of employed persons having a specific education level.
a. Find he probability that an employed person has attained each of the educational levels listed in the data.
b. suppose that A is the event "has at least an Associates Degree" and B is he event " is at least a high school graduate." Find the probabilities of these events. Are they mutually exclusive? Why or why not? Find the probability P(A or B).
c. P(Unemployed and Advanced Degree)
d. P(Unemployed |Advanced Degree)
e. P(Not a High School Grad | Unemployed)
| Census Education Data |
|
|
|
|
|
|
Not a High
School Grad |
High School
Graduate |
Some College
No Degree |
Associate's
Degree |
Bachelor's
Degree |
Advanced
Degree |
| Total Persons |
######## |
######## |
29,620,292 |
######## |
####### |
####### |
| Age |
|
|
|
|
|
|
| 25-34 |
4,683,126 |
######## |
7,792,092 |
3,423,798 |
####### |
####### |
| 35-44 |
5,335,440 |
######## |
8,136,546 |
4,134,966 |
####### |
####### |
| 45-54 |
4,427,540 |
######## |
6,062,324 |
2,894,930 |
####### |
####### |
| 55-64 |
4,562,275 |
8,301,115 |
3,338,250 |
1,157,260 |
####### |
####### |
| 65-74 |
5,165,297 |
6,505,772 |
2,466,474 |
768,539 |
####### |
####### |
| 75 and older |
5,399,420 |
4,717,388 |
1,847,170 |
454,688 |
####### |
625,196 |
| Gender |
|
|
|
|
|
|
| Male |
######## |
######## |
14,086,296 |
5,683,944 |
####### |
####### |
| Female |
######## |
######## |
15,541,455 |
7,186,800 |
####### |
####### |
| Race |
|
|
|
|
|
|
| White |
######## |
######## |
24,953,416 |
######## |
####### |
####### |
| Black |
4,650,240 |
6,975,360 |
3,700,816 |
1,201,312 |
####### |
852,544 |
| Other |
1,279,740 |
1,977,780 |
1,047,060 |
550,676 |
####### |
992,768 |
| Marital Status |
|
|
|
|
|
|
| Never Married |
4,120,320 |
7,777,104 |
4,789,872 |
1,828,392 |
####### |
####### |
| Married, spouse present |
######## |
######## |
18,084,352 |
8,346,624 |
####### |
####### |
| Married, spouse absent |
1,847,880 |
2,368,024 |
1,184,012 |
465,392 |
670,712 |
301,136 |
| Separated |
1,188,090 |
1,667,010 |
842,715 |
336,165 |
405,240 |
165,780 |
| Widowed |
5,145,683 |
4,670,488 |
1,765,010 |
556,657 |
977,544 |
475,195 |
| Divorced |
2,968,680 |
7,003,040 |
3,806,000 |
1,674,640 |
####### |
####### |
| Civilian Labor Force |
|
|
|
|
|
| Employed |
######## |
######## |
20,448,104 |
9,890,659 |
####### |
####### |
| Unemployed |
1,057,310 |
1,783,636 |
809,072 |
317,193 |
455,103 |
170,089 |
| Not in Labor Force |
######## |
######## |
8,205,834 |
2,623,634 |
####### |
####### |