Exploring Mean, Median, and Mode with a Spreadsheet



Exploring Mean, Median, and Mode with a Spreadsheet

Teacher plans

This activity is intended to be an introduction to mean, median, and mode, but can be used as a follow-up.  It is helpful if students have some prior knowledge of spreadsheets, but it is not necessary.

Objectives:

|[p|To introduce students to mean, median, mode, maximum and minimum statistical descriptions |

|ic| |

|] | |

|[p|To make predictions and analyze results |

|ic| |

|] | |

|[p|To represent data appropriately |

|ic| |

|] | |

|[p|To enter data in spreadsheet and enter various formulas |

|ic| |

|] | |

|[p|To use fill right commands |

|ic| |

|] | |

Materials needed:

|[p|Computers with spreadsheet program |

|ic| |

|] | |

|[p| |

|ic| |

|] | |

|[p|Measuring tools |

|ic| |

|] | |

|[p|Copies of cm grid paper |

|ic| |

|] | |

Directions:

1. To introduce the activities, have the students consider the following problem situation:

An exchange student from Senegal will soon be joining out class.  Before she travels to the United States, she would like to know more about the students she will be meeting.  Unfortunately, she does not read English very well and will not have time to translate letter from each student in the class.  Instead, she would like to receive one letter that describes the typical or 'average' person in the class.

2. Allow students to brainstorm what types of information they should include and how they might summarize the information.  Ask students to discuss meanings for the term average.

3. In small groups with about four per group, students should generate written lists of categories describing the kinds of information they would like to gather from their classmates.  They should also describe possible methods of collecting the information, such as survey or by measuring.

4. Each group should then share it's list with the class which can reach consensus on which categories will be included and how the information should be gathered.

5. Divide the categories up so that each group is responsible for collecting numerical as well as nonnumeric information.  Try to assign each group at least one category that involves measuring various attributes, such as height, arm span, hand area, etc.  (To measure area of hands and/or feet, students can trace them on centimeter grid paper and count the squares to determine area.)  For categories requiring measurement, assign two or three groups to share data collection for quicker and more efficient gathering.

6. Allow students to collect all of their data before they begin to enter it into the computer.

7. You can prepare a spreadsheet template with the headings of the categories the class has chosen and the students names.  This would save time.  But you can also have the students to set this up themselves (remind them to include their units of measure in the column heading, but not in the columns themselves). Have students enter their data in each of the columns.

8. To have the computer figure the averages at the bottom of each column the students will need to enter the appropriate formula in the first column and then fill across.  

|Type of Average |Formula to Enter |

|Minimum |=MINIMUM(B3:B14)   |

|Maximum |=MAXIMUM(B3:B14) |

|Mean |=AVERAGE(B3:B14) |

|Median |=MEDIAN(B3:B14) |

|Mode |=MODE(B3:B14) |

|***The cells in the parentheses are the range for that column.  You may type them in or highlight the range after typing the first parenthesis.  Remember to |

|hit after typing in the formula. |

9. To fill the formulas across the row, select the first cell where the formula is located, move the cursor over the black square in the lower right hand corner of the cell.  When the cursor turns into a skinny black plus sign, you can click and drag to the right.  This copies the contents of that cell over.  When it copies it changes the formula to fit the appropriate column.

10. Once students have entered all their data, have them save the file and then analyze their data and answer these follow-up questions or questions you come up with yourself.  Experimentation and exploration will help students build relational understanding of key statistical ideas.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download