Question: You have been provided data on the comparative earnings (Weekly Wages) of women compared to men from 1979 through 2014. The purpose of the assignment

You have been provided data on the comparative earnings (Weekly Wages) of women compared to men from 1979 through 2014.

The purpose of the assignment is to compare the earnings of women to men over the time period given and to compare the earnings of persons based on education. For purposes of this assignment:

  1. Calculate how many cents per dollar a woman with a Baccalaureate degree earns compared to:
    1. A man with a high school diploma for each of the years
    2. A man with some college education or Associate Degree
    3. A man with a Baccalaureate degree
    4. For (a, b and c) above, plot a chart of your results. Cut and paste your chart into MS-Word and describe your observations? What changes did you observe over the years of your calculations? Give your chart a proper title and your variables should also be properly labeled.
  2. Calculate the difference between the weekly wages of a woman with a baccalaureate degree and man with a baccalaureate degree for each of the years (1979 - 2014)
  3. If the man were to save the difference in the weekly wages for all the years (1979 - 2014), how much money will the man have in the bank by 2014, assuming that the money earned no interest? Write this answer in your MS-Word report.

ggggggggg

You have been provided data on the comparative
Median weekly earnings in 2014 dollars of people 25 years and older, by educational attainment and gender, I Both Both Men Women Women Both Both Men, sexes, sexes, Men, Men, some Women | Women sexes, sexes, bachelo , Some some bachelo less high college , less high college bachelo less high r's Year college I'S than school than school or r's than school degree 01 degree high graduat associat high graduat associatedegree high graduat or associat or school es school es or school es higher higher degree degree higher 1979 $638 $757 $857 $1,046 $766 $936 $1,000 $1,204 $462 $562 $641 $802 1980 508 729 833 1,030 732 896 981 1,170 449 551 633 195 1981 600 715 810 1.018 715 890 972 1,188 438 542 538 795 1982 585 712 328 1,033 691 382 969 1,186 434 557 546 816 1983 5791 704 821 1.043 681 878 955 1,172 441 557 652 835 1984 570 701 829 1,054 668 866 967 1,219 434 562 662 846 1985 567 700 838 1,063 660 855 992 1,239 424 563 666 870 1986 573 709 843 1,082 662 858 1,000 1,274 4291 571 580 899 1987 567 711 840 1,126 647 844 992 1,303 427 575 693 930 1988 554 708 827 1,125 538 840 967 1,306 425 573 692 933 1989 548 692 834 1,124 638 830 954 1,301 426 561 699 935 1990 533 678 837 1,121 613 807 953 1,302 422 554 694 940 1991 520 673 829 1,129 592 797 954 1,295 424 556 693 953 1992 514 666 800 1,150 580 792 917 1,307 423 557 573 982 1993 506 669 797 1,153 574 785 923 1,300 424 560 681 985 1994 485 665 788 1,158 540 784 927 1,305 406 555 668 1,002 1995 477 667 784 1,153 535 782 920 1,304 404 549 659 994 1996 477 666 779 1,140 537 776 908 1,314 403 549 665 988 1997 472 578 787 1,146 537 787 13 1,318 404 556 575 988 1998 489 695 810 1,192 556 811 933 1,363 411 575 691 1,026 1999 491 696 824 1,222 561 824 945 1,388 412 575 693 1,051 2000 498 695 820 1,226 558 813 950 1.403 418 578 595 1,040 2001 511 595 825 1,231 560 814 967 1,426 422 592 695 1,051 2002 511 704 828 1.238 554 812 962 1,434 428 603 714 1,064 2003 510 713 822 1,241 552 808 952 1,456 423 610 721 ,071 2004 503 719 828 1,236 559 808 54 1,432 419 612 723 1,078 2005 496 707 812 1,228 552 790 928 1,415 413 598 712 1,070 2006 492 698 812 1,219 550 796 934 1,414 420 587 707 1,062 2007 489 689 804 1,224 549 787 925 1,419 421 584 695 1,064 2008 498 680 794 1,227 547 780 13 1,414 416 572 691 1.051 2009 501 591 801 1,255 552 790 922 1,465 422 598 695 1,071 2010 482 680 797 1,242 528 771 91 1,444 421 590 693 1,071 2011 475 672 778 1,211 514 758 884 1,402 416 583 579 1,051 2012 486 672 772 1,201 524 758 884 1,413 398 578 679 1,032 2013 480 662 760 1,213 508 744 872 1,418 407 582 668 1.060 2014 488 668 761 1,193 517 751 872 1,385 409 578 661 1,049

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!