REPORT 2 FINAL

Question 1: BOX PLOTS

Maximum Temperature

Minimum Temperature

The Maximum and minimum daily temperature box plots illustrate the seasonal trends and range throughout the year. Hottest and most consistent months, such as June to August, depict the most stable and highest temperatures, appear to have higher medians and narrower ranges, signifying consistent heat. Spring and autumn months such as March, April, and October depict larger ranges, signifying the larger day to day temperature changes. The winter seasons have the lowest medians for both the maximum and minimum temperatures, but are not as variable, implying a more stable cold.

Question 2: SQL TABLE

Average Monthly Temperatures Summary
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

Questions for Analysis

1.Which month shows the most unpredictable temperatures,and how might that affect outdoor events or agriculture planning?

2.Do the coldest months (by average min temp) also show to be inconsistent in temperature compared to the hottest months?

Question 3

Bar Graphs

Monthly Highs

Monthly Lows

Question 4

April Daily Highs

Sql Table

April 2018 Daily High Temperatures
DATE Max_Temp
4/1/2018 51
4/10/2018 45
4/11/2018 62
4/12/2018 79
4/13/2018 82
4/14/2018 75
4/15/2018 61
4/16/2018 46
4/17/2018 37
4/18/2018 57
4/19/2018 52
4/2/2018 45
4/20/2018 58
4/21/2018 60
4/22/2018 69
4/23/2018 70
4/24/2018 56
4/25/2018 62
4/26/2018 67
4/27/2018 71
4/28/2018 53
4/29/2018 58
4/3/2018 62
4/30/2018 70
4/4/2018 62
4/5/2018 48
4/6/2018 58
4/7/2018 42
4/8/2018 43
4/9/2018 38

Question 5

Line Plot