In order to show an investor a surf shop is sustainable to open up in Oahu, Hawaii, analysis on a weather dataset provided in SQLite database was run using the query tool SQLAlchemy. This analysis focused on the temperature data for the months of June and Decemeber in Oahu. The results were summarized and compared.
- The mean temperature, maximum temperature, minimum temperature in June are all higher than the mean temperature, maximum temperature, minimum temperature in December.
- Base on the number of counts, there are more data points collected in June than in December.
- The standard deviation for the temperatures is 3.75 in December which is higher than the standard deviation for the temperatures in June which is 3.26.
The differences in mean, max, min temperature between the two months are not dramatic and the standard deviations are similar as well between the two months. At each quartile, there is around a 3-4 degree Fahrenheit difference between June and December with June having the higher temperature. This is not a surprise since June is a summer month in Hawaii.
Additional queries could be executed to find out the precipitation statistics in June and/or in December. Filtering out the specific year could also be done if one desires to observe the difference between years. Queries could look like the following.
Query for precipitation of Decemeber.
Query for Precipitation of June of 2017.
