Spreadsheet #2

Spreadsheet Assignment #2
Find the average temperature, High Temp, Low Temp, Average precipitation, Average Snowfall, Average Rain days, and Average dew point for Jackson, TN on weatherbase.com.

Enter the data for six months in a spreadsheet.

Create formula to find the sums and averages.

Use the Max and MIN formulas to find the the driest month
and the wettest month (use a spreadsheet function).
Use Lookup to assign a month to the number.

All data and calculations should be listed to one decimal point
accuracy (e.g. 1.4) -- use Format :: Cells... :: Number ::
Decimal places :: 1.

Be sure to label your data and your calculations so the viewer
knows what they mean.

Here is an Example

Enter your name at the bottom or top of the spreadsheet.