Creating Excel Spreadsheet

已完成 已发布的 Feb 2, 2015 货到付款
已完成 货到付款

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 ([url removed, login to view]):

(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.

数据输入 数据处理 Excel Word

项目ID: #7076644

关于项目

5个方案 远程项目 活跃的Feb 2, 2015

授予:

tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. (tasleemnaz 更多

$30 USD 在0天内
(24条评论)
3.8

有5名威客正在参与此工作的竞标,均价$31/小时

pablotorres

A proposal has not yet been provided

$50USD 在1天里
(8条评论)
3.6
ambarsoftronics

I have read the job description very carefully. And I would love to do the job. I have done similar kind of project before for a UK client and a US client, In fact my last project which I completed yesterday was also a 更多

$20USD 在1天里
(2条评论)
1.5
asayem

A proposal has not yet been provided

$30USD 在1天里
(4条评论)
0.7
melidha93

Proposal belum diberikan

$25 USD 在3天内
(0条评论)
0.0