Discuss the below:
Q: Using the data in the Excel file Census Education Data, construct a joint probability distribution for marital status and educational status.
a. What is the probability that a person is divorced and has a bachelor's degree?
b. What is the probability that someone known to have an advanced degree is married with spouse present?
c. What is the probability that an individual who is known to have never married has at least an associate's degree
| Census Education Data |
|
|
|
|
|
|
|
|
Population |
Not a High
School Grad |
High School
Graduate |
Some College
No Degree |
Associate's
Degree |
Bachelor's
Degree |
Advanced
Degree |
| Total Persons |
172,211,000 |
29,620,292 |
58,207,318 |
29,620,292 |
12,915,825 |
28,242,604 |
13,604,669 |
| Age |
|
|
|
|
|
|
|
| 25-34 |
39,354,000 |
4,683,126 |
12,553,926 |
7,792,092 |
3,423,798 |
8,382,402 |
2,439,948 |
| 35-44 |
44,462,000 |
5,335,440 |
15,117,080 |
8,136,546 |
4,134,966 |
8,136,546 |
3,556,960 |
| 45-54 |
34,058,000 |
4,427,540 |
10,932,618 |
6,062,324 |
2,894,930 |
5,960,150 |
3,848,554 |
| 55-64 |
22,255,000 |
4,562,275 |
8,301,115 |
3,338,250 |
1,157,260 |
2,893,150 |
2,047,460 |
| 65-74 |
17,873,000 |
5,165,297 |
6,505,772 |
2,466,474 |
768,539 |
1,787,300 |
1,179,618 |
| 75 and older |
14,209,000 |
5,399,420 |
4,717,388 |
1,847,170 |
454,688 |
1,150,929 |
625,196 |
| Gender |
|
|
|
|
|
|
|
| Male |
82,376,006 |
14,168,672 |
26,607,448 |
14,086,296 |
5,683,944 |
14,086,296 |
7,743,344 |
| Female |
89,835,000 |
15,361,785 |
31,621,920 |
15,541,455 |
7,186,800 |
14,193,930 |
5,929,110 |
| Race |
|
|
|
|
|
|
|
| White |
145,078,000 |
23,647,714 |
49,181,442 |
24,953,416 |
11,171,006 |
24,373,104 |
11,751,318 |
| Black |
19,376,000 |
4,650,240 |
6,975,360 |
3,700,816 |
1,201,312 |
1,995,728 |
852,544 |
| Other |
7,756,000 |
1,279,740 |
1,977,780 |
1,047,060 |
550,676 |
1,915,732 |
992,768 |
| Marital Status |
|
|
|
|
|
|
|
| Never Married |
25,752,000 |
4,120,320 |
7,777,104 |
4,789,872 |
1,828,392 |
5,124,648 |
2,137,416 |
| Married, spouse present |
107,008,000 |
15,516,160 |
36,382,720 |
18,084,352 |
8,346,624 |
19,154,432 |
9,523,712 |
| Married, spouse absent |
6,844,000 |
1,847,880 |
2,368,024 |
1,184,012 |
465,392 |
670,712 |
301,136 |
| Separated |
4,605,000 |
1,188,090 |
1,667,010 |
842,715 |
336,165 |
405,240 |
165,780 |
| Widowed |
13,577,000 |
5,145,683 |
4,670,488 |
1,765,010 |
556,657 |
977,544 |
475,195 |
| Divorced |
19,030,000 |
2,968,680 |
7,003,040 |
3,806,000 |
1,674,640 |
2,340,690 |
1,217,920 |
| Civilian Labor Force |
|
|
|
|
|
|
|
| Employed |
111,131,000 |
11,668,755 |
36,228,706 |
20,448,104 |
9,890,659 |
22,115,069 |
10,890,838 |
| Unemployed |
4,597,000 |
1,057,310 |
1,783,636 |
809,072 |
317,193 |
455,103 |
170,089 |
| Not in Labor Force |
55,822,000 |
16,858,244 |
20,040,098 |
8,205,834 |
2,623,634 |
5,582,200 |
2,511,990 |