Hey, please solve these problems for me, but please SHOW THE EXCEL FORMULAS so I can enter them in mnaually showing how I got the answer. Thank You So Much.

AutoSave OFF 3: Exam #4 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Ruler Formula Bar Zoom 85% Normal Page E Page Break Page Custom Gridlines Headings Zoom to 100% Zoom to New Arrange Freeze Freeze Freeze Firs Preview Layout Views Selection Window All s Top Row Column x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. K17 4 X V fx B G H K L M N Q R Question 3. This question has 5 parts on 2 pages. Put your answers in the yellow cells. Use Excel for calculations. College High School The College Board provided comparisons of Scholastic Aptitude Test (SAT) scores based on 485 442 the highest level of education attained by the test taker's parents. A research hypothesis 534 580 was that students whose parents had attained a higher level of education would on 650 479 average score higher on the SAT. The overall mean SAT math score was 514. 554 486 550 SAT math scores for independent samples of students are shown to the left. The first 528 sample shows the SAT math test scores for students whose parents are college graduates 10 572 524 with a bachelor's degree. The second sample shows the SAT math test scores for students 11 497 492 whose parents are high school graduates but do not have a college degree. 12 592 478 13 487 425 533 485 526 390 410 535 515 1. State the null and alternative hypotheses. 578 448 Ho: 469 Ha: 2. Is this a right-tailed, left-tailed or two-tailed hypothesis test? 3. Compute the following statistics College High School n mean variance (s mean diff 25 critical t test t b-value Question 1 Question 2 Question 3 + ReadyAutoSave OFF 3Exam #4 - Saved to Home Insert Draw Page Layout Formulas Data Review View Ruler Formula Bar Zoom 85% Normal Page Break Page Custom Gridlines Headings 100 Zoom to 100% Zoom to New Arrange Freeze Preview Layout Views Selection Window All Panes To x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. K17 X V A B C E F G H M N 0 17 515 1. State the null and alternative hypotheses. 18 578 19 448 Ho 20 469 21 22 23 Ha: 24 25 26 27 28 2. Is this a right-tailed, left-tailed or two-tailed hypothesis test? 29 30 3. Compute the following statistics 36 College High School 37 38 mear 39 variance (s2) 40 mean diff 25 critical t test t p-value 46 4. Do you reject or fail to reject the null hypothesis? Tell me how you know. 5.State your conclusion in the context of the problem. 58 59 60 61 D Question 1 Question 2 Question 3 + Ready