I\'m pretty confused by exactly what this question wants me to do: For each of t
ID: 3067576 • Letter: I
Question
I'm pretty confused by exactly what this question wants me to do: For each of the following, estimate the value of the linear correlation coefficient r for the given paired data obtained from 50 randomly selected students.
a. Their heaights are measure in inches (X) and those same heights (Y) are measured in centimeters.
b. Their IQ scores (X) and their heights (Y) are measured in centimeters.
c. Their pulse rates (X) are measured and their IQ scores (Y) are measured.
d. Their heights (X) are measured in centimeters and those same heights are listed again, but with negative signs (Y) preceding each of these second listings.
This is ALL of the information pertaining to the question, which is why I have no idea what it's talking about! Ugh.
Explanation / Answer
For all of the questions you need to calculate the Pearson Correlation coefficient. You can do it by using CORREL function in Excel. For example: If you enter 50 values in column A then the formula will be CORREL(A1:A50) this will give you the value of Pearson Correlation coefficient and it ranges from -1 to +1.
You must be having data available to calculate this coefficient.