These video tutorials will familiarise you with a range of ABS products that are useful in the classroom. You can view video transcripts by clicking on the triangle labelled 'Video Transcripts' below the video description.
COUNTIF is a function in Excel that allows you to quickly add the amount of times like data appears in your data sample. Let me show you how you can use COUNTIF to complete the summary table.
Firstly place your cursor on the cell next to the first eye colour on your summary table. Go to Insert and then select Function. In the search box, type in the term COUNTIF. And then Press go (OK).
A new screen should appear called Function Arguments, asking for a Range and Criteria. To select the Range left mouse click the first piece of eye colour data and whilst holding down the left mouse button, drag your cursor to the last piece of data. This is now your Data Range. Click in the Criteria box and select the eye colour you wish to add the number of, from the summary table. In this case it will be brown. Click OK.
You should now see the number of brown eyed students in your data sample. Repeat these steps for each of the eye colours on your summary table. This is a useful function to know about, especially when you have larger data sets that you need to summarise.
Unless otherwise noted, content on this website is licensed under a Creative Commons Attribution 2.5 Australia Licence together with any terms, conditions and exclusions as set out in the website Copyright notice. For permission to do anything beyond the scope of this licence and copyright terms contact us.