Index.match is an alternative to the traditional vlookup or hlookup. The formula differs in that it can return values in cells both vertically and horizontally as well not needing to be based on the left-most column of a spreadsheet like vlookup. Index-Match works by having Excel scan a table to find a specific cell based on a lookup value that you designate. In one of my examples I use the formula to select a student and a standard and Excel returns the score of that particular standard.
Normal Distribution is an important statistical measure because it allows you to easily work with large amounts of variables and model the observed frequency of events. In the example I use over 2000 ACT scores are analyzed to show that the majority of test takers fall within the standard normal distribution of scores. To put it in easy to understand terms, 68% of testers fall within the average range. In the video I show you how to calculate the data needed to created a normal distribution graph and explain the concept of standard deviation.