Copy the data from the picture into a new Excel Spreadsheet
How to find the Mean using Excel
1) Type 'Mean' (where the picture says 'Average') into an empty box underneath the 'Students' column 2) Click on the neighbouring blank box 3) Right click. This will bring up a menu 4) Click on 'Insert Function' 5) Scroll down to find 'Average' 6) Click 'Average' 7) Select all of the 'Marks' data (all of the numbers in the 'Marks' column) 8) Click the 'Enter' key
How to find the Median using Excel
1) Type 'Median' into an empty box underneath the mean you just calculated 2) Click on the neighbouring blank box 3) Right click. This will bring up a menu 4) Click on 'Insert Function' 5) Scroll down to find 'Median' 6) Click 'Median' 7) Select all of the 'Marks' data (all of the numbers in the 'Marks' column) 8) Click the 'Enter' key
How to find the Mode using Excel
** Remember you can have 1 or 2 modes! 1) Type 'Mode' into an empty box underneath the median you just calculated 2) Click on 2 vertically neighbouring blank boxes 3) Right click. This will bring up a menu 4) Click on 'Insert Function' 5) Scroll down to find 'Mode.multi' 6) Click 'Mode.multi' 7) Select all of the 'Marks' data (all of the numbers in the 'Marks' column) 8) Hold down the 'Shift' and 'Control' key, then click the 'Enter' key (all keys should be clicked at the same time)
How to find the Range using Excel
1) Type 'Range' into an empty box underneath the mean you just calculated 2) Click on the neighbouring blank box 3) Right click. This will bring up a menu 4) Click on 'Insert Function' 5) Scroll down to find 'Max-Min' 6) Click 'Max-Min' 7) Select all of the 'Marks' data (all of the numbers in the 'Marks' column) 8) Click the 'Enter' key
Is the Mean, Mode, Median a relevant statistic?
What is the most popular pet? (numerical discrete)
Are Year 7 Boys taller than Girls? (numerical continuous)
How do students travel to school? (categorical nominal)
What is the number of children per household? (numerical discrete)
How often do Math students eat pizza? (numerical discrete)
Writing a Conclusion
Do your results agree with your question? What does the data show?