In some mathematical question, we were asked to find the mean, the mode and also median of data sets. Mean sets the average value of all data and as for mode, it is to count the most frequent data shown. Median is the center of the data. Before we continue with applying AVERAGE, MODE and MEDIAN functions, create the following data table.
AVERAGE
AVERAGE Function return the average (arithmetic mean) of its argument, which can be numbers or names, array or references that contain numbers. To use the function, type in formula = AVERAGE (number1, number2, …)
Press Enter and the result will be displayed. Do the same for other subjects.
MODE
MODE Function return the most frequently occurring, or repetitive, value in an array or range of data. To use the function, type in formula = MODE (number1, number2, …)
Press Enter and the result will be displayed. Do the same for other subjects.
Median
MEDIAN Function return the median, or the number in the middle of the set of given numbers. To use the function, type in formula = MEDIAN (number1, number2, …)
Press Enter and the result will be displayed. Do the same for other subjects.