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 Th

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 ThisExcel Project contains 7 questions. Work out the answers to the questions and then click on “Excel Project 4” to submit your answers. **Give your answers to 2 decimalplaces!** 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 signifiance? 7. Explain your conclusion in the context of the problem (i.g in terms a non- statistician could understand).

Posted in Uncategorized