Tutorial 3 – Part 2 – CREATION OF HISTOGRAMS
Question 1: What is a histogram and what does it do?
Question 2: What is standard deviation and how do you calculate it.
Question 3: Using the following data (which is available electronically on blackboard), create a histogram in excel and answer the questions below:
Data set – Student Heights
177.5 151.4 165.5 173.2 162.1
178.5 161.9 159.1 176.1 184.6
191.3 172.5 164.3 181 176.9
168 200 172.1 172.4 149.9
154.1 188.3 158.4 175.3 174.1
149.8 181.5 182.9 184.1 173.9
185.6 178.9 173.2 168.1 167.9
163.6 170.8 161.1 177.1 179.3
172.7 141.6 159.4 151.6 171.8
176.8 165.4 167.8 177.3 168.2
The following link may be useful:
http://support.microsoft.com/kb/214269
a. What is the mean average of the data?
b. What is the standard deviation of the data?
c. How many bins did you create and how was this calculated?
d. Produce a graph of your results.
Question 4. Produce a histogram using the same data but adding in the heights of 5 other students. Do the calculations manually and plot where your height falls within the data.Does this accurately represent the population?
Question 5. List 4 problems associated with using histograms to graphically represent data.
1.
2.
3.
4.
ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!