In Born together-Reared apart: the Landmark Minnesota twin study (2012), Nancy Segal discusses the efforts of research psychologists at the University of Minnesota to understand similarities and differences between twins by studying sets of twins who were raised separately. The Excel Online file below contains critical reading SAT scores for several pairs of identical twins (twins who share all of their genes), one of whom was raised in a family with no other children (no siblings) and one of whom was raised in a family with other children (with siblings). Construct a spreadsheet 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 Open spreadsheet a. What is the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings? (to 2 decimals) 17.7 b. Provide a 90% confidence interval estimate of the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings. (-27.68 X) (to 2 decimals) c. Conduct a hypothesis test of equality of the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings. p-value is 0.5132 (to 4 decimals) At a = .05, what is your conclusion? Can conclude 63.08 that there is a difference between the mean scores for the no sibling and with sibling groups.

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
Question

please do everything correct!! i will upvote!!

E2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
File
A
SAT Score
No Siblings
395
621
598
415
381
421
499
619
557
679
625
581
511
630
Home
551
661
502
603
526
580
408
456
485
417
589
501
610
480
603
436
628
513
605
583
633
542
642
Insert
B
SAT Score With
Siblings
370
584
623
Data
Arial
+
Draw Page Layout
Change in SAT
Score (di)
✓10
B
fx After reading these instructions delete all text in this shaded area.
F
Calculation Mode: Automatic Workbook Statistics
D
Formulas
Part b
The 90% confidence interval
C.I.Lower Limit
C.I.Upper Limit
Part c
Degrees of Freedom
E
Test statistic
p-value
Data
Part a
After reading these instructions delete all text in this shaded area.
Use the XLMiner Analysis ToolPak to conduct your analysis.
After deleting all text in this shaded area, set the output range in
the ToolPak to the top left cell of this area (E2).
Your analysis output should fit into this shaded area.
Review
Significance Level (Alpha)
Can we conclude that there is difference
between the mean scores? (Enter "Can
conclude" or "Cannot conclude")
View Help
v
0.01
ab
G
General
Formula
H
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
←0
.00
.00
→.0
I
J
▬▬▬
K
L
Ev
M
Editing
2
N
Ov
Give Feedback to Microsoft
Comments
O
>
80% +
P
Transcribed Image Text:E2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 File A SAT Score No Siblings 395 621 598 415 381 421 499 619 557 679 625 581 511 630 Home 551 661 502 603 526 580 408 456 485 417 589 501 610 480 603 436 628 513 605 583 633 542 642 Insert B SAT Score With Siblings 370 584 623 Data Arial + Draw Page Layout Change in SAT Score (di) ✓10 B fx After reading these instructions delete all text in this shaded area. F Calculation Mode: Automatic Workbook Statistics D Formulas Part b The 90% confidence interval C.I.Lower Limit C.I.Upper Limit Part c Degrees of Freedom E Test statistic p-value Data Part a After reading these instructions delete all text in this shaded area. Use the XLMiner Analysis ToolPak to conduct your analysis. After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (E2). Your analysis output should fit into this shaded area. Review Significance Level (Alpha) Can we conclude that there is difference between the mean scores? (Enter "Can conclude" or "Cannot conclude") View Help v 0.01 ab G General Formula H #N/A #N/A #N/A #N/A #N/A #N/A ←0 .00 .00 →.0 I J ▬▬▬ K L Ev M Editing 2 N Ov Give Feedback to Microsoft Comments O > 80% + P
In Born together-Reared apart: the Landmark Minnesota twin study (2012), Nancy Segal discusses the efforts of research psychologists at the University of Minnesota to understand
similarities and differences between twins by studying sets of twins who were raised separately. The Excel Online file below contains critical reading SAT scores for several pairs of
identical twins (twins who share all of their genes), one of whom was raised in a family with no other children (no siblings) and one of whom was raised in a family with other children
(with siblings). Construct a spreadsheet 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. What is the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings?
(to 2 decimals)
17.7
b. Provide a 90% confidence interval estimate of the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings.
) (to 2 decimals)
c. Conduct a hypothesis test of equality of the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings.
(to 4 decimals)
(-27.68
p-value is 0.5132
At a =
I
Can conclude
= .05, what is your conclusion?
63.08
î
Check My Work
that there is a difference between the mean scores for the no sibling and with sibling groups.
Reset Problem
Transcribed Image Text:In Born together-Reared apart: the Landmark Minnesota twin study (2012), Nancy Segal discusses the efforts of research psychologists at the University of Minnesota to understand similarities and differences between twins by studying sets of twins who were raised separately. The Excel Online file below contains critical reading SAT scores for several pairs of identical twins (twins who share all of their genes), one of whom was raised in a family with no other children (no siblings) and one of whom was raised in a family with other children (with siblings). Construct a spreadsheet 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. What is the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings? (to 2 decimals) 17.7 b. Provide a 90% confidence interval estimate of the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings. ) (to 2 decimals) c. Conduct a hypothesis test of equality of the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings. (to 4 decimals) (-27.68 p-value is 0.5132 At a = I Can conclude = .05, what is your conclusion? 63.08 î Check My Work that there is a difference between the mean scores for the no sibling and with sibling groups. Reset Problem
Expert Solution
steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

part b is wrong. please fix that!!

Solution
Bartleby Expert
SEE SOLUTION
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