please help

profilecoryafghan2002

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


  • 6 years ago
  • 30
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    TemperatureDataBase.xlsx