Explore BrainMass
Share

# Making an XBar Control Chart with Excel

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

CONTROL CHARTS
Assignment Overview
You have taken data from a production process in order to develop an Xbar control chart. You have 25 samples of data with 5 parts measured in each sample to get the Xbar and R (Range). Use this data shown in the table.
The Case 5 Excel file (same file in Background) contains the data:
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?
Provide a one page paper discussing the problem, what you did to solve it and what your specific recommendation or plan is for monitoring quality. Upload your paper into the Case 5 area and upload your Excel file into Additional Files.
Assignment Expectations
1. Answer questions with clarity and show the detailed steps for calculation if any. Turn in your answers by module due date.

See attachment for better table representation.

https://brainmass.com/statistics/statistical-figures/making-an-xbar-control-chart-with-excel-589463

#### Solution Preview

I have attached an Excel spreadsheet as well as an MS Word doc that together give you everything that ...

#### Solution Summary

This solution contains 25 samples of 5 observations that each are used to construct an X-bar control chart and then based on the initial X-bar chart a revised X-bar chart is made and 6 new samples are then plotted in the new, revised X-bar control chart to see if the production process is in control or not.

\$2.19

## X-Bar and R-Chart

A bank manager decides to study waiting times of customers for teller service at the noon lunch hour (noon to 1pm). He observes three customers to measure the time the customer enters the line to the time he or she reaches the teller window. He records this over several days.

Time in Minutes

Day Customer #1 Customer #2 Customer #3

1 7.2 8.4 7.9

2 5.6 8.7 3.3

3 5.5 7.3 3.2

4 4.4 8.0 5.4

5 9.7 4.6 4.8

6 8.3 8.9 9.1

Please draw the X-bar Chart and R-chart.

View Full Posting Details