1 (6 pts): Calculate the following statistics using formulas for all data (rows 2 - 2929) in each of the columns listed below. Wind direction (0-360) Wind speed (km/h) Cloud cover (okta) Temp (C) Relative Humidity (%) Pressure (kPa) Visibility (km) Average 176.33 14.51 4.96 7.99 70.67 99.11 19.86 Std Deviation 115.71 10.13 3.10 9.70 14.61 0.97 6.60 Min 0.00 0.00 0.00 -17.70 28.00 95.40 -0.80 35th Percentile 140.00 11.00 4.00 2.70 66.00 98.80 23.20 3rd Quartile 270.00 20.00 8.00 15.60 82.00 99.80 24.20 Max 360.00 56.00 8.00 34.60 100.00 101.30 24.20 QUESTION 2 (6 pts): Calculate categories for Season, Time of Day, and Wind Speed using nested if functions. (See columns K, L, and M in the "Test 1 Data" file.) Please follow the instructions below for calculating these categories. Season categories: (NOTE: The months in each season are NOT all the same as in Proj 1 & 2) Months Season 12, 1, 2, and 3 Winter 4, 5, and 6 Spring 7, 8, and 9 Summer 10 and 11 Fall Time of Day Categories: (see Hints on next page) Hours Numerical bound Time of day category 8 AM - 12 noon between 0.333 and 0.500 Morning 12:01 PM - 5:59 PM between 0.501 and 0.749 Afternoon 6:00 PM - 10:59 PM between 0.750 and 0.957 Evening 11:00 PM - 7:59 AM between 0.958 and 0.332 Overnight (NOTE: Excel stores times by taking the number of seconds past midnight and dividing by 86,400, which is the number of seconds in a day. So 1:00:00 AM would be stored