Question 2: Calculate the following categories using nested if functions: Season, time of day, wind direction,...

Transcribed Image Text:

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 <0.25), "Overnight" if(b2 <0.5, "Morning",...... For wind direction category =if(OR(c2>337,C2 <22), North.if(c2 <68, "Northeast, For wind speed category =if(d2 <11, "Calm.if(d2 <21, Breeze",. Question 3: Use pivot table to summarize data and produce the following charts (Please create separate worksheet for each Pivot chart) Note: Before starting this problem, you should have already calculated categories in Q2. a) Please plot the followings using Pivot Table 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 <0.25), "Overnight" if(b2 <0.5, "Morning",...... For wind direction category =if(OR(c2>337,C2 <22), North.if(c2 <68, "Northeast, For wind speed category =if(d2 <11, "Calm.if(d2 <21, Breeze",. Question 3: Use pivot table to summarize data and produce the following charts (Please create separate worksheet for each Pivot chart) Note: Before starting this problem, you should have already calculated categories in Q2. a) Please plot the followings using Pivot Table