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!

5. Using four samples of 200 credit card statements each, an auditor found the following number of erroneous statements in each sample:LO2 Number of errors 4 Sample 2 2 3 59 a. Determine the...

b) A new sample results in the following slab weights: 81.0,81.0,80.8,80.6, and 80.5. Judge whether or not the process is in control based on the data (including new sample data). c) Based on the...

5. Using samples of 200 credit card statements, an auditor found the following: Sample Number with errors 1 4 2 2 3 5 4 9 a. Determine the fraction defective in each sample. b. If the true fraction...

Question 7 (2.6 points) Loan Processing times are being monitored at a local company. Samples of ten observations each have been taken, and the results are listed. Using Factors from Table 10.2,...

Using samples of 200 credit card statements, an auditor found the following: Sample 1 2 3 4 5 6 Number of errors 9 3 6 9 8 6 Determine the 3-sigma LOWER control limit using the data above. Using...

Question 8 (2.6 points) Using samples of 200 credit card statements, an Auditor found the following: ---Sample Number: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number of Errors: 6 18 11 15 14 20 13 18 11...

1. Using samples of 200 credit card statements, an Auditor found the following: Sample Number: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number of Errors: 27 25 26 29 27 25 29 28 31 30 28 27 29 24 29...

please give a simple and shorter answer 1. Design specification for a motor housing states that it should weigh between 24kg and 25kg. The process that produces the housing yields a mean of 24.5kg...

1. Using samples of 200 credit card statements, an Auditor found the following: ---Sample Number: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number of Errors: 19 14 20 16 15 17 21 22 19 11 14 12 23 7 12...

5. Using four samples of 200 credit card statements each, an auditor found the following number of erroneous statements in each sample Number of Errors Sample 1234 4259 g. Suppose that the long-term...

A particle's displacement r(t) is governed by the differential equation Determine any equilibrium point(s) of the system and show that the equation of the general phase path is, for C constant, 12 8...

John is a salesman for the local car dealership. He can divide his 40-hour work week between talking to customers that walk in the door and calling possible prospects. Let W be the number of hours...

I need help finding the accurate solution to this general accounting problem with valid methods. Velan Manufacturing uses activity-based costing to assign overhead costs. The company identified the...

What is an example of constructive feedback? provide reference