Excel Formulas and Functions - Whitman College

The range of a sample is the largest score minus the smallest score. This can be calculated using the Excel Formula =(Max(A1:A10)-(Min(A1:A10) Variance. The variance in a population is calculated as follows. We won’t build this equation ourselves in Excel during this session but I give it here so that you can try it in your own time. ................
................