Answered step by step
Verified Expert Solution
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.
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(E17Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started