Question: Question 2: Calculate the following categories using nested if functions: Season, time of day, wind direction, and wind speed. Please follow the instructions below.



Question 2: Calculate the following categories using nested if functions: Season, time of day, wind direction, and wind speed. Please follow the instructions below. Time of day category: NIGHT AFTERNOON EVENING MORNING Hours 6 AM - 12 PM 12:01 PM - 5 PM 5:01 PM 10 PM 10:01 PM - 5:59 AM Numerical bound between 0.250 and 0.500 between 0.501 and 0.708 between 0.709 and 0.917 Time of day category Morning Afternoon Evening More than 0.917 or less than 0.250 Overnight Season Category Months Season 12, 1, and 2 Winter 3, 4, and 5 Spring 6, 7, and 8 Summer 9, 10, and 11 Fall Wind direction category: Wind direction More than 338 or less than 22 Between 23 and 67 Between 68 and 112 Between 113 and 157 Between 158 and 202 Between 203 and 247 Between 248 and 292 Between 293 and 337 Wind direction Category North Northeast East Southeast South Southwest West Northwest Wind Speed Category: Wind Speed 0-10 km/h 11-20 km/h Wind Speed Category Calm Breeze 21-30 km/h 31-40 km/h 41-50 km/h More than 51 km/h Strong Breeze Windy High Wind Strong Wind 51-40 km/h 41-50 km/h More than 51 km/h Hints: Windy High Wind Strong Wind For time of day category =if(OR(b2>0.917,b2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
