spc standard deviation charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a new user of excel and I need to create an s.p.c./standard deviation chart for a process but I have not got a clue as to how to setup or create this type of chart. I have not used formulas before either. Any help would be appreciated.
 
Felix -

To plot run chart data, you need two columns. The first is your X value
or category: date, run number, whatever. The second is the measurement.
Put a label at the top of the measurement column, but not at the top of
the X column. The blank cell helps Excel decide whether to use the first
column as categories. Select the range and run the chart wizard, and
make a Line Chart.

You will need to learn how to make formulas, but it shouldn't be hard
for a smart guy like yourself. Say your data is in columns B and C and
you want a mean in cell E5. Click in E5, type "=AVERAGE(" without the
quotes, select the range of measurements with the mouse (e.g., C3:C25),
then type ")" and press Enter. Other formulas you'd be interested in are
MIN, MAX, STDEV.

You're going to want to add horizontal lines and various labels. For the
lines, check out the techniques on this page:

http://peltiertech.com/Excel/Charts/AddLine.html

If you run into difficulties, post back. It's a lot to try to learn all
at once.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top