Problem
Use the sort function to reorder the data by month, then use a formula to calculate the average temperature by month between 1990 and 2001. Next create a table of the average temperatures by month. Finally create a scatter plot of the data
Use the sort function to reorder the data by year, then use a formula to calculate the average temperature by year between 1990 and 2001. Next Create a table of the average temperature by year. Finally create a scatter plot of the data
Create a histogram of the temperatures creating 10 "bins" adding a title "Washington D.C. Temperatures" and change the color of the background and bars to your favorite College Football team colors
Create a Pivot Table with the months as rows, the final column is a Grand Total Average by month and the final row is a grand total average by year.
The response should include a reference list. Using double-space, Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.