In Born together—Reared apart: the Landmark Minnesota twinstudy (2012), Nancy Segal discusses the efforts of researchpsychologists at the University of Minnesota to understandsimilarities and differences between twins by studying sets oftwins who were raised separately. The Excel Online file belowcontains critical reading SAT scores for several pairs of identicaltwins (twins who share all of their genes), one of whom was raisedin a family with no other children (no siblings) and one of whomwas raised in a family with other children (with siblings).Construct a spreadsheet to answer the following questions.

Open spreadsheet

a. What is the mean difference between thecritical reading SAT scores for the twins raised with no siblingsand the twins raised with siblings?

(to 2 decimals)

b. Provide a 90% confidence interval estimateof the mean difference between the critical reading SAT scores forthe twins raised with no siblings and the twins raised withsiblings.

(, ) (to 2 decimals)

c. Conduct a hypothesis test of equality of thecritical reading SAT scores for the twins raised with no siblingsand the twins raised with siblings.

-value is  (to 4 decimals)

At , what is your conclusion?

_________Can concludeCannot conclude that there is a differencebetween the mean scores for the no sibling and with siblinggroups.

SAT Score No Siblings	SAT Score With Siblings	Change in SAT Score (di)		Part a
415	451			After reading these instructions delete all text in this shadedarea.
615	584
635	660			Use the XLMiner Analysis ToolPak to conduct your analysis.
378	437
429	457			After deleting all text in this shaded area, set the outputrange in
404	466			the ToolPak to the top left cell of this area (E2).
528	425
646	583			Your analysis output should fit into this shaded area.
517	486
695	652
583	484
607	650
521	468
633	574
545	465
592	673
528	523
612	650
502	509
596	649
				Part b
				The 90% confidence interval
				C.I.Lower Limit
				C.I.Upper Limit
				Part c
				Degrees of Freedom
				Test statistic
				p-value
				Significance Level (Alpha)	0.01
				Can we conclude that there is difference between the meanscores? (Enter "Can conclude" or "Cannot conclude")