Tuesday, November 26, 2019
Use the BINOM.DIST.RANGE Function for Hypothesis Testing
If you're performing hypothesis testing, you're probably familiar with the binomial distribution formula. And if you're using Excel to perform binomial distribution, you'll find a bunch of different Binomial functions. In this video, we'll cover BINOM.DIST.RANGE and how it can be used for hypothesis testing. via IFTTT
Tuesday, November 19, 2019
Use the Funnel Chart Feature
If you wanted to create a sales funnel chart in Excel (and if you've got Excel Office 365 or Excel 2019) there is a chart option to create a funnel chart. And it is pretty easy to create. If you don't have those version of Excel, you can still create a funnel chart. Just see my other video at https://www.youtube.com/watch?v=kxMsZUIOoTc
Tuesday, November 12, 2019
Calculate a Confidence Interval in Excel
Whenever you see statements like "we are confident that the average is between x and y number" ever wonder what that means and how it's figured out? Well here's a short video that touches on the topic of confidence intervals and how it can be calculated in Excel.
Subscribe to:
Posts (Atom)