I Have A Excel Project using code Need To Be Done In day
Project 3
Project – Weather study3
- 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
Project – Weather study3
- 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 1 page summary of your project that includes the following elements:
- Introduction - explain what the project is about
- Approach - a 1 paragraph 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
- Report will be handed in on the 13th