The Weather in Columbus

The graphs and charts are created from the data collected on Columbus, OH weather, between 01/01/2010 and 12/31/2018. The first graphs this data can be used for are box plot graphs that give you a lot of important information. There are two different useful box plots for this data, one is minimum daily temperatures and the other gives you the maximum daily temperatures. They are useful because they help show any outliers that might be hiding within the data set. It also helps show the outliers in either daily temperatures set the maximum or minimum daily temperature. By having a dot for every piece of temperature recorded in each data set, you can find the outliers by looking for dots outside of the given rang of each month. The box plots can show the mean of each month in both the maximum and minimum. Thus, this can be useful for seeing which month on average has the highest and lowest minimums and maximums.

SQL Chart

This chart is helpful because it is made by SQL which is used for storing and processing information in a relational database. In simply terms it’s used to turn data into charts. Some questions you can answer with this chart are the temperature in month one compare to the average max temp in month 12, or what month has the highest difference in average max temperature and average medium temperature. Both of these qustions can be answered using this chart.

MONTH AverageMaxTemp StandardDeviationMaxTemp AverageMinTemp StandardDeviationMinTemp
1 36.11111 12.800567 21.10394 12.359714
2 40.11811 13.896065 23.87795 12.246677
3 51.79570 12.805596 33.12186 10.438904
4 65.07037 10.477745 43.18519 9.202541
5 76.02509 10.005542 55.79928 8.999752
6 82.95185 6.494600 63.20000 6.006564
7 85.70968 5.862785 66.78853 5.158817
8 84.57706 4.950871 64.96416 5.244950
9 78.35556 8.496198 58.19259 7.679932
10 65.91398 10.970847 46.44444 8.877441
11 52.36296 11.180910 34.74074 8.867017
12 42.18638 11.473508 29.16487 9.947057