excel assignment help

Quiz6.xlsx

Question 1

Quiz 6 E270 Statistics Fall 2020
Question 1
In "Born Together - Reared Apart", 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 seperately. Below are critical reading SAT scores for several pairs of
identical twins (twins who share all their genes), one of which who 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).
No siblings	With Siblings
440	420
610	540
590	630
390	430
410	460
430	490
510	460
620	540
510	460
680	650
580	450
610	640
510	460
630	580
570	490
630	640
530	560
590	610
500	520
610	640
What is the mean difference between the critical reading SAT scores for the twins
raised with no siblings and the twins raised with siblings?
Provide a 90% confidence interval estimate for the mean differences between the
critical reading SAT scores for twins raised with no siblings and the twins raised with siblings.
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 at ά = .01. What is your conclusion?

The Financial Times/Harris Poll surveyed people in six countries to assess attitudes
toward a variety of alternate forms of energy. The data in the following table are a
portion of the poll's findings concerning whether people favor or oppose the
building of new nuclear power plants.
Response	Great Britain	France	Italy	Spain	Germany	United States
Strongly Favor	141	161	298	133	128	204
Favor more than oppose	348	366	309	222	272	326
Oppose more than favor	381	334	219	311	322	316
Strongly opposed	217	215	219	443	289	174
How large was the sample in the poll?
Conduct a hypothesis test to determine whether people's attitudes toward building new
nuclear power plants is independent of country. What is your conclusion?
Using the percentage of respondents who "strongly favor" and "favor more than oppose",
which country has the most favorable attitude toward building new nuclear power plants?
Which country has the least favorable attitude?