Use the sort function to reorder the data by month then use a formula to calculate the average temperature by

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions