Excel+temperatures

1. Open up an Excel “NEW DOCUMENT.” 2. Notice the rows and columns. 3. In A1, put the first HIGH temperature in your data. 4. In A2, put the second High temperature, and so on. 5. Go to Column B 6. In B1, first LOW temperature. 7. B2, next LOW temperature. 8. Continue. 9. Skip a line. Let’s say you have 31 rows with data. You will highlight A33. 10. Double click that space. 11. Go to the “fx” in the bar over the columns. Select it. 12. Find AVERAGE. Hit OK. 13. Pull down all the numbers in the column OR Type in =AVERAGE(A1:A31) That should be the average high temperature.

14. Repeat for column B, the high temperatures. 15. To get the MONTH MEAN, do the formula =AVERAGE(A33,B33) (or whatever places your two MEAN temperatures are. 16. Highlight the data, go to INSERT, find CHARTS, and bar graphs, and select one.