Police sometimes measure shoe prints at crime scenes so that they can learn something about criminals. Listed below are shoe print lengths, foot lengths, and heights of males. Construct ascatterplot, find the value of the linear correlation coefficient r, and find the P-value of r. Determine whether there is sufficient evidence to support a claim of linear correlation between the two variables. Based on these results, does it appear that police can use a shoe print length to estimate the height of a male? Use a significance level ofα=0.01. Shoe Print (cm)30.328.632.132.226.9 Foot Length (cm)24.724.727.727.725.4 Height (cm)180.1177.9191.4173.6174.8 Police sometimes measure shoe prints at crime scenes so that they can learn something about criminals. Listed below are shoe print lengths, foot lengths, and heights of males. Construct a scatterplot, find the value of the linear correlation coefficient r, and find the P-value of r. Determinewhether there is sufficient evidence to support a claim of linear correlation between the two variables. Based on these results, does it appear that police can use a shoe print length to estimate the height of a male? Use a significance level of a = 0.01.Shoe Print (cm)Foot Length (cm)Height (cm)30.328.632.132.226.924.724.727.727.725.4180.1177.9191.4173.6174.8Construct a scatterplot. Choose the correct graph below.O A.В.С.O D.200-200-200-200-160+160+160+160-35353525Shoe Print (cm)25Shoe Print (cm)25Shoe Print (cm)25Shoe Print (cm)35The linear correlation coefficient is r=(Round to three decimal places as needed.)Determine the null and alternative hypotheses.Ho: P(Type integers or decimals. Do not round.)The test statistic is t= |.(Round to two decimal places as needed.)Find the p-value and then fill in the blanks below:Because the P-value of the linear correlation coefficient isthe significance level, theresufficient evidence to support the claim that there is a linear correlation between shoe print lengths and heights of males.Based on these results, does it appear that police can use a shoe print length to estimate the height of a male?A. Yes, because shoe print length and height do not appear to be correlated.B. No, because shoe print length and height do not appear to be correlated.C. No, because shoe print length and height appear to be correlated.D. Yes, because shoe print length and height appear to be correlated.O OHeight (cm)Height (cm)Height (cm)Height (cm)

Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for you. To get remaining sub-part solved please repost the complete question and mention the sub-parts to be solved. The scatter plot is obtained using EXCEL. The software procedure is given below: Enter the data. Select Insert > Charts > Scatter > Scatter with only Markers. The output using EXCEL is as follows: Correct Answer: Option B.The correlation value is obtained using EXCEL. The software procedure is given below: Enter the data. Select Data > Data Analysis >Correlation> OK. Enter Input Range as A1:B6 for variables Shoeprint and height. Mark Labels in First Row. Click OK. The output using EXCEL is as follows: From the output, the correlation coefficient is 0.447. Thus, the linear correlation coefficient is 0.447. Let ρ denotes the population correlation coefficient. The test is whether there is sufficient evidence to support a claim of linear correlation between the two variables. The hypothesis is, Null hypothesis: H0:ρ=0 Alternative hypothesis: H1:ρ≠0