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.

Due to a recent change by Microsoft you will need to open the XLMiner Anaiysis ToolFak addein manually from the home ribbon. Screenshot of ToolPai-c 111e comparisons of Scholastic Aptitude Test (SAT) scores based on the highest levei of education attained by the test takers 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. Tl'lE overail mean SAT math score was 514. SAT math scores for independent samples of students foilow. Two samples are contained in the Fxcel Dnline file below. The rst sample shows the SAT math test scores for students whose parents are coilege graduates with a bachelor's degree. The second sampie shows the SAT math test scores for students whose parents are high school graduates but do not have a coilege degree. Use the Excel Online spreadsheet below to answer the foilowing questions. Ope spreadsheet a. Fomruiate the hypotheses that can be used to determine whether the sample data support 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 parenis college grads. M = population mean math score pareni: high school grads. Hanan-m Human Is. What is the point estimate of the difference between the means for the two popuiations? c. Compute the t-vaiue, degrees offreedom, and pvalue for the hypothesis test. {evalue i: (to 4 decimals) Degrees of freedom l: pevalue E (to 4 decimals) if parents are college grads.