Hypothesis Test Project
The College Board quotes the average yearly tuition and fees costs for four-year public colleges at $9,410 for in-state students. I believe that can’t be right; the cost per year must be higher!
Attached is an Excel file containing a list of public colleges and their 2017-18 costs. You are to use this to test the above claim. To do so, you will want to chose a random sample of 40 colleges and run a hypothesis test. These calculations should be completed in Excel, with a write up done in Word. The write-up should contain:
- The colleges contained in your sample, along with the sample mean and sample standard deviation of yearly costs
- A statement of your hypotheses
- Your test statistic
- Your P-value
- Your conclusion
- A brief explanation of the results in your own words
Please submit your Word file