The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Welcome To The Old Cayman Cove Forums!
This thread is carried over and continued in the Current Elsmar Cove Forums


The New Elsmar Cove Forums   The New Elsmar Cove Forums
  Statistical Techniques and 6 Sigma
  Template for capability study

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Template for capability study
narfeldt
Forum Contributor

Posts: 12
From:Landskona, SkŚne, Sweden
Registered: May 2000

posted 07 June 2001 02:59 AM     Click Here to See the Profile for narfeldt   Click Here to Email narfeldt     Edit/Delete Message   Reply w/Quote
Where can I find a template (Excel) for capability studies?

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

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

IP: Logged

cygnusx1
Lurker (<10 Posts)

Posts: 2
From:United Kingdom
Registered: Jun 2001

posted 07 June 2001 04:57 PM     Click Here to See the Profile for cygnusx1   Click Here to Email cygnusx1     Edit/Delete Message   Reply w/Quote
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

IP: Logged

narfeldt
Forum Contributor

Posts: 12
From:Landskona, SkŚne, Sweden
Registered: May 2000

posted 08 June 2001 03:06 AM     Click Here to See the Profile for narfeldt   Click Here to Email narfeldt     Edit/Delete Message   Reply w/Quote
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

IP: Logged

cygnusx1
Lurker (<10 Posts)

Posts: 2
From:United Kingdom
Registered: Jun 2001

posted 08 June 2001 06:36 AM     Click Here to See the Profile for cygnusx1   Click Here to Email cygnusx1     Edit/Delete Message   Reply w/Quote
---Obsolete data Removed---

IP: Logged

Graeme
Forum Contributor

Posts: 30
From:Lilburn, GA, USA
Registered: Sep 2000

posted 11 June 2001 10:07 PM     Click Here to See the Profile for Graeme   Click Here to Email Graeme     Edit/Delete Message   Reply w/Quote
quote:
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
ASQ_Graeme@yahoo.com

IP: Logged

Ken K.
unregistered
posted 19 June 2001 08:41 AM           Edit/Delete Message   Reply w/Quote
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 (www.minitab.com, www.statgraphics.com, www.jmpdiscovery.com). If the downloads are too long just call them - I'm sure they'll send you a demo disk.

IP: Logged

Rick Goodson
Forum Wizard

Posts: 102
From:Wuakesha, Wisconsin, USA
Registered: Aug 2000

posted 19 June 2001 09:46 AM     Click Here to See the Profile for Rick Goodson   Click Here to Email Rick Goodson     Edit/Delete Message   Reply w/Quote
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

IP: Logged

Al Dyer
Forum Wizard

Posts: 622
From:Lapeer, MI USA
Registered: Oct 2000

posted 19 June 2001 06:09 PM     Click Here to See the Profile for Al Dyer   Click Here to Email Al Dyer     Edit/Delete Message   Reply w/Quote
quote:
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...

IP: Logged

Howard Atkins
Forum Wizard

Posts: 202
From:Israel
Registered:

posted 20 June 2001 06:00 AM     Click Here to See the Profile for Howard Atkins   Click Here to Email Howard Atkins     Edit/Delete Message   Reply w/Quote
|For simple studies download the Partcertall-6.06.xls from http://Elsmar.com/pdf_files/
This allows you to perform cpk analysis.

IP: Logged

venkat
Forum Contributor

Posts: 17
From:Chennai, tamilnadu, India
Registered: Jun 2001

posted 21 June 2001 09:20 AM     Click Here to See the Profile for venkat   Click Here to Email venkat     Edit/Delete Message   Reply w/Quote
Mr.Howard Atkins

I did download the fiel from Partcertall-6.06.xls from http://Elsmar.com/pdf_files/

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

kindly advise


IP: Logged

Howard Atkins
Forum Wizard

Posts: 202
From:Israel
Registered:

posted 22 June 2001 02:19 AM     Click Here to See the Profile for Howard Atkins   Click Here to Email Howard Atkins     Edit/Delete Message   Reply w/Quote
I posted this file and have downloaded to check.
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!

IP: Logged

All times are Eastern Standard Time (USA)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | The Elsmar Cove Home Page

Your Input Into These Forums Is Appreciated! Thanks!


Main Site Search
Y'All Come Back Now, Ya Hear?
Powered by FreeBSD!Made With A Mac!Powered by Apache!