College High School 485 442 534 580 650 479 554 486 550 528 572 524 497 492 592 478 487 425 533 485 526 390 410 535 515 578 448 469 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)