Kate Drew has been hand-painting wooden Christmas ornaments for several years. R
ID: 3204577 • Letter: K
Question
Kate Drew has been hand-painting wooden Christmas ornaments for several years. Recently, she has hired some friends to help her increase the volume of her business. In checking the quality of the work, she notices that some slight blemishes occasionally are apparent. A sample of 24 pieces of work resulted in the following number of blemishes on each piece: 1,1,2,3,1,0,2,0,0,1,3,1,0,1,2,0,0,2,1,2,3,2,1,1. Develop upper and lower control limits (99.73%) for the number of blemishes on each piece. Is the process in control? Why? **Please do this in excel*
Explanation / Answer
mean from average(array) function in excel
and standard deviation from stdev(array) function.
as we know 99.73% control limits lie at 3 standard deviation away from mean.
hence lower control limit ; upper control limit =mean +/- 3*std deviation =-1.7172 ; 4.2172
as -ve defects not possible ; hence lower control limit ; upper control limit =0 ; 4.2172
as all blemishes lie in b/w control limits ; hence it is in control
X 1 1 2 3 1 0 2 0 0 1 3 1 0 1 2 0 0 2 1 2 3 2 1 1 mean 1.25 std devaition 0.99Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.