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:
2. A man with a high school diploma for each of the years
3. A man with some college education or Associate Degree
4. A man with a Baccalaureate degree
5. 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 labelled.
6. 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)
7. 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? answer in your MS-Word report.

AutoSave O OFF ~ H E 6 + 0 = EARNS_BY_EDUC1 Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments M5 X fx 641 B C F G H M N P Q R S T U V W X Y Z AA Both Both Both Both Men, Men, Women, | Women Women sexes, sexes, sexes, sexes, Men, less Men, high Women, some high some high some than Year less than school college or bachelor less than bachelor' bachelor' ans 1 ans 2 ans 3 school college or high s degree high school college or graduate associate s degree high s degree graduate associate school graduate associate or higher | school or higher school degree degree degree or higher 1979 $638 $757 $857 $1,046 $766 $936 $1,000 $1,204 $462 $562 $641 6802 1980 608 729 833 1,030 732 896 981 1,170 449 633 795 1981 600 715 1,018 890 972 1,188 438 795 1982 585 712 1,033 882 969 1,186 434 1983 579 704 1.043 955 1,172 1984 570 701 967 1,219 1985 567 700 1986 573 1987 567 1988 1989 1990 1991 1992 1993 1994 485 1995 1996 477 1997 1998 489 1999 491 2000 498 2001 511 2002 511 2003 510 2004 503 2005 496 2006 26+ 2007 489 2008 498 2009 501 2010 482 2011 475 2012 486 2013 480 2014 488 Sheet1 Sheet2 Sheet3 + Ready 100%