https://docs.google.com/spreadsheets/d/1zMsCHwRuJFvzWCnztsdKPqpOzE25ivRoo4thcxKaO24/edit#gid=0 Use the results from the Student Data Table to complete the following problems. Make sure to show all...

1. Calculate the Pearson correlation between hand and foot size for students in the Student Data Table. Graph the relationship, determine a hypothesis to test this relationship, and statistically test this hypothesis using alpha=0.05. Interpret all results in a paragraph citing the appropriate statistics.
· Pearson’s correlation coefficient, r = = 0.758845466 ≈ 0.759 [Calculated from Excel with the formula =CORREL(H3:H22,G3:G22)]
Here, = observations of hand size and = observations of foot size
= average hand size and = average foot size
·
· Let ρ be population correlation coefficient between hand and foot size.
So, our hypothesis of interest here is:
H0 : ρ = 0 against H1 : ρ > 0
Test Statistic:
Test Criteria: A right tail test based on is appropriate here. α = 0.05.
So, reject H0 when or [where is the upper α point of distribution]
Calculation:

Clearly we see that calculated value of test statistic, 4.946 is greater than tabulated value of t distribution, 1.734. So, we reject H0 at 5% level of significance. Therefore we interpret that there exists a positive population correlation between hand and foot size.

2. Calculate the simple linear regression to...