Exploring statistical functions

In Chapter 9, New Features, Filters, and Cleaning Data, of this book, we learned about using the COUNTIFS statistical function. A list of statistical functions can be found in the Excel library. Click the Formulas tab, then click on More Functions | Statistical to see all types available, as illustrated in the following screenshot:

Figure 12.23 – Statistical functions

We will now learn about a few more statistical functions.

In the next section, we will discuss the MEDIAN function.

Finding the middle ground

The MEDIAN function is used to locate the average of the two middle numbers in a range of cells. MEDIAN is like the 19 function argument options listed in a previous function in the Maths & Trig section—namely, AGGREGATE:

1. Open the Training Schedule.xlsx workbook. Make sure you are on the Median worksheet.
2. Click into cell C2, then type the following formula: =MEDIAN(.
3. Select the...