In an Excel spreadsheet for a c-chart,if the population process average for 20 samples,c,is in cell H4,the Excel formula for the upper control limit is
A)=H4+3*SQRTH4*1-H4))/100))
B)=H4+3*SQRTH4/20)
C)=H4+3*SQRTH4)
D)=H4+SQRT3*H4)

Question

Quizplus · Accepted Answer

The correct formula for the upper control limit (UCL) in a c-chart is given by UCL = c + 3*sqrt(c), where c is the average number of defects per unit (in this case, located in cell H4). Option C correctly represents this formula in Excel syntax.

In an Excel Spreadsheet for a C-Chart,if the Population Process