Sharp Cookie, PMP, has been offered a fat contract to help an investment bank

profileThehonest
 (Not rated)
 (Not rated)
Chat

1. Sharp Cookie, PMP, has been offered a fat contract to help an investment bank, Sackem & Stackem, LLC, to determine if the company stock price has anything to do with sacking employees. Cookie, keen to show off her statistical analysis saavy immediately sets to work gathering data over the past 5 years. The data she gathers is as follows:

Year    Stock Price (Y)           # of employees sacked (X)
1          22.45                           120
2          24.50                           105
3          28.50                           150
4          36.50                           220
5          42.25                           325

a. Calculate the mean averages of the coordinates

b. Determine the covariance

c. Determine the correlation coefficient

d. Using Excel calculate R Square (% of confidence) and the Y Intercepte. Plot the points on a graph and draw the regression line

 

 

    • 8 years ago
    Calculations Shown
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      bq__42.docx