Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The data at the bottom pertains to the question that I have. This data contains the 928 observations Francis Galton used in 1885 to estimate

The data at the bottom pertains to the question that I have.

This data contains the 928 observations Francis Galton used in 1885 to estimate the relationship between the heights of parents and the heights of their children. The column Children refers to the height (in inches) of a child, and the column Mid-Parents refers to the average height (in inches) of the mother and father of that child.

a. Calculate the regression Height of Children = a +b (Height of Mid-Parents).

b. Calculate the average for Height of Children, and calculate the average Height of Mid-Parents.

c. Create a new variable in Excel which is the Height of Children measured in terms of deviations from its mean. Call this new variable y. Also, create a new variable in Excel which is the Height of Mid-Parents measured in terms of deviations from its mean. Call this new variable x. Calculate the regression y = a + bx.

d. If a person's parents are 2 inches above average height, do you predict their children to be above or below average height? And how many inches above or below average height?

e. What fraction of the variation in the heights of children is explained by the heights of their parents?

f. Show the graph of the data with the equation for your regression line from part 2a of this question.

g. Use the F statistic to test the hypothesis that there is no relation between the heights of children and the heights of their parents at the 5% level of significance. Do you reject this hypothesis or not?

h. If you reject the hypothesis in the previous question, what is the probability of a false positive result?

DATA:

Mid-Parents Children
73 72.2
73 73.2
73 73.2
73 73.2
72.5 68.2
72.5 69.2
72.5 69.2
72.5 70.2
72.5 71.2
72.5 71.2
72.5 72.2
72.5 72.2
72.5 72.2
72.5 72.2
72.5 72.2
72.5 72.2
72.5 72.2
72.5 73.2
72.5 73.2
72.5 73.7
72.5 73.7
72.5 73.7
72.5 73.7
71.5 65.2
71.5 66.2
71.5 66.2
71.5 66.2
71.5 67.2
71.5 67.2
71.5 67.2
71.5 67.2
71.5 68.2
71.5 68.2
71.5 68.2
71.5 69.2
71.5 69.2
71.5 69.2
71.5 69.2
71.5 69.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 70.2
71.5 71.2
71.5 71.2
71.5 71.2
71.5 71.2
71.5 72.2
71.5 72.2
71.5 72.2
71.5 72.2
71.5 72.2
71.5 72.2
71.5 72.2
71.5 72.2
71.5 72.2
71.5 73.2
71.5 73.2
71.5 73.7
71.5 73.7
70.5 61.7
70.5 63.2
70.5 65.2
70.5 66.2
70.5 67.2
70.5 67.2
70.5 67.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 68.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 69.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 70.2
70.5 71.2
70.5 71.2
70.5 71.2
70.5 71.2
70.5 71.2
70.5 71.2
70.5 71.2
70.5 72.2
70.5 72.2
70.5 72.2
70.5 72.2
70.5 73.2
70.5 73.2
70.5 73.2
70.5 73.7
70.5 73.7
70.5 73.7
69.5 63.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 64.2
69.5 65.2
69.5 65.2
69.5 65.2
69.5 65.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 66.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 67.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 68.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 69.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 70.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 71.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 72.2
69.5 73.2
69.5 73.2
69.5 73.2
69.5 73.2
69.5 73.7
69.5 73.7
69.5 73.7
69.5 73.7
69.5 73.7
68.5 61.7
68.5 63.2
68.5 63.2
68.5 63.2
68.5 63.2
68.5 63.2
68.5 63.2
68.5 63.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 64.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 65.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 66.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 67.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 68.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 69.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 70.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 71.2
68.5 72.2
68.5 72.2
68.5 72.2
68.5 72.2
68.5 73.2
68.5 73.2
68.5 73.2
67.5 62.2
67.5 62.2
67.5 62.2
67.5 63.2
67.5 63.2
67.5 63.2
67.5 63.2
67.5 63.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 64.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 65.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 66.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 67.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 68.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 69.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 70.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 71.2
67.5 72.2
67.5 72.2
67.5 72.2
67.5 72.2
66.5 62.2
66.5 62.2
66.5 62.2
66.5 63.2
66.5 63.2
66.5 63.2
66.5 64.2
66.5 64.2
66.5 64.2
66.5 64.2
66.5 64.2
66.5 65.2
66.5 65.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 66.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 67.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 68.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 69.2
66.5 70.2
66.5 70.2
66.5 70.2
66.5 70.2
65.5 61.7
65.5 63.2
65.5 63.2
65.5 63.2
65.5 63.2
65.5 63.2
65.5 63.2
65.5 63.2
65.5 63.2
65.5 63.2
65.5 64.2
65.5 64.2
65.5 64.2
65.5 64.2
65.5 64.2
65.5 65.2
65.5 65.2
65.5 65.2
65.5 65.2
65.5 65.2
65.5 65.2
65.5 65.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 66.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 67.2
65.5 68.2
65.5 68.2
65.5 68.2
65.5 68.2
65.5 68.2
65.5 68.2
65.5 68.2
65.5 69.2
65.5 69.2
65.5 69.2
65.5 69.2
65.5 69.2
65.5 69.2
65.5 69.2
65.5 70.2
65.5 70.2
65.5 70.2
65.5 70.2
65.5 70.2
65.5 71.2
65.5 71.2
65.5 73.7
64.5 61.7
64.5 62.2
64.5 63.2
64.5 63.2
64.5 63.2
64.5 63.2
64.5 64.2
64.5 64.2
64.5 64.2
64.5 64.2
64.5 65.2
64.5 66.2
64.5 66.2
64.5 66.2
64.5 66.2
64.5 66.2
64.5 67.2
64.5 67.2
64.5 67.2
64.5 67.2
64.5 67.2
64.5 69.2
64.5 69.2
63.5 61.7
63.5 63.2
63.5 63.2
63.5 64.2
63.5 64.2
63.5 64.2
63.5 64.2
63.5 65.2
63.5 66.2
63.5 66.2
63.5 67.2
63.5 67.2
63.5 68.2
63.5 69.2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra A Combined Approach (Subscription)

Authors: Elayn Martin Gay

5th Edition

013417920X, 9780134179209

More Books

Students also viewed these Mathematics questions