c) Calculate a correlation coefficient (r) for the group 3A data. To do this, choose a cell and type "Correl". Then sele

[answerhappygod]

C Calculate A Correlation Coefficient R For The Group 3a Data To Do This Choose A Cell And Type Correl Then Sele 1 (57.25 KiB) Viewed 20 times

c) Calculate a correlation coefficient (r) for the group 3A data. To do this, choose a cell and type "Correl". Then select the range for heights, type a comma, then select the values for arm length, close parentheses. (it will look like this: -CORRELALAADI: ADS); You can click on the cell on the MW data page to see the fomula, as well.) What does your r-value tell you about whether or not there is a correlation? d) Use the critical value table above. Is your r-value significant or not? Explain. If you look on the MW tab in our spreadsheet, you can see that I pasted in the tests from Excel. In Excel, if you ask for the Correlation Coefficent, you will get the same value we got in Google sheets. But Excel can also provide the p-value. By asking for Linear Regression Analysis, you will be given the r-value (called "Multiple R") and an ANOVA table in which the "Significance F" is the p-value. e) Now you are going to do the same thing with class data. Keep in mind that the sample size is much bigger as you compare the two correlations. Using the chart function of google sheets, make a scatter plot of height vs. arm length for our class data (both sections). Be sure to adjust the axes to obtain an optimal spread of values. Insert it below as Figure 1.24. Figure 1.24 Comparison of student height to arm length for class data. In examining your scatterplot, do you think there is a statistically significant correlation between height and arm length for class data? Explain.