(Solution Library) 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
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 |
- What are the measures of central tendency and the standard deviation for both the X and Y data?
- What is the correlation between X and Y?
- Create a Scatter Diagram for these data.
- How would you describe this correlation?
Price: $2.99
Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document 