Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Spreadsheet Basics!
You have completed Spreadsheet Basics!
Preview
Learn how to use the AVERAGE and MEDIAN functions to compute the average and median values for a selection of spreadsheet cells.
Example Files
- you can continue to use the spreadsheet from the last video, or
- open a copy of this spreadsheet to catch up on this video
Reference
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
spreadsheets let us answer
in less than a second.
0:00
In this example spreadsheet, we're looking
at a lot of different retail transactions.
0:00
And say we want to understand,
what the average price of the items
0:04
we are selling is.
0:07
You might do this to figure out if
you have opportunities to change your
0:08
pricing strategies, for example.
0:11
To calculate the average price, we can use
the average function which is similar to
0:13
the sum function we introduced
in an earlier video.
0:17
In the average case, the syntax is
very simple and similar to sum.
0:20
Let's scroll down to where
we had the sum function.
0:24
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up