I need some help on this excel problem This data contains the SAT math scores for 15 students in 2013 and 17 students in 2014 At the 5 level of significance, how do I test to see if the data set supports the hypothesis that the mean score in 2014 was different than the mean score in 2013 How is this done in excel What is the null and alternate hypothesis and do we reject it What is our final conclusion about the hypothesis A B 1 SAT Year 2 579 2013 509 2013 527 2013 516 2013 592 2013 503 2013 511 2013 517 2013 10 538 2013 11 549 2013 12 557 2013 13 568 2013 14 582 2013 15 553 2013 16 424 2013 17 594 2014 18 513 2014 19 566 2014 20 588 2014 21 584 2014 22 510 2014 23 535 2014 24 514 2014 25 582 2014 26 567 2014 27 593 2014 28 574 2014 29 597 2014 30 558 2014 31 461 2014 32 523 2014 33 541 2014

The Answer is in the image, click to view ...

Question: I need some help on this excel problem This data contains the SAT math scores for 15 students in 2013 and 17 students in 2014.

I need some help on this excel problem

This data contains the SAT math scores for 15 students in 2013 and 17 students in 2014. At the 5% level of significance, how do I test to see if the data set supports the hypothesis that the mean score in 2014 was different than the mean score in 2013?

How is this done in excel?
What is the null and alternate hypothesis and do we reject it?
What is our final conclusion about the hypothesis?

I need some help on this excel problemThis data contains the SAT

A B 1 SAT Year 2 579 2013 509 2013 527 2013 516 2013 592 2013 503 2013 511 2013 517 2013 10 538 2013 11 549 2013 12 557 2013 13 568 2013 14 582 2013 15 553 2013 16 424 2013 17 594 2014 18 513 2014 19 566 2014 20 588 2014 21 584 2014 22 510 2014 23 535 2014 24 514 2014 25 582 2014 26 567 2014 27 593 2014 28 574 2014 29 597 2014 30 558 2014 31 461 2014 32 523 2014 33 541 2014

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Joong Won Mo This set of WeBWorK problems is designed to orient you to the WeBWorK system and to help you learn how to communicate with the software. You will be learning about how to understand what...

o, I'm in need of answers to these questions. You can use an excel sheet of you need or a calculator. I write fantastic reviews as well! 1.) Surgical complications: A medical researcher wants to...

I need help with the last three questions to this problem. Many random number generators allow users to specify the range of the random numbers to be produced. Suppose that you specify that the range...

Assume the random variable x is normally distributed with mean u = 50 and standard deviation 6 = 7. Find the indicated probability. P(x > 38) P(x > 38) = D (Round to four decimal places as needed.)...

1.The following are the ages of a group of tourists visiting The Library of Congress: 36, 38, 33, 44, 37, 37, 38, 34, 34, 36, 34, 40, 42, 41, 35, 48, 31, 33, 46, 47, 33, 36, 37, 37, 34, 39, 35, 37,...

STAT 200 QUIZ 3 Section 6361 Summer 2017 I have completed this assignment myself, working independently and not consulting anyone except the instructor. NAME_____________________________ INSTRUCTIONS...

T-TEST FOR INDEPENDENT AND CORRELATED SAMPLES Show your complete solution. if you opt to solve this by hand. If you opt to use excel, follow the process of hypothesis testing then upload the excel le...

Please answer these questions and put them in a readable format (ex. 1a, 1b, 2a, 2b, etc...). No explanation needed. 1. Exercise 10.09 Algo (lnferences About the Difference Between Two Population...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Sitmore and Dolittle, Inc., has 41 retail clothing outlets scattered throughout the country. Each outlet sends an average of $5,000 daily to the head office in South Bend, Indiana, through checks...

Use the leading-term test and your knowledge of y-intercepts to match the function with one of the graphs (a)-(f), which follow. 1. f (x) = 1/4x2 - 5 2. f (x) = - 0.5x6 - x5 + 4x4 - 5x3 - 7x2 + x - 3...

How to compute cycle time and velocity?

A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600...

socialist egalitarianism which resulted in wage levelling;

soyuznye (all-Union, controlling enterprises directly from Moscow);

functional committees having no direct supervision of enterprises, but responsible for overall policy and planning (GosPlan) and certain subordinate aspects of economic life such as supply (GosSnab),...