# Control Charts: Plotting and Calculating

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.

© BrainMass Inc. brainmass.com October 25, 2018, 8:35 am ad1c9bdddfhttps://brainmass.com/statistics/statistical-figures/control-charts-plotting-and-calculating-545588

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.