<

Binomial Distribution

Posted on
3,432 Points
332 Views
1 Endorsement
Last Modified:
Published
Experience Level: Beginner
7:31
Ed Covney
Retired USN in '88. Then IT & s/w dev. Fully retired in 2015. Now practicing math skills, long neglected, and learning VBA (to demo math).
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac Newton by several years in publishing his work. Actually, it was Jacob's brother Johann Bernoulli (1667-1748), an academic who made sense of Leibniz's notes and was primarily responsible for getting Leibniz's "Calculus" published. In fact, it was Johann that coined the term "Integral" (Leibniz called it sums), and may have even been responsible for the calculus symbology. If the name Bernoulli sounds familiar and you're an engineer, it's probably Johann's son Daniel Bernoulli you recall.

For over 300 years, mathematicians and statisticians have used the Binomial Distribution to group and model real world observations and is the basis of many other statistical distributions.

Here are my spreadsheets if you want to take a look at them:
https://filedb.experts-exchange.com/incoming/2017/03_w13/1153243/N-16-BBD.xlsm
https://filedb.experts-exchange.com/incoming/2017/03_w13/1153244/N-35-BBD.xlsm
https://filedb.experts-exchange.com/incoming/2017/03_w13/1153245/N-40-BBD.xlsm
https://filedb.experts-exchange.com/incoming/2017/03_w13/1153246/N-64-BBD.xlsm
1
Author:Ed Covney
0 Comments
Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Storing hashed or encrypted data.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month