← Using a Computer, in Practice
Spreadsheets · 52 of 111
Find the average, highest and lowest
Expert guidance
Do this
With marks in B2 to B8, in LibreOffice Calc, Google Sheets or Excel:
=AVERAGE(B2:B8)gives the mean.=MAX(B2:B8)gives the highest.=MIN(B2:B8)gives the lowest.=COUNT(B2:B8)counts how many cells hold numbers.
These read only numbers. Leave a cell empty for a student who was absent, and type 0 only if the mark really was zero.
Why this way
One formula pattern unlocks hundreds of functions. Type = and the first letters, and the program offers a list. Expert guidance.
Do it today
Find your best and worst subjects with MAX and MIN. Three minutes.
Where these facts come from
- AVERAGE, Google Docs Editors Help.
- MAX, Google Docs Editors Help.
- COUNT, Google Docs Editors Help.
- Statistical Functions Part Four, LibreOffice Help.
General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.
