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.