How do I calculate UPPER and LOWER LIMITS in Excel?

Question

I have to do a Statistics lab and I need to calculate the upper and lower limit in Excel. There is a total of 43 data entries and the instructions of the lab says "the only number you should be typing in is 1.5 for the UL & LL formulas."

The data is as follows:
13
4
17
7
8
11
22
10
9
9
5
13
20
9
9
9
6
14
13
11
12
12
12
10
9
9
7
8
17
8
13
11
11
23
14
8
10
11
11
13
13
10
14

Answer 1

Mean = 11; StdDev= 3.97; Upper Limit = 23.20; and Lower Limit = -0.64



1 - Find the mean of your data set by adding all the data points and dividing by the number of data points. As an example, take the data set: 2, 3, 5, 5, 7. The mean is 2+2+3+5+5+7 / 6 = 24 / 6 = 4.



2 - Subtract the mean from each data point and square the result. Continuing the example: (2-4)^2, (2-4)^2, (3-4)^2, (5-4)^2, (5-4)^2, (7-4)^2 = (-2)^2, (-2)^2, (-1)^2, (1)^2, (1)^2, (3)^2 = 4, 4, 1, 1, 1, 9.



3 - Find the mean of the result. Again, from the example: 4 + 4 + 1 + 1 + 1 + 9 = 20 / 6 = 3.33.



4 - Take the square root of that mean to get the standard deviation. The standard deviation of the example is sqrt(3.33) = 1.83.



5 - Multiply the standard deviation by 3. From the example = 1.83 x 3 = 5.48.



6 - Add the mean of the original data set to the result in step 5. This is the upper control limit. The upper control limit for the example data set is 4 + 5.48 = 9.48.



7 - Subtract the result of Step 5 from the mean of the original data set (Step 1) to get the lower control limit. The lower control limit of the example data set is 4 - 5.48 = -1.48.



Hint: Use the "Sum" divided by "Count" features of Excel to get the mean.

Answer 2

Upper Control Limit

Answer 3

This Site Might Help You.



RE:

How do I calculate UPPER and LOWER LIMITS in Excel?

I have to do a Statistics lab and I need to calculate the upper and lower limit in Excel. There is a total of 43 data entries and the instructions of the lab says "the only number you should be typing in is 1.5 for the UL & LL formulas."



The data is as...

Answer 4

A control chart is a chart used to monitor the quality of a process. The upper and lower control limits are two horizontal lines drawn on the chart. If data points fall outside of these lines, it indicates that it is statistically likely there is a problem with the process. These lines are usually placed three standard deviations from the mean, so there is a 99.73 percent probability that a data point will be within those limits. To calculate the control limits, you will need to first find the mean and standard deviations of your data set. Then you will calculate the upper and lower control limits.