Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Descriptive statistics in excel for all data analysis projects
Welcome
Welcome to the course (5:11)
Resources (3:35)
Course Learning Objectives
Descriptive statistics the quick way
Aims and Learning objectives
Finding and installing the Analysis ToolPak in Excel - downloadable guide
Descriptive statistics using the analysis toolpack (10:41)
Chapter Summary
Chapter One - Quiz
Analysing data by hand
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
Visualising your data
Aims and Learning objectives
Histograms
Making Histograms in Excel (9:44)
Histograms using the Analysis ToolPak (6:55)
Boxplots
Making Boxplots in Excel (9:29)
Chapter summary
Chapter Three - Quiz
Quick bonus - Presenting your data
The summary table
Conclusion
Course Learning Outcomes
Using your skills - CPD system at pathologymu.com
Conclusion to the course
Course Final Quiz
Course materials for you to keep for your CPD files
Using your skills - CPD system at pathologymu.com
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock