Hi! How do I average the temperatures for each month? I have tried highlighting and using the average option under the sum in excel. It gives me information, but I do not think it is the correct info. I know the answer's I am getting are wrong. Here are the directions that I was given:

1 Use the tab marked Job 7.1 and start by copying the raw data to this worksheet. You may also want to copy these instructions and the table below. 2 Sort the data by month (Use "Sort & Filter), then create a table as you see below and use the "@average" formula and the reorganized data to get the average by month. 3 Then use the "Insert -> Line chart" to make a line chart beside the table showing the trend graphically by month 4 Finally, explain what you see in the data regarding the average temperature by month in Washington D.C.

I have sorted the data already by month. I would like to know how to get the averages.

These are the answers I get when using the function "average" for April:

1022.2

1023.5

1022.6

1022.8

1027.1

1023.8

1025.3

1023.7

1026.45

1026

1026.8

1028.3