how do you find the mean on excel
- Type =AVERAGE(5, 87, 2, 6) without the quotation marks into a cell to display 25, the average of the four numbers. If the values are stored in column A, from A2 to A32, you can calculate the mean by typing the following into cell A33: =AVERAGE(A2:A32). Formulas for the median and mode use the same syntax. For example, type =MEDIAN(A2:A32) to calculate the median, and type =MODE(A2:A32) to calculate the mode for the same series of numbers.