-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
binomdist
-
S
Determine errors that would have been encountered if required confidence for sample size was met (when it wasn't)
In my case, I need to perform an accuracy audit where my required accuracy is 99.90% and my required confidence level is 90.00%. I'm stumped on how to assign penalties in a case where the measured accuracy passes the requirement, but the required confidence fails. I know that if I have a...- SerenityNetworks
- Thread
- accuracy binomdist confidence
- Replies: 4
- Forum: Excel Questions
-
B
Statistics/BINOMDIST/failure rates??
Greetings Power Users! XP, Excel 2003 with stats ad in Yes, this is an assignment AND I have the answers BUT I want to know how to get there (not wating your time). Taking online statistics and everyone in class using calculators, I am the only Excel fan. I approach problem as BINOMDIST...- brokerbrian
- Thread
- binomdist formula probability statistics
- Replies: 3
- Forum: Excel Questions
-
L
Excel Statistical Functions
Hi all, The answer I know is 312 x 311 x 310 x 309 x 308 = 2,862,766,146,240 = 2.86277E+12. The arguments are 312 and 5. Using the notation myfunction(x,y) the result is (x)*(x-1)*(x-2)*(x-3)*(x-4)*..etc...*(x-(y+1)) Another example, myfunction(17,10) = 70572902400...- leonuk10
- Thread
- binomdist fact functions spreadsheet statistic
- Replies: 7
- Forum: Excel Questions
