Question

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

A                                        50

B                                        90

C                                        70

D                                        80

E                                        110

F                                        60

G                                        105

H                                        79

I                                         69

J                                         98

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

Answer 1

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 ......