Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help solving for t and p value of the attached picture. ng.cengage.com + 88 ng.cengage.com C 88 A Student Portal | A. A,

I need help solving for t and p value of the attached picture.

image text in transcribed
ng.cengage.com + 88 ng.cengage.com C 88 A Student Portal | A. A, BUS308: Statistic.. Week 2 - Assign.. 1Week 2 Mind Tap.. MindTap - Cenga. Screen Shot 2021.. Excel template - Saved Search (Option + Q) CENGAGE |MINDTAP Q Search this course ? File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Comments 10.2 Excel Activity 2a - Hypothesis Test for the Difference of Two Means (Structured) X E CA Arial A A ab Wrap Text Paste E lumber Tables Cells Show Question 1 BIU DabAv diting Merge & Center ToolPak 7.5/10 Video Undo Clipboard Font Alignment Commands Group Submit G41 fx 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 B C D G H The comparisons of Scholastic Aptitude Test (SAT) scores based on the highest level of education attained by the College High School Part b Formula test taker's parents are provided. A research hypothesis was that students whose parents had attained a higher 592 516 College High School level of education would on average score higher on the SAT. The overall mean SAT math score was 514. SAT M A W NI 592 468 Mean 541 472 =AVERAGE(A:A) =AVERAGE(B:B) math scores for independent samples of students follow. 592 52 Two samples are contained in the Excel Online file below. The first sample shows the SAT math test scores for 5 A-Z 480 540 Difference Between the Means 69 =E3-F3 students whose parents are college graduates with a bachelor's degree. The second sample shows the SAT math 6 448 468 test scores for students whose parents are high school graduates but do not have a college degree. Use the Excel 7 656 480 Part c Online spreadsheet below to answer the following questions. 8 496 384 T Test: Two-Sample Assuming Unequal Variances Office 9 448 408 10 480 396 592 516 ? 11 448 528 Mear 637.6 468 Open spreadsheet 12 544 468 Variance 7380. 114286 3196.8 13 448 456 Observations 15 41 a. Formulate the hypotheses that can be used to determine whether the sample data support the hypothesis that 656 students show a higher population mean math score on the SAT if their parents attained a higher level of 14 Hypothesized Mean Difference 15 624 df 23 education. 16 480 t Stat 2.48789564 u1 = population mean math score parents college grads. 17 672 P(T Bo 21 22 23 b. What is the point estimate of the difference between the means for the two populations? At 24 Part d Significance Level (Alpha) 0.05 69 points higher @ if parents are college grads. 25 26 c. Compute the Can we reject the null hypothesis? t-value, degrees of freedom, and (Enter "Can" or "Cannot") CAN =IF(E17

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Non-Cooperative Game Theory

Authors: Takako Fujiwara Greve

1st Edition

4431556451, 9784431556459

More Books

Students also viewed these Mathematics questions

Question

The symbol Answered: 1 week ago

Answered: 1 week ago

Question

5. It is the needs of the individual that are important.

Answered: 1 week ago

Question

3. It is the commitment you show that is the deciding factor.

Answered: 1 week ago