Explore BrainMass
Share

# Control Charts: Plotting and Calculating

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Can you please explain what I need to do to complete this? I do not understand how to plot the figures within the spreadsheet or calculate them.

Sample 1 2 3 4 5 Xbar R
1 1.55 1.58 1.64 1.67 1.50 1.588 0.17
2 1.52 1.62 1.71 1.74 1.60
3 1.47 1.57 1.44 1.56 1.42
4 1.67 1.73 1.76 1.64 1.64
5 1.46 1.52 1.60 1.41 1.43
6 1.44 1.50 1.53 1.37 1.41
7 1.55 1.64 1.70 1.53 1.58
8 1.54 1.72 1.66 1.52 1.57
9 1.48 1.60 1.57 1.46 1.51
10 1.43 1.55 1.52 1.43 1.46
11 1.40 1.52 1.56 1.38 1.43
12 1.60 1.44 1.55 1.58 1.49
13 1.48 1.46 1.57 1.60 1.65
14 1.56 1.54 1.65 1.68 1.59
15 1.42 1.39 1.51 1.54 1.45
16 1.70 1.71 1.61 1.73 1.64
17 1.51 1.35 1.37 1.49 1.40
18 1.41 1.32 1.44 1.32 1.35
19 1.69 1.58 1.75 1.60 1.63
20 1.67 1.56 1.79 1.58 1.61
21 1.65 1.57 1.68 1.56 1.59
22 1.52 1.46 1.55 1.45 1.46
23 1.51 1.41 1.54 1.42 1.45
24 1.62 1.51 1.69 1.53 1.56
25 1.57 1.46 1.60 1.47 1.51

1. First plot the data using Excel.

2. Then determine the UCL and LCL. Do any of the data points need to be thrown out? If so, then recalculate the UCL and LCL.

3. Then you begin to plot results on this chart. Here are the next 6 samples of data (sample size = 5).

Sample # 1 2 3 4 5 Xbar
26 1.51 1.35 1.37 1.49 1.40
27 1.41 1.32 1.44 1.32 1.35
28 1.69 1.58 1.72 1.60 1.63
29 1.67 1.56 1.70 1.58 1.61
30 1.65 1.57 1.68 1.56 1.59
31 1.52 1.46 1.55 1.45 1.46

Plot these on the control chart.

4. Is the process in control?

Please explain in depth how to plot and calculate so that I can apply to future assignments. Thank you.

https://brainmass.com/statistics/statistical-figures/control-charts-plotting-and-calculating-545588
\$2.19

## Control Charts: Upper and Lower Control Limits

Please see the attached file for the fully formatted problems.

Special Care, Inc. is a large, long term care facility whose new management has hired you as the quality management/risk management coordinator. There are many problems that they would like you to tackle, including staffing issues, an increase in patient falls, and an upcoming state survey.

1) Run Charts: You are going to tackle the staffing problem and have decided to review the call in data for the last year. You have been given the following data:

Month Hours Lost
Jan 375
Feb 300
Mar 275
Apr 500
May 525
June 490
Month Hours Lost
July 495
Aug 550
Sept 425
Oct 450
Nov 460
Dec 350

a. Use excel or another database to chart the information.
b. On the chart, plot (draw a line) the median number of call-ins.
c. Describe what the pattern looks like and what conclusions you might draw from it. (1 paragraph) As a manager what would be your process for PDSA?

CONTROL CHART

2. You have calculated the upper and lower control limits on the run chart example. The upper limit is calculated at 575 and the lower at 250.

a. Draw the upper and lower control limits on the chart.
b. Compare the plotted points and the lines drawn for the upper and lower control limits. Determine if all the plotted points fall within the upper and lower control limits.
c. Determine if the variation results from common causes or special causes.

THESE ARE THE REMINDERS FOR HOW TO CONSTRUCT CHARTS

RUN/TREND CHART:
A run/trend chart is a picture of data over a period of time.

How to construct a run chart:
1) Draw a chart with an X axis and a Y axis. The X axis is a horizontal line that represents the time interval and the Y axis is a vertical line that represents the data collected.
2) Plot the data - each number - for each time interval.
3) Determine the mean by adding the data together and dividing by the number of data points. Plot the mean as a line on the chart.
4) Connect the points to visualize the pattern.

How to construct a control chart:

1) Calculate the upper (UCL) and lower (LCL) control limits using the formula calculation (not included in this exercise).
2) Draw a straight line at the level of the numbers derived from the UCL and LCL calculations.
3) Compare UCL and LCL against the points plotted.

View Full Posting Details