Question 2 SAT ( work should be done through excel and provide excel formulas used)

The average score on the SAT in Oregon last year was 525. A tutor wishes to know whether their students are doing better than Oregon average (that is, test average SAT score for students of this tutor is higher than 525) at 10% significance level.

In the Excel sheet labeled SAT there are randomly selected SAT scores from 36 students the tutor has worked with.

Show your work on the Excel sheet labeled SAT, then provide your final answers on the yellow highlighted cells properly.

a)What is the value of test statistic of this test? (Keep 4 or more decimal places)

b)What is the value of p value of this test? (Keep 4 or more decimal places)

c)Based on your p value, write the conclusion to answer the tutor's claim. Make sure to use the given word in the claim when writing the conclusion.

d)Show your work.

Data: SAT 550 505 522 519 572 435 506 522 668 516 523 509 507 531 712 714 576 523 505 762 519 517 516 503 438 513 612 511 515 414 499 493 506 551 500 504