2017 Finals: Data Diving

Description
This workbook is taken from the Finals of the 2017 Modeloff financial modeling world chamionships.

Follow the instructions in order to complete the model:

You have been provided with daily weather data (rainfall, minimum temperature, maximum temperature) for the year 2010 for 18 major U.S. cities.

You have also been provided with Latitude, Longitude, Elevation and 2010 Population data for each of the 18 cities.

Bring this data to life. Show the patterns and information hiding in it. Build a model in Excel, interactive if you wish, that lets the user see the data in an interesting way.

Create an easy and fun way for the user to explore the weather data for their chosen city or cities. There
are no fixed guidelines for what you should or should not focus on. Each judge will rank their top five
favourite models based on their own subjective view of what they like.

You have also been provided with a JPG map file showing a blank outline of the 48 contiguous US states, with the location of the 18 cities marked by number (miniature version included below). You may or may not choose to make use of this image in your work.

Alternatively, you may wish to use the Latitude and Longitude co-ordinates provided with some of Excel's
newer map tools.

Allotted time: 60 minutes

Once finished, feel free to upload your model to your own dedicated author channel!