Question

In: Economics

(Use Excel) For many the promise of a college degree has turned to disappointment as they...

(Use Excel) For many the promise of a college degree has turned to disappointment as they find themselves struggling to find a job (Financial Times, June 1, 2012). It is especially disturbing since recent evidence suggests that graduating at bad economic times can impact the person’s earning power for a long time. An associate dean at a prestigious college wants to determine if the starting salary of his college graduates has declined from 2008 to 2010. He expects the variance of the salaries to be different between these two years. The accompanying table shows a portion of the salary data for 40 college graduates. Use Table 2. Salary 2008 ($) Salary 2010 ($) Salary 2008 ($) Salary 2010 ($) 34,000 38,000 44,000 43,000 54,000 62,000 41,000 30,000 50,000 32,000 34,000 43,000 53,000 40,000 50,000 61,000 50,000 66,000 56,000 72,000 45,000 33,000 42,000 48,000 63,000 43,000 26,000 60,000 46,000 66,000 56,000 43,000 54,000 66,000 54,000 69,000 50,000 41,000 41,000 48,000 67,000 70,000 69,000 39,000 53,000 27,000 38,000 52,000 37,000 31,000 57,000 28,000 49,000 56,000 54,000 51,000 38,000 58,000 56,000 60,000 40,000 11,000 65,000 18,000 56,000 34,000 49,000 42,000 37,000 64,000 60,000 44,000 50,000 40,000 48,000 48,000 53,000 26,000 50,000 57,000 PictureClick here for the Excel Data File Let Sample 1 be the sample of the starting salary of college graduates in 2008 and Sample 2 be the sample of the starting salary of college graduates in 2010. a-1. Specify the competing hypotheses that determine whether the starting salary of college graduates has declined from 2008 to 2010. H0: ?1 ? ?2 = 0; HA: ?1 ? ?2 ? 0 H0: ?1 ? ?2 ? 0; HA: ?1 ? ?2 < 0 H0: ?1 ? ?2 ? 0; HA: ?1 ? ?2 > 0 a-2. Using the p-value approach, have salaries gone down from 2008 to 2010 at the 5% significance level? Reject H0; there is evidence that the starting salary of college graduates has declined from 2008 to 2010. Reject H0; there is no evidence that the starting salary of college graduates has declined from 2008 to 2010. Do not reject H0; there is evidence that the starting salary of college graduates has declined from 2008 to 2010. Do not reject H0; there is no evidence that the starting salary of college graduates has declined from 2008 to 2010.

Solutions

Expert Solution


Related Solutions

on the excel Annual Income No H.S Degree H.S Degree Some College Total Low 65 45...
on the excel Annual Income No H.S Degree H.S Degree Some College Total Low 65 45 35 145 Medium 43 66 52 161 High 34 35 52 121 Total 142 146 139 427 1) state the null hypothesis for this study. 2) check whether all chi-square assumptions are met 3) calculate chi-square test statistics for the hypothetical data shown above. (1) calculate total column percentages. (2) calculate expected frequencies for all cells. (3) calculate chi-square for each cell using formula...
Use MS Excel and turn in your XLS document. This work is to be turned in...
Use MS Excel and turn in your XLS document. This work is to be turned in individually. Compute the present value of a project that has a lifetime of 7 years. The total investment is 1.5 million dollars. The depreciation method is MACRS-GDS classified as 5 year property. The tax rate is 21%. 43% of the investment is financed with a loan at 7% per year, payable in 5 yearly payments. The positive cash flows in each one of the...
A researcher claims that 86% of college graduates say their college degree has been a good...
A researcher claims that 86% of college graduates say their college degree has been a good investment. In a random sample of 1000 graduates, 845 say their college degree has been a good investment. At a = 0.10, is there enough evidence to reject the researcher’s claim? (Adapted from Pew Research Center)
Your second cousin has just turned 30 years old, has just received her master’s degree in...
Your second cousin has just turned 30 years old, has just received her master’s degree in neurofinance and has accepted her first job. Now she must decide how much money to put into her retirement plan. The plan works as follows: Every dollar in the plan is expected to earn 8% per annum. She cannot make withdrawals until she retires on her sixty-fifth birthday. After that point, she can make withdrawals as she sees fit. She plans on living to...
The value of a college degree is greater than it has been in nearly half a...
The value of a college degree is greater than it has been in nearly half a century, a least when compared to the prospect of not getting a degree (www.pewresearch.org, January 28, 2014). Due to this fact, more and more people are obtaining college degrees, despite the soaring costs. The accompanying table shows the proportions of college degrees awarded in 2010 by colleges and universities, categorized by a graduate's race and ethnicity. The race and ethnicity of 500 recent graduates...
John turned 19 and started college at Northern Colorado University after a year of community college....
John turned 19 and started college at Northern Colorado University after a year of community college. His father bought him a 2003 Honda Accord for $3,500 to drive while in school. John’s father promised him if he did not have any accident he would buy him a brand-new Ford Mustang GT once he finished his undergraduate degree. How much liability coverage (per person bodily injury liability, total liability, property damage liability) do you recommend for his 2003 Honda Accord? Give...
Suppose 56% of the population has a college degree. If a random sample of size 503...
Suppose 56% of the population has a college degree. If a random sample of size 503 is selected, what is the probability that the proportion of persons with a college degree will be greater than 54%? Round your answer to four decimal places.
Use Excel to answer. A college admission officer for an MBA program determines that historically candidates...
Use Excel to answer. A college admission officer for an MBA program determines that historically candidates have undergraduate grade averages that are normally distributed with standard deviation of .45. A random sample of 25 applications from the current year yields a sample mean grade point average of 2.90. Find a 95% confidence interval for the population mean, μ. (Round the boundaries to 2 decimal places.) Based on the same sample results, a statistician computes a confidence interval for the population...
Maria Turner has just graduated from college with a degree in accounting. She had planned to...
Maria Turner has just graduated from college with a degree in accounting. She had planned to enroll immediately in the master’s program at her university but has been offered a lucrative job at a well-known company. The job is exactly what Maria had hoped to find after obtaining her graduate degree. In anticipation of master’s program classes, Maria has already spent $450 to apply for the program. Tuition is $8,000 per year, and the program will take two years to...
NEED EXCEL USE OF PV and FV.Thanks Ben Bates graduated from college six years ago with...
NEED EXCEL USE OF PV and FV.Thanks Ben Bates graduated from college six years ago with a finance undergraduate degree. Although he is satisfied with his current job, his goal is to become an investment banker. He feels that an MBA degree would allow him to achieve this goal. After examining schools, he has narrowed his choice to either Wilton University or Mount Perry College. Although internships are encouraged by both schools, to get class credit for the internship, no...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT