The manager for sales contractors wants to construct a control chart for determining whether the 10 contractors are under control with regard to the number of sales made. Accordingly, the manager sampled 100 days from last year for each contractor, with the following results:
Contractor Number of Sales
Analyze these data using a control chart that would provide for a 98% confidence interval, identifying the control limits and contractors, if any, that are outside the control limits
Please include Excel formulas if possible
Since all the points are between the UCL and LCL, none of the contractors are outside the control limits.
UCL = 112.51 (Approx 113)
LCL = 58.69 (Approx 59)
Mean = 85.6
( PLEASE GIVE ME A LIKE )
THANK YOU ......
Get Answers For Free
Most questions answered within 1 hours.