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
Course materials for you to keep for your CPD files
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock