Advanced Excel - Statistical functions & formulae

=Median(Range) Mean. There is a built in Excel function that returns the mean as its value =Average(Range) It is often useful to put the result of this function into a suitably named cell in a spreadsheet. Measures of Dispersion. Range. The range of a sample is the largest score minus the smallest score. This can be calculated using the Excel ... ................
................