Average and spread
In a cell below the names, type ‘Sum’. In the cell below the heights, type ‘=SUM(cell of first height : cell of last height)’ Then press ‘ENTER’. The sum will appear in the cell.
Step 4
Leon Riana Jade Carl
Leon Riana Jade Carl
In a cell below the sum, type ‘Average’. In the next cell across, type ‘= cell of the sum / the number of members in your group)’ Then press ‘ENTER’. The average will appear in the cell.
Step 5
Leon Riana Jade Carl
Leon Riana Jade Carl
55
9781380050717__text.indb 55
28/04/2022 12:11
Made with FlippingBook Learn more on our blog