New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create the entire binomial distribution given a pi value, number of trials and a complicating factor.
It’s Black Friday week on WonderHowTo! Don’t miss out on all of the big sales in the Gadget Hacks and Null Byte shops. And if you’ve been wanting to take some classes without going into debt, check out our best deals on online courses for a variety of skill sets. Don’t miss out on these huge discounts: