binomial distribution
Hi,
I am looking for algorithm for binomial distribution in VB. I mean, I search VB code alternative the BINOMDISTR function. Thank you! Best Regards tony |
binomial distribution
I'm not aware of VBA having it's own version of that function, but you can
access the worksheet version with Application.WorksheetFunction.Binomdist(.......) "tony" wrote: Hi, I am looking for algorithm for binomial distribution in VB. I mean, I search VB code alternative the BINOMDISTR function. Thank you! Best Regards tony |
binomial distribution
Hi,
Thank you for the answer. But I want to use binomial distribution in MS Access. I know, that I can move the data from Access to Excel, and after to use the BINOMDIST function included in Excel. But this is very hard process and for this reason I am searching alternative (algorithm in VB) for binomial distribution. Best Regards tony JMB wrote: I'm not aware of VBA having it's own version of that function, but you can access the worksheet version with Application.WorksheetFunction.Binomdist(.......) "tony" wrote: Hi, I am looking for algorithm for binomial distribution in VB. I mean, I search VB code alternative the BINOMDISTR function. Thank you! Best Regards tony |
binomial distribution
If the sample size, n will be small, you can do it "hammer and tong" from the
formula shown in Help. otherwise, you will be hard pressed to find a better implementation in any language than is given in VBA in http://members.aol.com/iandjmsmith/Examples.xls Jerry " wrote: Hi, Thank you for the answer. But I want to use binomial distribution in MS Access. I know, that I can move the data from Access to Excel, and after to use the BINOMDIST function included in Excel. But this is very hard process and for this reason I am searching alternative (algorithm in VB) for binomial distribution. Best Regards tony JMB wrote: I'm not aware of VBA having it's own version of that function, but you can access the worksheet version with Application.WorksheetFunction.Binomdist(.......) "tony" wrote: Hi, I am looking for algorithm for binomial distribution in VB. I mean, I search VB code alternative the BINOMDISTR function. Thank you! Best Regards tony |
All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com