a. Draw scatter plot for the variables

b. Compute the value of the correlation coefficient.

c. State the hyptothesis.

12. A medical researcher wishes to see if there is a relationship between prescription drugs and identical dosages that are prescribed for humans and for animals. The prices are shown. Is there a relationship between the prices?

Prices for humans (x) : .67/.64/1.20/.51/.87/.74/.50/1.22

Prices for animals (y) : .13/.18/.42/.25/.57/.57/.49/1.28

This is one of the problems i have to do in Excel, and I don't know how to do it...help please?:yup: