What is the average height of your class?
Who has the smallest hands?
Who has the biggest head?

 

Using spreadsheets to find out the answers

  1. Measure your classmates.  How tall are they?  How wide are their hands? (From the tip of their thumb to the tip of their little fingers) What is the circumference of their heads?

ALL measurements in ‘cm’ please.  

  1. Open a worksheet in Excel and call it MEASUREMENTS.
  2. Copy the following into your worksheet.

 

  1. Enter the data you have collected from your classmates.

    2. You are now going to use FUNCTIONS to help you answer the following questions about your classmates:

a)    Who is the tallest person in your group?

b)    Who has the smallest / largest hands in your group?

c)    Which person has the biggest / smallest head circumference in your group?

d)    What is the average height / hand size / head circumference of the class?

  The AVERAGE function can be used to work out the average of a range of       numbers.

  The MAX function can be used to find the biggest value.

  The MIN function can be used to find the smallest value.

     Here are some hints that may help you with your task.

                            =AVERAGE(B4:B9)           

=MIN(B4:B11)    

              =MAX(B4:B11)                 

You can use the function wizard or put the formulae in manually