#### The ‘Worst Weather’ Debate

The increasingly predominant use of Excel is to organize and analyze data sets, particularly as Microsoft has increased Excel’s capacity and de-emphasized development of MS Access. This course provide a useful start to using Excel for data analysis.

You have challenged yourself to find and analyze weather data adequate to argue that either Boston or Houston has the comparatively worse weather. In this course, you will load a data list of more than 17,000 records (a year’s hourly weather data for two weather stations). You will use Excel functionality to calculate different metrics filtered for different points in time, e.g. temperature, sky condition, precipitation, wind chill, heat index, and select the information you think makes the case for each city being the ‘winner’ in this debate.

Start by reading the case setting note to give you the context and proceed to Lesson 1.

#### Course Content

#### x111 Unassigned Topics - 4:39 | Data Validation List
- 1:46 | LEFT Function
- 5:39 | INDEX Function
- 3:19 | What's a Function?
- 4:28 | FIND Function
- 9:24 | Error Filtering
- 5:33 | Basic Math Functions
- 3:37 | LEN Function
- 6:53 | RANK Function to Re-order a List
- 4:28 | MATCH Function
- 6:38 | INDEX Function OBS
- 3:50 | MID Function
- 3:50 | IF Function
- 4:16 | AND, OR, and NOT

- 4:39 | Data Validation List
- 1:46 | LEFT Function
- 5:39 | INDEX Function
- 3:19 | What's a Function?
- 4:28 | FIND Function
- 9:24 | Error Filtering
- 5:33 | Basic Math Functions
- 3:37 | LEN Function
- 6:53 | RANK Function to Re-order a List
- 4:28 | MATCH Function
- 6:38 | INDEX Function OBS
- 3:50 | MID Function
- 3:50 | IF Function
- 4:16 | AND, OR, and NOT