Project – Weather study

§  You’re 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 dates of readings of specific dates in oF, and rainfall in inches

§  Dates are in generic number format with 1/1/2007 = 39083

§  Construct an Excel solution that evaluates the data set and finds the following.

§  Calculating the average monthly temperatures.

§  Calculating the monthly rainfalls

§  Present your findings in a table format within the spreadsheet.

§  Include plots showing temperature and rainfall vs time.

Project – Weather study

§  Requirements :

§  A well documented VBA program ( .XLSM ) file that will be uploaded to BB.

§  A screen shot of your programs output that will be uploaded to BB.

§  A summary of your project that includes the following elements:

§  Introduction – explain what the project is about

§  Approach – a summary of the approach you undertook in building your program. Alternate approaches evaluated or you might have undertaken.

§  Conclusion – Success or failure of the approach in yielding expected results and in the case of the latter what would/could be done differently.

§  Print out your source file and your screenshots and append these to your project summary page