PLEASE ANSWER QUESTIONS X7.9, X7.10, AND X7.13 USING EXCEL AND EXCEL FUNCTIONS.

ID: 3122139 • Letter: P

Question

PLEASE ANSWER QUESTIONS X7.9, X7.10, AND X7.13 USING EXCEL AND EXCEL FUNCTIONS. PLEASE ANSWER THE QUESTIONS FULLY.

student exercises late the UCL nd LCL for a R quality control plot for the following dataset 9 520, 520, 560.570, 330. 390.430,440.440 440.450.460, 460.490. 370, 400, 410 samples or sub-groups with 10 observations 570, 600, 610 The dataset refers to 21 is the average range for the relative 10 each. Each data value provided in the dataset observations out of m10 plot the data provided in exercise x79 and determine if the process is in or control

Explanation / Answer

R-Chart

Back-up Theory

Let Range of ith sub-group = Ri, i = 1,2,…..,k (21)

Average Range, R bar = (sum of Ri over i)/k

LCL (Lower Control Limit for R chart): (D3).(R bar)

UCL (Upper Control Limit) for R chart: (D4).(R bar)

For n (sub-group size) = 10,

D3 = 0.223 and D4 = 1.777

From the given data, Rbar = 9880/21 = 470.48

LCL = 0.223 x 470.48 = 104.91

UCL = 1.777 x 470.48 = 836.04

All the R-values are within the two limits implying that the process is under control so far as process variation is concerned.

DONE