The file Galton on D2L 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. You can download this file into Excel and Minitab. 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 Minitab 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 Minitab with 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. You can create the new y and x variables in Excel of Minitab, whichever you find more convenient. If you use Minitab, click on Calc, Calculator, then fill in the boxes for Store Results In and Expression. “Store Results In” is the name you give to the new variable you are creating and “Expression” is the algebraic expression that defines the variable you are creating. d. If a person’s parents are 3 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. If a person’s parents are 3 inches below average height, do you predict their children to be above or below average height? And how many inches above or below average height? f. The term “regression to the mean” comes from Galton’s work. Why do you think that term is appropriate in the context of this problem? 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 that you are committing a Type I error (i.e., what is the probability of a false positive)? I was given an excel spreadsheet with 928 observations. The first 10 are the following, I just need to know how to calculate, I can then do the rest: 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 Please show me how to solve using EXCEL

The file Galton on D2L 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. You can download this file into Excel and Minitab.

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 Minitab 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 Minitab with 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. You can create the new y and x variables in Excel of Minitab, whichever you find more convenient. If you use Minitab, click on Calc, Calculator, then fill in the boxes for Store Results In and Expression. “Store Results In” is the name you give to the new variable you are creating and “Expression” is the algebraic expression that defines the variable you are creating.

d. If a person’s parents are 3 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. If a person’s parents are 3 inches below average height, do you predict their children to be above or below average height? And how many inches above or below average height?

f. The term “regression to the mean” comes from Galton’s work. Why do you think that term is appropriate in the context of this problem?

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 that you are committing a Type I error (i.e., what is the probability of a false positive)?

I was given an excel spreadsheet with 928 observations. The first 10 are the following, I just need to know how to calculate, I can then do the rest:

Please show me how to solve using EXCEL