Day 1
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
DAY 1: Learning Outcomes
- understand the steps of a data analysis
- understand difference between qualitative and quantitative data
- understand difference between discrete and continuous data
- create a COUNTA formula
- create MAX and MIN formulae
- understand the concept of dispersion in numerical data
- create a STDEV formula
- understand the difference between mean and median averages
- create AVERAGE and MEDIAN formulae