Creating Excel Spreadsheet

I Need someone to work out the these problems so I can see how my students would like it. Please type a 2 sentence review of it also. Directions below. Need this done in 12 hours. 1. Using the data I’ve provided ([login to view URL]): (a) Plot mean income by age for each education level on the same graph (use connected scatter plots or line plots for all graphs). (b) Now plot median income by age for each education level. (c) At what age is the difference in mean earnings between those with a HS diploma and those with a BA or more the largest? What is the difference (value) at that age? Show (plot) these differences by age as well. (d) Now plot the difference (BA or more - HS graduates) in both mean and median earnings at each age (for ages 19-65) on the same graph. Is the benefit of college higher when we compare means or medians? Why? (e) If we sum up the difference in mean earnings between College graduates and HS graduates over ages 19-65, how much more will college graduates earn in total? (f) What is the present value of this difference in stream of payments at a discount rate of 4%? [Note: You should solve this in excel, not by hand. You only have to put the value for the answer.] (g) T/F/U: Taking into account that this data is a cross-section (i.e. a snapshot of Americans taken today) as opposed to a panel (which follows people over time), do you think question (f) above a good way to project how much more a college graduate who is 19 today will earn over her lifetime than a HS graduate who is 19 today? Say why or why not. Q1 Notes: Include all figures in your answer-set. Make sure all graphs have titles (question number and a description of what I see this is good practice). Make sure all axes are labeled and readable as is the legend. You can use whatever stat program you want to do this (Excel, R, Stata, SAS, SPSS, Matlab,). T/F/U is true, false or uncertain. You have to provide a justification for your answer. 2. Let’s say Sam just finished high school and is deciding whether to enroll in a two year nursing program at the local community college. The cost of the program is $10,000 per year for tuition and supplies. Because the program is so intensive, Sam cannot work if he enrolls in the program until after he graduates. Sam believes if he doesn’t enroll in the program, he’ll earn $60,000 per year. He believes that if he completes the program, he’ll earn $110,000 per year once he starts working. Because of visa issues, Sam is only allowed to stay in the country for 5 years (he will not work when he returns to his home country). Show your work. (a) Set up what Sam’s net present value calculation should include. (b) At an interest rate of 3% (r=0.03), would you suggest that Sam enrolls in the program? (c) At an interest rate of 2%, would you suggest that Sam enrolls in the program? (d) What if Sam’s visa allowed him to stay for an extra year at the original 3% interest rate? Do not bid on this project unless you can complete this within the 12 hour time limit.