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
keosha answered 1 year agoRelated 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
Latest Questions
- A sample human input file that contains test values that a human would enter on the...
- A solution is prepared by dissolving 15 ml of methanol in 150.0 ml water at 25...
- Consider a newlywed who is planning a wedding anniversary gift of a trip to Canada for...
- We are evaluating a project that costs $868,000, has a life of eight years, and has...
- a.) Given sample data: 61.2, 61.9, 62.8, 63.1, 64.0, 64.3, 64.9, 65.5, 66.3 and 67.9, test...
- A research paper describes an experiment in which 74 men were assigned at random to one...
- 1. Which components would a retail organization consider while surveying/assessing the suitability of its products for...
ADVERTISEMENT