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. 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. µ1 = population mean math score parents college grads. u2 = population mean math score parents high school grads. Но : иi — р2 H1 : 41 - l2 b. What is the point estimate of the difference between the means for the two populations? 69 points higher if parents are college grads. c. Compute the t-value, degrees of freedom, and p-value for the hypothesis test. t-value (to 4 decimals) Degrees of freedom 25 p-value (to 4 decimals) d. At a = .05, what is your conclusion? We reject Ho. can D8 fe T Test: Two-Sample Assuming Unequal Variances XLMiner Analysis ToolPak A Н College High School Part b Formula High School Anova: Single Factor 448 408 College 544 420 Mean 531 462 =AVERAGE(A2:A17) =AVERAGE(B2:B13) Anova: Two-Factor With Replication 464 564 656 420 Difference Between the Means 69 3ЕЗ-F3 Anova: Two-Factor Without Replication 512 432 Part c T Test: Two-Sample Assuming Unequal Variances 432 444 Correlation 8. 496 552 9. 544 444 Covariance 10 656 504 448 408 11 656 408 Mean 536.5333333 466.9090909 Descriptive Statistics 12 448 456 Variance 6797.409524 2893.090909 13 448 492 Observations 15 11 Exponential Smoothing 14 608 Hypothesized Mean Difference 15 528 df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail 23 F-Test Two-Sample for Variances 16 448 2.564305917 17 608 0.00866905 Fourier Analysis 18 1.713871480 19 0.017338099 Histogram 20 2.068657599 21 Linear Regression 22 23 Logistic Regression 24 Part d 25 Significance Level (Alpha) 0.05 Moving Average 26 Can we reject the null hypothesis? |(Enter "Can" or "Cannot") Random Number Generation 27 #N/A Rank and Percentile 28

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Topic Video
Question

Find the t-value and p-value

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.
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.
µ1 = population mean math score parents college grads.
u2 = population mean math score parents high school grads.
Но : иi — р2
H1 : 41
- l2
b. What is the point estimate of the difference between the means for the two populations?
69
points higher
if parents are college grads.
c. Compute the
t-value, degrees of freedom, and
p-value for the hypothesis test.
t-value
(to 4 decimals)
Degrees of freedom
25
p-value
(to 4 decimals)
d. At a = .05, what is your conclusion?
We
reject Ho.
can
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. 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. µ1 = population mean math score parents college grads. u2 = population mean math score parents high school grads. Но : иi — р2 H1 : 41 - l2 b. What is the point estimate of the difference between the means for the two populations? 69 points higher if parents are college grads. c. Compute the t-value, degrees of freedom, and p-value for the hypothesis test. t-value (to 4 decimals) Degrees of freedom 25 p-value (to 4 decimals) d. At a = .05, what is your conclusion? We reject Ho. can
D8
fe
T Test: Two-Sample Assuming Unequal Variances
XLMiner Analysis ToolPak
A
Н
College High School
Part b
Formula
High School
Anova: Single Factor
448
408
College
544
420
Mean
531
462
=AVERAGE(A2:A17)
=AVERAGE(B2:B13)
Anova: Two-Factor With Replication
464
564
656
420
Difference Between the Means
69
3ЕЗ-F3
Anova: Two-Factor Without Replication
512
432
Part c
T Test: Two-Sample Assuming Unequal Variances
432
444
Correlation
8.
496
552
9.
544
444
Covariance
10
656
504
448
408
11
656
408
Mean
536.5333333
466.9090909
Descriptive Statistics
12
448
456
Variance
6797.409524
2893.090909
13
448
492
Observations
15
11
Exponential Smoothing
14
608
Hypothesized Mean Difference
15
528
df
t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail
23
F-Test Two-Sample for Variances
16
448
2.564305917
17
608
0.00866905
Fourier Analysis
18
1.713871480
19
0.017338099
Histogram
20
2.068657599
21
Linear Regression
22
23
Logistic Regression
24
Part d
25
Significance Level (Alpha)
0.05
Moving Average
26
Can we reject the null hypothesis?
|(Enter "Can" or "Cannot")
Random Number Generation
27
#N/A
Rank and Percentile
28
Transcribed Image Text:D8 fe T Test: Two-Sample Assuming Unequal Variances XLMiner Analysis ToolPak A Н College High School Part b Formula High School Anova: Single Factor 448 408 College 544 420 Mean 531 462 =AVERAGE(A2:A17) =AVERAGE(B2:B13) Anova: Two-Factor With Replication 464 564 656 420 Difference Between the Means 69 3ЕЗ-F3 Anova: Two-Factor Without Replication 512 432 Part c T Test: Two-Sample Assuming Unequal Variances 432 444 Correlation 8. 496 552 9. 544 444 Covariance 10 656 504 448 408 11 656 408 Mean 536.5333333 466.9090909 Descriptive Statistics 12 448 456 Variance 6797.409524 2893.090909 13 448 492 Observations 15 11 Exponential Smoothing 14 608 Hypothesized Mean Difference 15 528 df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail 23 F-Test Two-Sample for Variances 16 448 2.564305917 17 608 0.00866905 Fourier Analysis 18 1.713871480 19 0.017338099 Histogram 20 2.068657599 21 Linear Regression 22 23 Logistic Regression 24 Part d 25 Significance Level (Alpha) 0.05 Moving Average 26 Can we reject the null hypothesis? |(Enter "Can" or "Cannot") Random Number Generation 27 #N/A Rank and Percentile 28
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Algebraic Operations
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman