Geography Help, creating graphs on excel
csudh2015Descriptive graphics lab
GEO 370
Due Tues. Feb. 24
Your task is to create five different graphs (4 pts. ea):
1. Histogram
2. Cumulative frequency
3. Frequency polygon
4. Time series
5. Scatterplot
For the first three graphs, use the provided Washington DC rainfall.xls dataset. You should perform your data classification using five equal intervals, not based on range. In pencil, explain your steps for the classification and the computation of cumulative frequency. (5 pts.)
For the latter two graphs, use the provided Washington Reagan Airport precip and temp data. The time series plot should be of temperature, with time plotted on the x-axis. For the scatterplot, similarly plot temperature on the y-axis.
All figures should have a title, labeled axes, and the data must be in conventional units (i.e., inches of precipitation, and degrees Fahrenheit).