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
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.
Subscribe to:
Posts (Atom)