Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

using excel Exercise 2. (4 points) Control Charts - When using control charts to

ID: 3828279 • Letter: U

Question

using excel

Exercise 2. (4 points)

Control Charts - When using control charts to monitor a process, why is it necessary to include an x chart and an R chart?

Why can't we use just one of those control charts?

Exercise 3. (8 Points)

Notation and Terminology - Consider process data consisting of the amounts of Coke (in oz) in randomly selected cans of regular Coke. The process is to be monitored with x and R charts based on samples of 50 cans randomly selected each day for 20 consecutive days of production. What are x and R charts, and what do x-bar-bar, R-bar, UCL, and LCL denote?

Monitoring Tablet Hardness. In Exercises 4-6, use the following information: A pharmaceutical manufacturer forms tablets by compressing a granular material that contains the active ingredients and various fillers. The hardness of the sample tablets a measured in kilograms for a pharmaceuticla product. The results are listed in the accompanying table.

Exercise 4. (12 points)

Tablet Hardness: Notation - Find the mean and range of each sample. After finding the value for the mean and range of each sample, find the values of x and R . Also find the values of LCL and UCL for an R chart, and find the values of LCL and UCL for an x chart.

Explanation / Answer

Exercise 2:

The x-bar and R chart is advantageous in below control charts situation:

1.The sample size is relatively small and s charts are typically used for larger sample sizes)

2.The sample size is constant

3.Humans must perform the calculations for the chart

The "chart" actually consists of a pair of charts: One to monitor the process standard deviation (as approximated by the sample moving range) and another to monitor the process mean.

If only one of them is used them the mean chart will not convey all the information unless we know the Range. Range as well as mean can uniquely defines the control process. So only one of them can not be used for control process monitoring.