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
Google
  Web Elsmar.com
*Please be aware that SOME RECENT forum threads may not yet be indexed by Google.

View Full Version : Can someone help me create a POISSON ACUMULATIVE PROBABILITY table in Excel?


Maolopez
25th May 2005, 07:59 PM
Hello there, can someone please help me to create a POISSON ACUMULATIVE PROBABILITY table using excel?. Like the one in the book sampling inspection tables (New York: John Wiley & Son, Inc. 1994)?.

Thanks.

Or please send me tables for SPC in excel.

Tim Folkerts
25th May 2005, 08:37 PM
I'm not sure if this is exactly what you are looking for, but here is a spreadsheet I put together that allows you to input the sample size and the defect rate and determine:
* the probabilty of a specific number of defects
* the cumulative probablity of at most a given number of defects.

It has separate sheets for Binimial, Poisson, and Hypergeometric distributions. Hopefully it will allow you to generate the numbers you want.

TIm F