Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I need to know the steps to solve the below problem using excel. Using the data in the Excel file Census Education Data , construct

image text in transcribed

I need to know the steps to solve the below problem using excel.

Using the data in the Excel file Census Education Data, construct a joint probability distribution for marital status and educational status.

image text in transcribed
Al * x v fx Census Education Data A B C D E F G H Census Education Data Not a High High Some Associate' Bachelor' School School College S Advanced No 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 ######!# 4 Age 25-34 4,683,126 12,553,926 7,792,092 3,423,798 8,382,402 2,439,948 35-44 5,335,440 15,117,080 8, 136,546 4,134,966 8,136,546 3,556,960 45-54 4,427,540 10,932,618 6,062,324 2,894,930 5,960, 150 3,848,554 (D 00 ) 55-64 4,562,275 8,301, 115 3,338,250 1,157,260 2,893, 150 2,047,460 65-74 5,165,297 6,505,772 2,466,474 768,539 1,787,300 1, 179,618 10 75 and older 5,399,420 4,717,388 1,847, 170 454,688 1,150,929 625, 196 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 14, 193,930 5,929, 110 14 Race 15 White 23,647,714 49, 181,442 24,953,416 11,171,006 24,373,104 ######## 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,780 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 20 irried, spouse present 15,516,160 36,382,720 18,084,352 8,346,624 19, 154,432 9,523,712 21 larried, 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 165,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 25 Civilian Labor Force 26 Employed 11,668,755 36,228,706 20,448, 104 9,890,659 22,115,069 ####!### 27 Unemployed 1,057,310 1,783,636 809,072 317,193 455, 103 170,089 28 Not in Labor Force 16,858,244 20,040,098 8,205,834 2,623,634 5,582,200 2,511,990 29 30 31

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Graphical, Numerical, Algebraic

Authors: Ross L. Finney, Franklin D. Demana, Bert K. Waits, Daniel Kennedy

3rd Edition

0132014084, 978-0132014083

Students also viewed these Mathematics questions

Question

Present main arguments for and against the computer metaphor.

Answered: 1 week ago