Question

Let x be the average number of employees in a group health insurance plan, and let y be the average administrative cost as a percentage of claims.

x	3	7	15	38	73
y	40	35	30	25	20

(a) Make a scatter diagram of the data and visualize the line you think best fits the data.

(b) Would you say the correlation is low, moderate, or strong? positive or negative?

low and negativemoderate and positive     strong and negativestrong and positivelow and positivemoderate and negative

(c) Use a calculator to verify that Σx = 136, Σx² = 7056, Σy = 150, Σy² = 4750, and Σxy = 3225. Compute r. (Round your answer to three decimal places.)
r =  

As x increases, does the value of r imply that y should tend to increase or decrease? Explain.

Given our value of r, we cannot draw any conclusions for the behavior of y as x increases.Given our value of r, y should tend to decrease as x increases.     Given our value of r, y should tend to increase as x increases.Given our value of r, y should tend to remain constant as x increases.

Answer 1

a) Scatter diagram

b) (b) Would you say the correlation is low, moderate, or strong? positive or negative?

negativestrong

c) Correlation coefficient

r = -0.933

Correlation

=CORREL(A2:A6,B2:B6)

As x increases, does the value of r imply that y should tend to increase or decrease? Explain.

Given our value of r, y should tend to remain constant as x increases.