Wednesday, February 5, 2020

Calculate Z Scores in Excel




What is a Z-score? Well it helps you measure how far a value is from the mean (or average) of a group of values. It quickly helps you find out if the number is an outlier or within the "normal" confines of a group of values. This video will show you how to use the STANDARDIZE function as well as the formula to figure out a z-score

Tuesday, February 4, 2020

Calculate a One Way ANOVA in Excel

If you're trying to check if survey data for different group (two or more) are truly random and nothing is suspect about them, you're probably going to use  ANOVA (Analysis of variance) to test.   This video will cover how to use Excel to perform a one way ANOVA test the easy way (using the Analysis Toolpack) and the other way in a more manual but descriptive approach.

Wednesday, January 29, 2020

Approximate Lookup with INDEX & MATCH Functions


If you wanted to do a lookup that wasn't an exact match, you're probably looking to do an approximate match lookup. There are different functions that can perform a closest match, partial match or even a fuzzy match. One of the function you can use is the INDEX & MATCH combination to find the closest value to a looked up value. This video will cover a simple example of looking up a salesperson sales quantity to figure out what kind of commision to be given.