To find the median type this formula in C3. Arithmetic mean also referred to as average is probably the measure you are most familiar with. Also click on Insert function icon then manually write Median and search the formula.
MEDIAN A2A200 The mode is trickier because it is possible to have 2 or more numbers that tie for the mode.
This halfway point average is the Median of the data. In Excel Median and Mode are other types of measures of central tendency that can be used as alternatives or complements to the average. Enter the MODE function into the cell in which you wish to display the result. In Microsoft Excel the mean can be calculated by using one of the following functions.