• 100% Satisfaction Guarantee

Ryan, Engineer
Category: Calculus and Above
Satisfied Customers: 8937
Experience:  B.S. in Civil Engineering
40260889
Type Your Calculus and Above Question Here...
Ryan is online now

# I am taking PMAN 635, IN NEED OF DETAIL HELP. 1. Sharp

### Customer Question

I am taking PMAN 635, IN NEED OF DETAIL HELP.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) # ***** employees sacked (X)
1 22.45 120
2 24.50 105
3 28.50 150
4 36.50 220
5 42.25 325a. 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 Intercept
e. Plot the points on a graph and draw the regression line
Submitted: 11 months ago.
Category: Calculus and Above
Expert:  Ryan replied 11 months ago.

Hi,

Do you need to show all of the calculations for each part, or is using Excel to calculate answers for part a, b, and c acceptable?

Ryan

Expert:  Ryan replied 11 months ago.

Hi again,

Here are the solutions:

Regression