An entreprenuer has developed a business proposal for a surf and ice cream shop located on the island of Oahu. Before committing funds, investors requested an analysis of weather data to determine the year-round sustainability of the business. Multi-year temperature data for Oahu was queried to obtain records specific to the months of June and December and analyzed using SQLite and Python. Summary statistics were calculated in a jupyter notebook and assessed in the subsequent analysis.
-
There were 1700 temperature data points for June
-
Data covered a temporal range of 2010 to 2017
-
Summary statistics for temperature are displayed below.
-
There were 1517 temperature data points for December
-
Data covered a temporal range of 2010 to 2016
-
Summary statistics for temperature are displayed below.
- There are 183 more data points for June than for December.
- The minimum temperature in June is 64 degrees Farenheit whereas the minimum temperature for December is 56 degress Farenheit.
- The average temperature is slightly higher in June compared to December (74.9 and 71.0, respectively).
- The lower quartile for June is higher than the lower quartile for December (73 and 69, respectively).
- The months of June and December are similar in Oahu on the basis of temperature data alone. While 25th, 50th, and 75th percentiles are slightly upshifted in June compared to December, quartile statistics suggest that December is still fairly warm (and very ice cream worthy).
- However, it's worth noting that the month of June has an additional year of data compared to December. Further, minimum temperatures for June and December are 64 and 56, respectively. While 56 degrees is still ice cream weather for a Michigan resident, Hawaiian residents might consider that kind of weather to be chilly and not the kind of weather for ice cream.
- While this analysis features summary statistics on bulk data, it does not sufficiently capture shifting annual temperature trends. Even if only 25% of the December temperature data points are below 69 degrees Farenheit, are these data points distributed evenly across years? Or are those data points more concentrated in recent years? Also, half of the business is a surf shop. Are water temperatures in December as warm as air temperatures? Or is the water too cold for surfing? Is there more precipitation in December that might deter customers from patronizing the business? These and other questions should be addressed prior to investment commitments.
- To address remaining questions on weather data, the following queries could be considered:
- Bin temperature data for June and December according to the year data was collected and create a histogram to highlight any shifting annual weather trends.
- Compare precipitation data for June and December to see if rainier weather might limit customers to a surf and ice cream shop.
- Data Sources:
- Software:
- Jupyter Notebook