Instructor: Okay, on to Section 4: Statistical Functions.
This section's all about operations
that you perform on numerical data.
So we're gonna start with our basic stats functions.
These are things like max, min, average count, sum,
standard deviation, variance, percentiles,
basic stuff there, all very straightforward.
Then we're gonna go into some more interesting ones,
SMALL and LARGE functions,
the RANK and the PERCENTRANK functions.
We'll talk about how to build random number generators
with RAND and RANDBETWEEN.
I'll go into SUMPRODUCT,
which is a pretty powerful calculation tool.
Talk COUNTIF, SUMIF, and AVERAGEIF.
And then finish up with COUNTIFS, SUMIFS, and AVERAGEIFS,
which basically do the same thing
except they allow for additional criteria.
And then last but not least,
we'll build out a demo showing how to build a dashboard
just using SUMIF and COUNTIFS functions.
So two files for download as usual.
We've got our PDF and the Excel file
called Section 4: Statistical Functions.
So go ahead and open those up, and let's dive in.