Question

In: Operations Management

On Excel data shows hours of experience and the corresponding quality scores for employees at a...

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

Solutions

Expert Solution

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


Related Solutions

The following data shows the hours worked by employees at a McDonalds and the number of...
The following data shows the hours worked by employees at a McDonalds and the number of dollars that they earned that day. Hours worked Pay dollars 8 68 7 59.5 8 68 5 42.5 10 85 8.5 72.25 7.5 63.75 9 76.5 Average: 7.875 66.9375 Standard Deviation 1.482035 12.5973 Correlation 1 a)Draw a scatterplot that represents this data. Draw an estimate for the line of least fit on the scatterplot as well. b) Use technology to find the least squares...
(Use Excel) The quality manager believes there may be a relationship between the experience level of...
(Use Excel) The quality manager believes there may be a relationship between the experience level of an inspector and whether a product passes or fails inspection. Inspection records were reviewed for 628 units of a particular product, and the number of units which passed and failed inspection was determined based on three inspector experience levels. The results are shown in the following table. Decision Experience Level Low (under 2 years) Medium (2-8 years) High (over 8 years) Pass 152 286...
The Excel file BankData shows the values of the following variables for randomly selected 93 employees...
The Excel file BankData shows the values of the following variables for randomly selected 93 employees of a large bank. This real data set was used in a court lawsuit against discrimination.   Let = monthly salary in dollars (SALARY), = years of schooling at the time of hire (EDUCAT), = number of months of previous work experience (EXPER), = number of months that the individual was hired by the bank (MONTHS), = dummy variable coded 1 for males and 0...
The Excel file BankData shows the values of the following variables for randomly selected 93 employees...
The Excel file BankData shows the values of the following variables for randomly selected 93 employees of a large bank. (A very similar data set was used in a court lawsuit against discrimination.)   Let = monthly salary in dollars (SALARY), = years of schooling at the time of hire (EDUCAT), = number of months of previous work experience (EXPER), = number of months that the individual was hired by the bank (MONTHS), = dummy variable coded 1 for males and...
The following data give the number of hours 5 students spent studying and their corresponding grades...
The following data give the number of hours 5 students spent studying and their corresponding grades on their midterm exams. Hours Studying 1 1 2 3 6 Midterm Grades 65 73 74 86 91 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0=65.9185 and b1=4.5698 for the calculations. Round your answer to three decimal places. Step 2 of 5: Calculate the estimated variance of errors, s^2e. Round your answer to three decimal places. Step...
The following data give the number of hours 5 students spent studying and their corresponding grades...
The following data give the number of hours 5 students spent studying and their corresponding grades on their midterm exams. Hours Studying 1 1 2 3 6 Midterm Grades 65 73 74 86 91 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0=65.9185 and b1=4.5698 for the calculations. Round your answer to three decimal places. Step 2 of 5: Calculate the estimated variance of errors, s^2e. Round your answer to three decimal places. Step...
The following data gives the number of hours 7 students spent studying and their corresponding grades...
The following data gives the number of hours 7 students spent studying and their corresponding grades on their exams. Hours Spent Studying 0 1 2.5 3 4 4.5 5.5 gRADES 60 69 72 75 78 81 90 Step 1 of 3: Calculate the correlation coefficient, r. Round your answer to six decimal places. Step 2 of 3: Determine if r is statistically significant at the 0.050.05 level. Step 3 of 3: Calculate the coefficient of determination, r2r2. Round your answer...
The following data give the number of hours 5 students spent studying and their corresponding grades...
The following data give the number of hours 5 students spent studying and their corresponding grades on their midterm exams. Hours Studying 1 1 3 5 6 Grades 74 86 87 96 98 Step 1 of 5 : Calculate the sum of squared errors (SSE). Use the values b0=76.2307b0=76.2307 and b1=3.7404b1=3.7404 for the calculations. Step 2 of 5 : Calculate the estimated variance of errors, s^2e. . Step 3 of 5 : Calculate the estimated variance of slope, s^2b1 ....
The following data give the number of hours 5 students spent studying and their corresponding grades...
The following data give the number of hours 5 students spent studying and their corresponding grades on their midterm exams. Hours Studying 0 1 3 4 6 Midterm Grades 73 78 85 90 93 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0=74.2456 and b1=3.4123 for the calculations. Round your answer to three decimal places. Step 2 of 5: Calculate the estimated variance of errors, s2e . Round your answer to three decimal places....
The following data gives the number of hours 10 students spent studying and their corresponding grades...
The following data gives the number of hours 10 students spent studying and their corresponding grades on their midterm exams. Hours Spent Studying 0 0.5 1 2 2.5 3 4 4.5 5 5.5 Midterm Grades 60 63 75 81 84 87 90 93 96 99 Determine if r is statistically significant at the 0.01 level.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT