Chat with us, powered by LiveChat The comparisons of Scholastic Aptitude Test (SAT) scores based on the highest level of education attained by the test taker's par - EssayAbode

The comparisons of Scholastic Aptitude Test (SAT) scores based on the highest level of education attained by the test taker’s par

Fill in the blank. No explanation. Send online calculator link

 

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.

 

a. Formulate 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.

u1=population mean math score parents college grads.

u2=population mean math score parents high school grads.

 

c. Compute the t-value, degrees of freedom, and p-value for the hypothesis test.

t-value (to 4 decimals)

Degrees of freedom

p-value (to 4 decimals)

 

 

Sheet2

College High School Part b Formula
448 552 College High School
480 432 Mean ERROR:#N/A ERROR:#N/A
656 528
624 588 Difference Between the Means ERROR:#N/A
448 408
592 504 Part c
656 408 After reading these instructions delete all text in this shaded area.
672 384
624 456 Use the XLMiner Analysis ToolPak to conduct your t-Test analysis.
640 408
512 492 After deleting all text in this shaded area, set the output range in
560 540 the ToolPak to the top left cell of this area (D8).
656
672 Your t-Test output should fit into this shaded area.
576
496
Part d
Significance Level (Alpha) 0.05
Can we reject the null hypothesis? ERROR:#N/A
(Enter "Can" or "Cannot")

Related Tags

Academic APA Assignment Business Capstone College Conclusion Course Day Discussion Double Spaced Essay English Finance General Graduate History Information Justify Literature Management Market Masters Math Minimum MLA Nursing Organizational Outline Pages Paper Presentation Questions Questionnaire Reference Response Response School Subject Slides Sources Student Support Times New Roman Title Topics Word Write Writing