| |
Exercise 3.2
Average High Temperature By City and Month.
| City |
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
SEP |
OCT |
NOV |
DEC |
| Asheville |
46 |
50 |
58 |
66 |
74 |
80 |
83 |
82 |
76 |
67 |
57 |
49 |
| Charlotte |
51 |
56 |
64 |
73 |
80 |
87 |
90 |
88 |
82 |
73 |
63 |
54 |
| Raleigh |
50 |
54 |
62 |
72 |
79 |
86 |
89 |
87 |
81 |
72 |
62 |
53 |
| Wilmington |
56 |
60 |
66 |
74 |
81 |
90 |
88 |
84 |
84 |
76 |
68 |
60 |
- Construct a line
graph using Excel to visualize this information.
- What city has the overall highest average high temperature in July?
- What city has the overall lowest average high temperature in March?
- What is the mean, median, and range for each city?
- Do you see a pattern in this data? If so, please describe.
Upon completion of this exercise, please show your results to your
teacher for approval.
|