Excel Array Formula Series #6: Statistics Bayes' Theorem

Description

Create an array formula for Bayes' Theorem in Statistics. See the Root (Prior) probability, Conditional Probability, Joint Probability and Posterior Probability. In thisseries see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.