In: Statistics and Probability
Listed below are the body lengths (in inches) and weights (in lb) of randomly selected bears:
Length |
40 64 65 49 47 |
Weight |
65 356 316 94 86 |
Bring data in to excel sheet.
Correlation syntax: "=CORREL(Array 1, Array 2)"
Correlation coefficient r = 0.96. It is perfect positive correlation between length and weight
b. Equation:
y = 12.286x - 467.76
Select Length and weight data and choose scatterplot diagram. select any data point and right click and add trendline. choose "Linear" in the trend line options
X = 72
y = 12.286*(72) - 467.76 = 416.83
Predicted weight of a bear is 416.83