The College Board provided comparisons of SAT

ExcelProject4

Excel Project 4 This Excel Project contains 7 questions. Work out the answers to the questions and then click on "Excel Project 4" to submit your answers. Directions for performing a hypothesis test for comparing means in Excel are in the Excel Demo posted in the Week 12 folder on K-State online. **Give your answers to 2 decimal places!** The College Board provided comparisons of SAT scores based on the highest level of education attained by the test taker's parents. A research hypothesis was that students whose parents had attained a higher level of education would on average score higher on the SAT. This data set contains verbal SAT scores for a sample of students whose parents are college graduates and a sample of students whose parents are high school graduates. Use 0.01 as your level of significance. 1. Formulate hypotheses to test the research hypothesis. Let population 1 be the students whose parents are college graduates and let population 2 be students whose parents are high school graduates. 2. Is this an one-tailed or two-tailed test? 3. Use Excel to test your hypotheses. What is the test statistic? 4. What is the p-value? 5. What is the critical value? 6. What is your conclusion using 0.01 as the level of significance? 7. Explain your conclusion in the context of the problem (i.e. in terms a non-statistician could understand).

Sheet3