Answer to Question #217910 in Statistics and Probability for saad

Question

Calculate coefficient of correlation for the following data and interpret the result.

Corn Yield (Y) 10, 15, 30, 35, 25, 30, 50, 45

Fertilizer (X) 0.3, 0.6, 0.9, 1.2, 1.5, 1.8, 2.1, 2.4

Answer 1

By using Excel function

=CORREL(A2:A9,B2:B9)

R=0.877

This is a strong positive correlation.