You’re being provided with a 10 year data set of weather data of min max temperatures and rainfall as collected at Raleigh-Durham International Airport by NOAA. – The data set contains the dates of readings in oF, and rainfall in inches – Dates are in generic number format with 1/1/2007 = 39083 – Dates are non-sequential • Construct an Excel solution that evaluates the data set and finds the following. – The average monthly temperatures. – Total monthly rainfall
Below is the Dataset