Question

AutoSave C u09a3 c-Chart Homework BLANK (1) Protected View ... Search Fadwa Toumi Ben Chekroun FT File Home Insert Formulas P

AutoSave u09a3 c-Chart Homework - BLANK (1) Protected View ... Off Search Fadwa Toumi Ben Chekroun FT File Home Insert Review

Use the attached spreadsheet to complete a two-pass c-Chart analysis of the case contained with it.

Use this spreadsheet

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

C-Chart:-

c charts are used to look at variation in counting type attributes data. They are used to determine the variation in the number of defects in a constant subgroup size. Subgroup size usually refers to the area being examined.

Now formula for finding control limit of the C-Chart is as follow

here Technician = K and C = Defects

where K is the number of values  in the observation

here k= 30

now find control limit and plot the C-Chart

For PASS 1

now C chart is given as below

Comment :If we see in the above C-Chart the points 2,17,22

are the out of control because they lie above the UCL line hence we say that the points are outlier.

For PASS 2

Comment :If we see in the above C-Chart the points 2,17,22

are the out of control because they lie above the UCL line hence we say that the points are outlier.

in this problem managers does not found specific cause it is an human error that mean only 2,17,22 Technician they are not properly counting numbers of defects hence there is more defect .

Thank You..!!

please like it..

Add a comment
Know the answer?
Add Answer to:
Use the attached spreadsheet to complete a two-pass c-Chart analysis of the case contained with it....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Quasar Exports Ltd, a fictional Turkish manufacturer of glass, wants to use a c-chart to monitor...

    Quasar Exports Ltd, a fictional Turkish manufacturer of glass, wants to use a c-chart to monitor the number of defects in the sheets of glass it produces. The company wants to use the chart to address the production problems it is experiencing and use it on an ongoing basis as a monitoring tool. To construct the chart, the company collected data over 5 days by inspecting 30 sheets of glass and recording the number defects per sheet. The data are...

  • The dataset below is the observed number of defects from inspecting 25 successive wafers each containing...

    The dataset below is the observed number of defects from inspecting 25 successive wafers each containing n= 100 chips. Here the wafer is the inspection unit. (a) Create the appropriate control chart to control the data. (b) From the control chart, would you conclude that the process is in statistical control? (c) If any out of control points by Western Electric runs rule 1 are observed, assume they have assignable causes and can be omitted from control limit estimates. Create...

  • Question 6 Gantt Chart (20 points) Develop the Gantt chart for the following network diagram. Ind...

    Please help with this civil engineering problem! I promise I'll rate your answer! Question 6 Gantt Chart (20 points) Develop the Gantt chart for the following network diagram. Indicate in the Gantt chart the total float value for each activity that is not part of the critical path by marking the corresponding cells of an activity with dash marks “ “ ESD Duration EFD Activity Name LSD| Float LFD 213 3 2 5 5 2 7 13 10 15 15...

  • Question pertains to the x-chart part Sample Mean Range 16 8 12 13 6 6 4...

    Question pertains to the x-chart part Sample Mean Range 16 8 12 13 6 6 4 15 10 10 11 10 16 13 14 0 14 17 11 12 IU 12 12 11 13 14 12 7 8 13 9 11 14 7 13 15 10 15 Subsequently, samples of size 5 were taken from the process every week for the next 10 weeks. The times were measured and the following results oblained: Sample Mean Range 16 9 17 12...

  • After discussing the issue with you and others in the Finance department, the manager decided to...

    After discussing the issue with you and others in the Finance department, the manager decided to change the payment terms for Accounts Receivable. The payment time remained at 14 days, but the penalty for late payments was increased. After about 3 months under the new payment terms, you asked the manager to collect a second stratified random sample. The data is presented in the second column of the worksheet (see the tab titled, “Data – Case #2) under the Heading...

  • Therefore, for this program you will read the data in the file named weatherdata_2.txt into arrays...

    Therefore, for this program you will read the data in the file named weatherdata_2.txt into arrays for the wind speed and for the temperature. You will then use the stored data to calculate and output the average wind speed and the average temperature. Create a constant with a value of 30 and use that to declare and loop through your arrays and as a divisor to produce your averages. Here is the data file (below). 1. 14 25 2. 12...

  • 4) Now that Continental can detect more defects before the Silver Box is shipped, I decided...

    4) Now that Continental can detect more defects before the Silver Box is shipped, I decided process Improvements in its circuit board fabrication department would further improve quality. So, for one process they collected the following data this morning to set up a mean control chart. Since the process mean is unknown, estimate the mean and find the UCL and LCL for a 3-sigma mean control chart using this morning's samples. Sample 1 - 24, 24, 25, 22, 21 Sample...

  • A soft drink manufacturer uses fire agents to handle premium distribution for is various products. The marketing director desired to study the timeliness with which the premiums are distributed. Twent...

    A soft drink manufacturer uses fire agents to handle premium distribution for is various products. The marketing director desired to study the timeliness with which the premiums are distributed. Twenty transactions for each agent were selected at random and the time lapse (in days) for handling each transaction was determined. The results follow: Agent 1 Agent 2 Agent 3 Agent 4 Agent 5 24 18 10 15 33 24 20 11 13 22 29 20 8 18 28 20 24...

  • 5. Download the file, Plates.csv, from Sakai. This file contains data about twenty five steel plates....

    5. Download the file, Plates.csv, from Sakai. This file contains data about twenty five steel plates. There are two variables in this file, Plate and Defects. The variable, Defects, contains the number of nonconformities on each plate. Convert the data as appropriate for analysis in either SAS or R. Make the appropriate control chart, and interpret your results Plates <- read.cs Plates Plate Defects ## 1 ## 2 3 ## 10 10 12 13 14 15 16 17 18 19...

  • solve the puzzle Down Across 2. VENLAFAXINE 3. TRIAZOLAM 1. CITALOPRAM 4. RISPERIDONE 7. MARPLAN 8....

    solve the puzzle Down Across 2. VENLAFAXINE 3. TRIAZOLAM 1. CITALOPRAM 4. RISPERIDONE 7. MARPLAN 8. QUETIAPINE 12. DIAZEPAM 5. CLORAZEPATE 6, LORAZEPAM 9. TRAZADONE 13. PROCHLORPERAZINE 18. LITHIUM 19. MIRTAZAPINE 21. ARIPIPRAZOLE 10. CHLORPROMAZINE 11. ZALEPLON 14. PERPHENAZINE 15. BUSPIRONE 16. HALOPERIDOL 17. NARDIL 20. OLANZAPINE 22. ZOLPIDEM 23. ZIPRASIDONE 24. MOBAN 25. SERTRALINE Name -8005 Professional Pharmacy Technician nformation Assignment # 3 4 9 10 11 13 15 14 1 1 18 16 21 20 22 23 24

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT