Calculating the average (mean)

What is it and how do we calculate it?

Numeracy Focus Reasoning and generalising about numbers and shapes.
 Learning Objectives · To learn how to use a spreadsheet to enter a formula.
· To understand the use of simple algebra.
Resources If you have a large display (not essential), download the demonstration page.
Make copies of the activity sheet for this lesson. Calculators are needed.
Key vocabulary Average (mean), median
Revision /
oral
What is meant by "average"? Children may say, "The middle," "Somewhere near the middle amount." Discuss these ideas to ascertain understanding.
Main activity

Invite three children of varying heights to stand in front of the board. Who is the middle? Bring another child into the line and repeat the question. Pupils are likely to say that there is no middle one, as there are now four children!

Return to the three original children. Measure and mark their heights on the board. Ask, "Is the middle person's height exactly half way between the tallest and shortest?" The pupils should realise that the middle person's height is not the middle amount. Explain, "The person in the middle is the median." Average and mean are the same.The median may be different.

Add all the heights and share them equally. In other words, find the total and divide by the number of people. Compare the result to the median height.

Repeat the exercise using 6 children.Give four children a handful of cubes. As a whole class, work out the total and average amount. Set out the data on a spreadsheet:



Check that children understand that, to find the mean, we divide the total number of cubes by the number of children. The formula in D5 may be entered as: =C5/4

Give out the task sheets to do Part 1.

Bring the class together and review the task. Write the first example on the board or demonstration page, or enter directly into the spreadsheet:



Big difference!!! We are now going to work out the mean in one step - i.e. without working out the total first.

What is the formula in E1? Pupils may suggest,
=A1+B1+C1+D1/4
Try this. Is it the result you expected? What has the computer done? Try:
=(A1+B1+C1+D1)/4
Is this what you expected? Why are the brackets needed? Remember, you have to find the total first.

Discuss another example, then ask the pupils to do the second exercise on the task sheet.

Support Encourage pupils to think about the order of the result. "Do you think the total will be nearer ten or twenty?" "Do you think the mean will be nearer five than ten?" Give further practice in calculating the total, then the mean, of three, then four, values.
Extension Expect proper calculations to help able pupils appreciate the power and speed of a computer. Use calculators to check. Fill in the blank rows on the spreadsheets with further examples.
Plenary

Quick fire examples to check pupils have understood the distinction between median and mean, and know how to calculate the latter. "Noon temperatures on Monday, Tuesday and Wednesday were 10, 15 and 11 degrees Celsius. Which is the median? What is the mean?"

Arrange for groups to enter their work on the computer before the next lesson.

In the next lesson, pupils will collect data and use the spreadsheet to calculate averages. "How many cubes can you grasp in one hand? What is your hand span? What is the area of your hand?" Can they think of similar questions?

 
   
Kent County Council logo. Link to web site
spacer

[ Contact Us ]

© Kent County Council 2004 | Site Template Designed by EIS, Maidstone
Kent NGfL, Oxford Road, Maidstone, ME15 8AW. Tel: 01622 672779 Fax: 01622 663591