The University of Wisconsin- Milwaukee
Geography 247 - Quantitative Analysis in Geography
Lab2 - Fall 2008
In an Excel workbook named “geog247lab2” create four different worksheets named
“Histogram”, “Cumulative Frequency”, “Time series” and “Pie” to answer questions 1, 2, 3 and
4 respectively. Save it in the “Desktop” of your computer for further use.
Question1: Construct a categorical frequency distribution for the following people where A
= trust in everything they read, M = trust in most of what they read, H = trust in about one-
half of what they read, S = trust in a small portion of what they read. Construct a
histogram for this categorical frequency distribution.
M M M A H M S M H M
S M M A A A M M A M
M M H A A M H M H M
A M M M H M M M M M
Question 2: The number of calories per serving for selected ready-to-eat cereals is listed in
the following table. Construct a frequency distribution using 8 classes and then construct a
cumulative frequency polygon.
130 190 140 80 100 120 220 220 110 100
210 130 100 90 210 120 200 120 180 120
190 210 120 200 130 180 260 279 100 160
190 240 80 120 90 190 200 210 190 180
115 210 110 225 190 130 111 121 131 141
Question 3: Construct a time series graph for the following temperature (
0
F) data of city X.
Compare the two lines to see if there is any trend during the summer months.
Year
Jan Feb Mar
Apr May
Jun Jul Aug Sep Oct Nov Dec
1990 19 23 33 44 55 65 71 69 62 50 38 24
2000 25.1 24.5 34.1 45 54.6 30 35 36 62.1 51.2 38.1 25.1
Question 4: Construct a Pie chart for the following data of blood types of 25 students. Show
the percentage of each section of pie chart and then answer which blood type has the
highest percentage and what is the value.
Important: Remember to include chart Title, category values in X and Y axis,
category X axis labels wherever required.
