"
Best Excel Tutorial
Search...
Search
Statistical process control
chart
!
In this lesson you will learn how to create statistical process
control chart.
First we are going to find the mean and standard deviation.
To find the mean click on the Formula tab, click on More
Function select Statistical and then Average from the
dropdown menu. Select cells B2 to B20 and press okay.
Click on the Formula tab, click on More Function select
Statistical and then STDEV.S from the dropdown menu.
Select cells B2 to B20 and press okay.
Select cell C1 and type "Mean (CL)" in it. Select C2 and
type "=I$1". Move your mouse to the bottom right of the cell
until a black plus sign appear. Drag the plus sign all the way
to cell C20 to copy the mean.
Select cell D1 and type "UCL" in it. Select D2 and type
"=I$1+ (I$2*3)". Move your mouse to the bottom right of the
cell until a black plus sign appear. Drag the plus sign all the
way to cell D20 to copy the mean.
Note: UCL= upper control limit and is mean+3 times the
standard deviation
Select cell D1 and type "LCL" in it. Select E2 and type
"=I$1+ (I$2*3)". Move your mouse to the bottom right of the
cell until a black plus sign appear. Drag the plus sign all the
way to cell E20 to copy the mean.
Note: LCL= lower control limit and is mean-3 times the
standard deviation
SELECT Sample Measures, Mean(CL), LCL and UCL.
Click on Insert tab,click on Line Chart and then Click on
Line.
You have created your chart. Resize it. Remove the small
black lines by double clicking on them and pressing Delete.
That’s it, you're done.
This is what your final chart will look like.
SPONSORED SEARCHES
process control excel
excel spc chart
control chart software
introduction statistical quality control
best excel pivot table tutorial
< Prev Next >
Popular Lessons
How to calculate variance in Excel?
How to remove green triangles from cells?
How to calculate logarithms and inverse logarithms in
Excel?
How to calculate CAGR?
3 axis chart
COUNTIF function
How to calculate ROI?
How to use the integral function?
Toggle button
BCG Matrix
New Lessons
Tips and Tricks
How to quickly go to the last row?
How to import xlam?
Charts
How to create a quarterly chart in Excel?
Amortization schedule template
How to put a target line on an Excel chart?
How to Sort by Row?
How to Break Chart’s column?
Backwards Vlookup
SPONSORED SEARCHES
process control excel
control chart software
introduction statistical quality control
best excel pivot table tutorial
organization chart in excel sample
Sponsored Links
Spreadsheet Validation - 21 CFR
Part 11 Compliance
Promoted by [Link]
Best Excel Tutorial - complex and absolutely free tutorial of Excel.
Best place to learn Excel online.
Copyright © 2012-2020 Luke K About Contact Privacy Policy