PROBLEM SET CORRELATION COEFFICIENT

A.PARTIAL CORRELATION COEFFICIENT

The following data resulted from 11 experimental runs made on 2 independent variables and a single response y:

X11.01.11.21.31.41.51.61.71.81.92.0

X22.12.31.51.62.03.10.90.73.11.82.0

Y8.17.88.59.89.58.98.610.29.39.210.5

Compute and interpret the partial correlation coefficient r _13.2, in 2 decimal places.

Let Y -1; X1-2;X2-3

B.RANK CORRELATION COEFFICIENT

In a study between the amount of rainfall(x) and the quantity of air pollution(y) removed, the following data were collected:

X4.34.55.95.66.15.23.82.17.5

Y126121116118114118132141108

Convert the given data to rank. Compute and interpret the rank correlation coefficient, in 2 decimal places.

Answer format: submit the computations in MS excel

A. r 13.2 =__________; Interpretation___________________

B. r =__________; Interpretation___________________