Constructing a Frequency Distribution Graph

Subjects:
mathematics and all other subjects 
Objectives:
In this exercise you can learn
•	how to analyse the frequency distribution from a data set 
•	how to import data into Excel and how to create a chart from it 
Prerequisite:
•	Chapter 1: The Frequency Distribution
Materials:
Textfile with data: datafile_dice.txt
Time needed:
20 - 60 minutes, depending on your previous knowledge in working with Excell
Procedure:
1.	Open Excel
2.	Import the text file. If you have never done this before, read the tutorial “How to import text files into Excel” 
3.	Once you have created a spreadsheet in Excel, construct a frequency distribution from the data. If necessary use the tutorial “How to draw a histogram in Excel”
4.	Answer the following questions:
o	How many peaks does your data have?
o	How is the data distributed?
o	What is the range of values relative to their relative proportions?