The floor function takes a set of real numbers and returns whole numbers, without any fractions or decimals.  However, it is a good idea to know exactly how it works. So, what is the floor...

Finding the z score for a value in a data set helps us to see how many standard deviations that number is from the mean by “standardizing” the distribution so the mean is 0 and the standard...

Finding the percentile for a number in a data set helps us to get a sense of where the number falls in the distribution.  Microsoft Excel can find a given percentile for any set of values you...

Finding percentages helps us to understand how values are increasing or decreasing over time (among other things).  Microsoft Excel can find the percentages for any pair of values (numerator and...

Algebra. If you’re in high school or beyond, then you’ve certainly studied your fair share of algebra. A common question that students pose to teachers is, “when are we going to use algebra in...

Finding the quartiles for a set of numbers helps us to get a sense of how the data is spread out.  Microsoft Excel can find the quartiles (Q1, Q2, and Q3) for any set of values you choose as...