The first day is about building a solid conceptual and technical foundation in data analysis.  We do this by conducting a basic Excel data analysis of the simulated dataset.

DAY 1: Learning Outcomes

1. understand the steps of a data analysis

2. understand difference between qualitative and quantitative data

3. understand difference between discrete and continuous data

4. create a COUNTA formula

5. create MAX and MIN formulae

6. understand the concept of dispersion in numerical data

7. create a STDEV formula

8. understand the difference between mean and median averages

9. create AVERAGE and MEDIAN formulae