Excel, Data, Data Analysis, Analytics.
finds the average. “A2:A126” is the location of the numbers. I use the formula =AVERAGE(A2:A126) to find the average salary. MEDIAN() MEDIAN() finds the median of a set of numbers. In the example below, I calculated the median for the cell range A101 through A113: =MEDIAN(A101:A113) “MEDIAN” says I