Changing Future Value Growth Rates Create your own Excel spreadsheet using the following information 0 0 (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 1. You have been provided data on the comparative earnings the earnings of persons based on education. For purposes of this assignment a. 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) b. 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 an interest rate of 2.75% per year? Write this answer in your MS-Word report 2. For Problem #2 (Use the attached spreadsheet EARN-BY-EDUC) to create the data that enables you to solve the problem "HINT" you begin the problem by calculating the difference between the Weekly Wage of Man vs Woman. Then multiply the weekly difference by 52 to get the yearly difference. You should then calculate the growth of the investment each year to 2014. Please note that the accumulation of the investment from 1979 to 2014 will be larger than 1980 to 2014 and so on, until you get to the accumulation for 2014, which will actually not grow at all, and will equal just the difference for that year Styles Both sexes, less than high school Median weekly earnings in 2014 dollars of people 25 years a nd older, by educational attainment and gender, 1979-2014 Both Both Both Both sexes, sexes, sexes, sexes, less high some bachelo than school college r's high graduator degree high graduat Men, Men, some bachelo Women, Women, Men, Men, less high s than schooor degreehigh graduat associat or omen, Women, some bachelo or degree edeereel.hieher high college r's than school college r's than school school es -$462 associat or school es es associator e degreel hieher $936| S638 $ 1980 608 729 8 1979 . S857| 833 SI,046| 1,030 $766| $1,000| $1, 2041 9811,170 972 1,188 969 1,186 9551,172 967 1,219 $5621 s641| $802 732 8969 4 551633 795 1982 1983 1984 828 1,033 821 1,043 829 1,054 882 878 652 662 579 1985 567 700 8381,063 6608 855 992 ,239 424 63 666 S70 843 1.082 840 1,126 858 1,000 1,274 992 1,303 1987 844 988 554 708 827 1.125 638 840 967 1306 425 $73 692 933 1989 $48692 $ 638 830954 1,301 426 561 699 935 834 1,124 1990 1991 673 829 1.129