Business Finance Homework Help

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.