# Template for Capability Study

N

#### narfeldt

Where can I find a template (Excel) for capability studies?

------------------
/Best wish Narfeldt

[This message has been edited by narfeldt (edited 07 June 2001).]

C

#### cygnusx1

If you have a "standard" sample / sub-group size, it's fairly straight forward to create an excel template.

If you'd like to let me have further details of what you're looking for, I'm sure I can create one for you.

Cheers,
Don

N

#### narfeldt

My problem is how to get a graph with normal distrubution. The graph should illustrate a straight curve then the process is normal distrubated. I don't know what it's name are for this in your countries, but in sweden we call it normal distrubution paper.
------------------
Best wish Narfeldt

G

#### Graeme

Originally posted by narfeldt:
My problem is how to get a graph with normal distrubution. The graph should illustrate a straight curve then the process is normal distrubated. I don't know what it's name are for this in your countries, but in sweden we call it normal distrubution paper.

I have seen normal probability paper shown in several references, but I have never seen the paper itself. (The x axis is in sigma, and the y axis is in median rank. Each axis is scaled so that if an exact gaussian "normal" curve is plotted the result is a straight line.) (Does anyone know of a source?)

I have not seen a way to do that in Microsoft Excel - and I just checked a big book on formulas and macros again to be sure. Lots of histograms and curves, but no normal probability plots. This may be because Excel is optimized for general-purpose business applications and does not have many technical or statistical features.

On the occasions where I have needed to use this kind of graph, I have imported the data into a statistical analyis and graphics program. (I use StatMost; there are other good ones as well.) I would think that most statistical analysis programs have this kind of plot as a standard feature -- they are specialized for this kind of work. If you don't have such a program readily available I think it is a good idea to get one.

------------------
Graeme C. Payne
ASQ Certified Quality Engineer
[email protected]

K

#### Ken K.

Take the cost of messing around with templates (including checking their validity) and invest in a good statistical software package that does process capability analysis. MINITAB, StatGraphics, and JMP can do this.

I feel MINITAB has the best capability tools, StatGraphics next, and then JMP behind them. You can download free full-working demos of all of these by going to their respective websites:
https://www.minitab.com
https://www.statgraphics.com
https://www.jmpdiscovery.com

If the downloads are too long just call them - I'm sure they'll send you a demo disk.

R

#### Rick Goodson

Narfeldt & Graeme,

Contact TEAM (Techniacal and Engineering Aids for Management) in Tamworth New Hampshire, USA. They carry 100's of specialty graph papers including what we use to call Normal Probate paper or Normal Probability paper. Their telephone number is 603-323-8843.

Codex Book Company in Norwood Massachusetts use to carry a number of papers also. Their telephone number is 802-878-5570.

Hope this helps.

Rick

A

#### Al Dyer

Originally posted by narfeldt:
Where can I find a template (Excel) for capability studies?

A friend told me he downloaded and Excel add-on from the microsoft web site that addressed SPC. Might be worth a quick search.

ASD...

#### Howard Atkins

This allows you to perform cpk analysis.

------------------
Howard Atkins

V

#### venkat

Mr.Howard Atkins

But I get the message as : cannot be accessed. file may be read only or in read only location or the server may not be responding

#### Howard Atkins

When you open it you get a message as to macros. Enable them. Then you get a message as to read only. Say no, open as not read only.
If you have more problems e-mail me
Best luck

------------------
Howard Atkins