Quick methods to summarise data
Use a simple excel add in to quickly summarise your data, ready for the next stage of analysis
The advantage of manually summarising data
Understanding while doing is always preferable in any type of analysis
We will walk slowly through customising our analysis to our specific needs, and in doing so will develop our intuition into what we are doing and why
By the end of this course EVERY analysis your EVER perform will use the techniques shown in this course, not just because they are easy, but more importantly they make sure you understand the data above anything
Let excel do the heavy lifting
Sometimes you just need a quick answer
Excel does use in built functionality to make it extremely easy to summarise your data, here we show you how, in a few clicks, you can get results quickly
You do all the work
Sometimes you need to really understand the data
It pays to be able to do it using formulas and functions - Understanding comes with owning the data
Meet somewhere inbetween
Sometimes it's both
Knowing both approaches empowers you to decide the best approach - for a specific analysis
Summarising data with graphs
Numbers are great but graphs are easier for us to understand. Graphs aren't just for presenting final data they can be used to explore your data too. Learn some simple visualisations that are guaranteed to make your analysis quicker and more efficient - at the simple click of a few buttons! (and of course by hand too!)
Example Curriculum
- Aims and Learning objectives
- Counting and summing
- Measures of central tendency
- The Mean, Median and Mode (13:06)
- Measures of spread
- Standard deviation, Inter quartile range and spread (17:34)
- Other useful metrics
- Skew and Kurtosis (10:38)
- Finishing our descriptive statistics (11:06)
- Interpreting the numbers (6:28)
- Chapter Summary
- Chapter Two - Quiz