Question: Please show how to solve with formulas using excel. question 5 c-h 5. Using samples of 200 credit card statements, an auditor found the following:

Please show how to solve with formulas using excel. question 5 c-h

Please show how to solve with formulas using

5. Using samples of 200 credit card statements, an auditor found the following: Sample Number with errors 1 2 3 4 4 2 5 9 a. Determine the fraction defective in each sample. b. If the true fraction defective for this process is unknown, what is your estimate of it? c. What is your estimate of the mean and standard deviation of the sampling distribution of fractions defective for samples of this size? d. What control limits would give an alpha risk of 03 for this process? page 457 e. What alpha risk would control limits of .047 and .003 provide? f. Using control limits of 047 and .003, is the process in control? g. Suppose that the long-term fraction defective of the process is known to be 2 percent. What are the values of the mean and standard deviation of the sampling distribution? h. Construct a control chart for the process, assuming a fraction defective of 2 percent, using two-sigma control limits. Is the process in control

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!