In: Operations Management
On Excel
data shows hours of experience and the corresponding quality scores for employees at a plant. The company is interested in studying the relationship between hours of experience and quality scores.
a)Compute the correlation coefficient between hours of experience and quality scores. Use Excel’s CORREL function.
b)Construct a scatter plot of quality scores vs. hours of experience. Does there appear to be a relationship? What kind?
c)Obtain a regression output that could be used to predict quality scores based on hours of experience. Based on the output, what is the regression equation?
Hours of experience | Quality Score |
1 | 53 |
5 | 74 |
7 | 59 |
8 | 43 |
10 | 56 |
11 | 84 |
14 | 96 |
15 | 69 |
15 | 84 |
19 | 83 |
a) Correlation coefficient
Using EXCEL's CORREL function, D17 =CORREL(B2:B11,A2:A11)
Correlation coefficient, r = 0.628
b) Scatter Plot
From the scatter plot, there appears to be a positive correlation between the two variables. As the hours of experience increases, the quality score also increase.
c) Regression output