2023 Use the sort function to reorder the data by month then use a | Assignments Online

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