Using Excel Add-in “Data Analysis” and the following data: X = Years with company Y = Shares of


Question: Using Excel Add-in “Data Analysis” and the following data:

X = Years with company Y = Shares of company stock
6 300
12 408
14 560
6 252
9 288
13 650
15 630
9 522

a. What are the measures of central tendency and the standard deviation for both the X and Y data?

b. What is the correlation between X and Y?

c. Create a Scatter Diagram for these data.

d. How would you describe this correlation?

Price: $2.99
Answer: The solution consists of 4 pages
Solution Format: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in