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 Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X Open spreadsheet 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. ₁ population mean math score parents college grads. H2 = population mean math score parents high school grads. Ho: 1-2 H₁:11-12 b. What is the point estimate of the difference between the means for the two populations? if parents are college grads. points 0 0 c. Compute the t-value, degrees of freedom, and p-value for hypothesis test. t-value Degrees of freedom p-value d. At a = .05, what is your conclusion? (to 4 decimals) (to 4 decimals)
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 Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X Open spreadsheet 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. ₁ population mean math score parents college grads. H2 = population mean math score parents high school grads. Ho: 1-2 H₁:11-12 b. What is the point estimate of the difference between the means for the two populations? if parents are college grads. points 0 0 c. Compute the t-value, degrees of freedom, and p-value for hypothesis test. t-value Degrees of freedom p-value d. At a = .05, what is your conclusion? (to 4 decimals) (to 4 decimals)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Transcribed Image Text:123456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<
A
B
College High School
496
528
496
592
544
512
656
528
480
576
560
656
496
624
640
608
=
420
432
432
564
528
588
456
516
432
396
420
552
Data
+
с
Part b
Mean
D
Difference Between the Means
Part d
Significance Level (Alpha)
E
Can we reject the null hypothesis?
(Enter "Can" or "Cannot")
College
Part c
After reading these instructions delete all text in this shaded area.
Use the XLMiner Analysis ToolPak to conduct your t-Test analysis.
After deleting all text in this shaded area, set the output range in
the ToolPak to the top left cell of this area (D8).
Your t-Test output should fit into this shaded area.
F
0.05
High School
Formula
H
#N/A
#N/A
#N/A
#N/A
J
K
L
Transcribed Image Text: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 Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak
X
Open spreadsheet
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.
μ₁ = population mean math score parents college grads.
μ₂ =
population mean math score parents high school grads.
Ho: μ1 - μ2
H₁ μ1 μ2
b. What is the point estimate of the difference between the means for the two populations?
if parents are college grads.
points
î
c. Compute the
t-value, degrees of freedom, and
p-value for the hypothesis test.
t-value
Degrees of freedom
p-value
d. At a = .05, what is your conclusion?
(to 4 decimals)
(to 4 decimals)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 3 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
part c is completely wrong. please provide correct answers!!
Solution
by Bartleby ExpertRecommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman