Statistics expert - cumulative binomial stuff

roscoe

Well-known Member
Joined
Jun 4, 2002
Messages
1,041
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
My job requires me to establish the appropriate sample size during very expensive flight testing (i.e. can't afford to do more testing than the minimum required to establish the appropriate confidence). I have a nomograph that was given to me that we use to calculate the right value given confidence and demonstrated reliability (i.e. results). The nomograph can be found at: https://acc.dau.mil/docs/dtepi/pns/doc/nomogr/bdi.pdf.

Assuming we want to show that we have 80% confidence (right axis) that we'll succeed 80% of the time (left axis, also called reliability), I connect those values on each side with a straight edge and the chart shows that with zero failures (upper right boundary) we need 7 trials. If we have one failure (upper left boundary) the chart shows that we need 12 trials (11 successes). I was provided a formula that defines the zero failure curve [n=Log (1-confidence)/Log (reliability)]...What I need is a more generic equation or excel function that will generate these curves with failures not equal to zero.

Any statistics experts out there that can help me?

Thanks
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Last edited:
Upvote 0
Nope. We've been doing this for years because it's "the way we've always done it". I hate that and want to be able to support the numbers.

As for the pages you reference, those are over my head (I've forwarded them to the prob/stats expert in the office.
 
Upvote 0

Forum statistics

Threads
1,211,748
Messages
6,103,686
Members
447,877
Latest member
OrangeJuice

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top