MindTap - Cengage Learning C Get Homework Help With answers X + 2 Х c ng.cengage.com/static/nb/ui/evo/index.html?deploymen

[answerhappygod]

1 (184.16 KiB) Viewed 64 times

MindTap - Cengage Learning C Get Homework Help With answers X + 2 Х c ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=583714295110239446224428046&eISBN=9781337615488&snapshotid=2774710&i... ☆ DE Update: CENGAGE MINDTAP Q Search this course : Ch. 6 Microsoft Excel: Structured Activity - SATMath X Question 1 1/2 = Submit 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 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. A-Z O 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. a Hi = population mean math score parents college grads. H2 = population mean math score parents high school grads. = . H:Mi-My Svo H:MM-12 go 0 ce benge b? b. What is the point estimate of the difference between the means for the two populations? points higher if parents are college grads. Back Next I Type here to search 다 IK 71°F 1:07 AM 4/23/2022
+ 2 Х MindTap - Cengage Learning C Get Homework Help With answers X c ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=583714295110239446224428046&eISBN=9781337615488&snapshotld=2774710&i... ☆ OF Update: CENGAGE MINDTAP Q Search this course : Ch. 6 Microsoft Excel: Structured Activity - SATMath X Question 1 1/2 = Submit HI – population mean mai scure parents culleye yraus. uz = population mean math score parents high school grads. HM-12 SVO H:41 - 42 - > 0 A-Z O b. What is the point estimate of the difference between the means for the two populations? go 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 © p-value (to 4 decimals) d. At a = .05, what is your conclusion? We can V v reject H, recent bengo Check My Work Reset Problem Back Next I Type here to search 대 71°F 1:07 AM 4/23/2022
х S Excel Online Student Work х C Get Homework Help With Chego x + 2 Х MindTap - Cengage Learning c O about:blank OF Update: Excel template - Saved O Search (Alt + Q) () File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments X LO Arial 10 ~ AA Wrap lext General SU IX HH a 07 Paste 三三 C BIU D# A Merge & Center $ % 8-28 Insert Delete Format Editing Conditional Format As Styles Formatting Table Styles Show ToolPak Commands Group Unco Clipboard Font Alignment Number Cells E3 X fx С C D E F G H Part b Formula 1 1 2 College High School Mean #N/A #N/A Difference Between the Means #N/A A B College High School 576 512 512 624 560 576 672 432 672 496 544 624 576 480 624 592 ಹ ಹ ಹ ದ ಪ ದ ನ =6 ಅ ಅ = 0 0 0 Partc After reading these instructions delete all text in this shaded area. 会念经爱念念套套@g Use the XL Miner 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. = A Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + % 1:07 AM 4/23/2022 HE Type here to search 다 71°F
х S Excel Online Student Work х C Get Homework Help With Chego x + 2 Х MindTap - Cengage Learning c O about:blank OF Update: Excel template - Saved O Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments X Arial 10 Wrap lext General IIX a 07 Paste ~ AA DA C BI U Dab 三三三 + + Merge & Center $ % 948-98 Insert Delete Format Editing Conditional Format As Styles Formatting Table Styles Show ToolPak Commands Group Unco Clipboard Font Alignment Number Cells E3 X fx A B C D E F G H H 18 19 20 21 22 23 24 25 26 0.05 Part d Significance Level (Alpha) LEWU WEITE hypothesis? (Enter "Can" or "Cannol") #N/A 27 28 29 30 31 32 33 34 = A Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + 1:08 AM 4/23/2022 HE Type here to search 라 71°F