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.
When working with data, particularly numerical data, the ability to sort your data in a variety of ways can help us analyse and compare your information with others.
If we wish to compare how quickly boys completed the questionnaire compared to girls we need to sort the data.
Let me show you how Excel can help us do this.
Firstly let’s select the data that we need to sort.
Click on the header cell Q time.
Hold the button down and move the cursor to the bottom right hand corner of the data .
Release the button. Click on the data menu and select sort.
A window called Sort will appear. In the first drop down window select sex. Ascending sorts the data into alphabetical order. I’ll select descending gas which means that the males will be listed before the females.
In the second window click Qtime Ascending. This will be useful for investigating the median.
Click OK and save your work.
Now that we have our data sorted into males and females in their respective question times, we can now start to analyse what this information is telling us and answer the question are boys faster than girls at completing the questionnaire?
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.