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 dataUse 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 dataCreate 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 colorsCreate a Pivot Table with the months as rows, the final column is a Grand Total Average by month andThe final row is a grand total average by year