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![](/images/msword.png)
Solution Format: Word Document
![](/images/msword.png)