Video summary
In this video tutorial, the presenter demonstrates how to utilize Excel's built-in statistical functions, specifically MAX, MIN, and AVERAGE, to analyze a set of academic grades. The speaker begins by explaining the process of calculating these values for a single column of data representing test scores, project grades, and final exams. To find the average, one simply types the equals sign followed by "average," highlights the entire range of cells from the first entry to the last, and presses enter. Similarly, using the MAX function allows users to instantly identify the highest score in that specific column, while the MIN function reveals the lowest score, providing a quick overview of performance distribution without manual calculation.
The tutorial then highlights a powerful efficiency feature where these calculated results can be easily replicated across multiple columns. After obtaining the average, maximum, and minimum for the first set of grades in column F, the user selects all three resulting cells and copies them. By pasting this selection into the adjacent columns, the formulas automatically adjust to reference the new data ranges, such as shifting from column F to G for the second test. This dynamic behavior ensures that each subsequent column calculates its own unique statistics based on its specific data set, streamlining the analysis of large datasets significantly.
Beyond the core functions demonstrated, the presenter notes that Excel offers a vast library of other tools suitable for various fields, including environmental engineering. The video briefly touches upon the formula bar and the insert function menu, which categorizes different types of formulas into groups like trigonometric, logical, text, financial, and statistical functions. While the focus remains on practical applications for counting numbers and analyzing grades, the speaker emphasizes that there are numerous additional functions available to users who need more complex calculations. Ultimately, the lesson concludes by reinforcing how these simple yet effective tools can quickly transform raw data into meaningful insights regarding maximums, minimums, and averages.
Read the full video transcript
In this video, we're going to show you
how to use uh the max and min properties
as well as average, I guess we've done
that, but um I have my test grade, my
project grade, my final grades. And if I
want to find out um
what the maximum was and minimum was on
each of these tests, projects, or even
the final grade, I come here to this
cell. So, now I'm in F14.
So, to get the average, I'm going to put
in plus
um average, open parentheses, and I can
um you know, type in this number to this
number, but essentially, I'm just going
to highlight all of these. So, it's
going to give me the average of F3 all
the way to F13.
And if I put that in, there's my average
of those grades. And so, I can do the
same thing with max. I can do plus max,
open parentheses,
highlight that entire column, so F3 to F
13, hit enter, and the maximum grade was
a 96 for my first test.
And then, I can do the same thing for
min,
plus min,
highlight all of these,
close that, and there is my minimum test
grade. So, the maximum test grade was a
96 on test one, the minimum was the
lowest grade was a 70, and the average
was an 88. And maybe for my average, I
want to take that and
um
we'll make it just one decimal place.
So, now the cool thing here is again, I
can take these three cells, all three of
the cells at once, copy,
and then I'm going to paste
into um the next four columns.
And if we look, this one now for test
two is taking the average of G3 through
G13 as opposed to F.
It's still taking the max of G3 to G13
and the min.
And the same thing for each of these
others. So, my um final grade the
average of the final grades is averaging
from J4 to J13. The maximum final grade
was a 95. And the minimum again is
taking it from G3 to G17. And if you
look up here in um
formulas, you can insert all different
types of functions. Um
you know, auto sums. So,
if you're looking for a formula,
um there's a bunch here. You know,
there's there's trig formulas, there's
logical formulas, um text, financial,
um you know, max, min, average. We can
count numbers. So, I'm just showing you
a couple of the ones that we're using in
environmental engineering, but there's
plenty, plenty more.