Business Finance Homework Help
Temple University Business Excel Questions
Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Use Top_Colleges.xls file which consists of data from 95 top-ranked colleges. It includes variables regarding whether the college is public or private, the average annual out-of-state tuition & fees, and the average freshman SAT score (math + verbal only out of 1600).
- ASSIGNED PROBLEM 1: For 2015, the average SAT score for incoming freshmen in the US was 1100. Use the Hypothesis_Tests_One_Sample.xls file to test whether the top schools have an average SAT higher than the national average. Use a .05 significance level. Describe your findings which includes stating the hypotheses, direction of the test, p-value, decision to reject the null or not, and the conclusion.
- ASSIGNED PROBLEM 2: It is commonly believed that while public schools typically have tougher admission standards, private schools are often better academically. Use the Hypothesis_Tests_One_Sample.xls file to test whether fewer than 50% of the top-ranked schools are public. Use a .05 significance level. Describe your findings which includes stating the hypotheses, direction of the test, p-value, decision to reject the null or not, and the conclusion.
