Question: I need help with the below question - data set is included! Salary Major $64,464 Finance $63,170 Info Systems $58,919 Finance $71,804 Info Systems $56,015
I need help with the below question - data set is included!
Salary Major
$64,464 Finance
$63,170 Info Systems
$58,919 Finance
$71,804 Info Systems
$56,015 Info Systems
$72,487 Info Systems
$73,739 Finance
$73,666 Info Systems
$64,449 Info Systems
$65,738 Info Systems
$63,792 Info Systems
$70,611 Finance
$73,778 Info Systems
$73,815 Info Systems
$56,856 Finance
$72,001 Finance
$60,927 Info Systems
$70,811 Info Systems
$67,593 Info Systems
$61,958 Finance
$70,422 Info Systems
$66,119 Info Systems
$69,045 Info Systems
$77,982 Info Systems
$77,823 Info Systems
$62,769 Info Systems
$53,577 Info Systems
$51,646 Finance
$73,375 Finance
$70,437 Finance
$45,754 Finance
$70,861 Finance
$68,768 Info Systems
$64,379 Finance
$61,462 Info Systems
$69,973 Info Systems
$61,811 Info Systems
$57,908 Info Systems
$68,627 Finance
$68,648 Finance
$62,161 Info Systems
$68,405 Finance
$65,467 Info Systems
$78,251 Info Systems
$43,586 Finance
$64,411 Info Systems
$77,970 Finance
$66,435 Info Systems
$60,626 Info Systems
$85,230 Info Systems
$64,023 Info Systems
$62,439 Info Systems
$65,402 Info Systems
$83,305 Info Systems
$68,724 Info Systems
$79,473 Info Systems
$68,012 Info Systems
$76,944 Info Systems
$62,203 Info Systems
$61,736 Info Systems
$73,978 Finance
$72,799 Finance
$72,240 Finance
$70,683 Info Systems
$63,335 Info Systems
$62,014 Info Systems
$69,753 Info Systems
$72,857 Info Systems
$63,815 Finance
$66,986 Info Systems
$82,536 Info Systems
$61,427 Info Systems
$79,443 Finance
$61,102 Finance
$62,459 Finance
$63,397 Finance
$60,295 Finance
$58,269 Finance
$64,592 Info Systems
$67,720 Info Systems
$80,279 Info Systems
$58,868 Finance
$86,967 Info Systems
$80,579 Info Systems
$63,063 Info Systems
$75,721 Finance
$67,350 Info Systems
$64,356 Finance
$51,035 Info Systems
$89,035 Info Systems
$57,002 Finance
$68,067 Finance
$66,120 Info Systems
$50,744 Finance
$63,313 Finance
$60,903 Finance
$75,481 Finance
$73,571 Info Systems
$66,664 Finance
$57,138 Info Systems
$70,253 Finance
$80,247 Finance
$72,292 Finance
$61,182 Info Systems
$72,706 Info Systems
$65,718 Info Systems
$70,936 Info Systems
$71,636 Info Systems
$72,385 Info Systems
$70,348 Info Systems
$55,808 Info Systems
$65,614 Finance
$69,587 Finance
$67,000 Info Systems
$64,741 Finance
$58,902 Info Systems
$81,675 Info Systems
$58,089 Finance
$72,422 Finance
$61,597 Info Systems
$71,603 Finance
$63,907 Finance
$66,675 Info Systems
$64,819 Info Systems
$56,277 Info Systems
$80,285 Info Systems
$59,111 Info Systems
$68,918 Finance
$64,326 Finance
$75,562 Info Systems
The Director of Career Services at a local university wishes to know whether there is a difference between the average post-graduation starting salaries of two undergraduate populations: Finance majors and Information Systems ("IS") majors. A random sample is drawn from the population of last year's graduating Finance majors, and a random sample is drawn from the population of last year's graduating Information Systems majors. The starting salary of each member of the two samples 's provided in "Career Services" tab of the file named "Final Examination 2021.xlsx": each row (except the first) represents one person, Column A contains the starting salary of that person, and Column B contains the undergraduate major of that person. The first row contains the column labels. Using these data: 1. What is the null hypothesis (in words)? 2. What is the alternative hypothesis (in words)? 3. What statistical test are you using to test this hypothesis? (Be specific: a generic reference will not receive credit) 4. Does this problem call for a directional test or a non-directional test? Why? 5. What is your best estimate of the difference (IS-Finance) in the two population means (accurate to the nearest dollar)? 6. What is the value of tstat? 7. What is the value of tcrit against which you compare tstat? (Provide just one numeric value) 8. What p-value is associated with the hypothesis of interest? (Provide just one numeric value) 9. Based on these data, can the Director of Career Services be at least 959% sure that there is a difference in the post-graduation starting salaries of Finance v5. Information Systems majors? (Yes or No) Justify your answer. 10. What are the lower and upper bounds of a 959% confidence interval around the difference (IS-Finance) in average salaries
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help