Answer Happy

College High School 552 560 576 468 552 384 420 528 496 672 624 512 528 512 592 432 496 560 576 544 672 448 528 552 516 576 588 420 Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add in manually from the home ribbon. Screenshot of ToolPak The comparisons of Scholastic Aptitude Test (SAT) scores based on the highest level of education attained by the test taker's parents are provided. A research hypothesis was that students whose parents had attained a higher level of education would on average score higher on the SAT. The overall mean SAT math score was 514. SAT math scores for independent samples of students follow. Two samples are contained in the Excel Online file below. The first sample shows the SAT math test scores for students whose parents are college graduates with a bachelor's degree. The second sample shows the SAT math test scores for students whose parents are high school graduates but do not have a college degree. Use the Excel Online spreadsheet below to answer the following questions. X Open spreadsheet a. Formulate the hypotheses that can be used to determine whether the sample data suppor the hypothesis that students show a higher population mean math score on the SAT if their parents attained a higher level of education. #1 = population mean math score parents college grads. #2 = population mean math score parents high school grads. Ho 141 142 H₁141142 - ✓0 0 b. What is the point estimate of the difference between the means for the two populations? points if parents are college grads. c. Compute the t-value, degrees of freedom, and p-value for the hypothesis test. (to 4 decimals) t-value Degrees of freedom p-value We d. At a = .05, what is your conclusion? ✓reject Ho. (to 4 decimals)