This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Statistics and Data Analysis with Excel
Introduction
Introduction (3:23)
Univariate analysis
Minimum, maximum and count (2:37)
Mean value (1:10)
Variance and standard deviation (5:01)
Skewness (3:14)
Median, quantiles and percentiles (8:24)
Interquartile Range (2:31)
Conditional operations on a single variable (5:45)
Advanced univariate analysis
Outlier labeling with IQR (5:23)
Moving average (5:23)
Rolling maximum and minimum (3:41)
Percentage change (2:49)
Confidence intervals of the mean value (11:37)
Confidence intervals of a proportion (5:45)
Multivariate analysis
Linear correlation coefficient (2:34)
Linear regression with predictions (5:58)
Hypothesis tests
One sample t-test (9:27)
Two samples t-test (8:20)
F-test for variance (2:06)
Chi-square test (7:14)
Z table (5:16)
T table (4:40)
Database operations
Conditional operations on a table (5:09)
Vertical lookup (7:23)
Database operations (9:33)
Pivot tables
How to create a pivot table (4:33)
Filters on pivot tables (3:58)
Group by rows and columns (4:22)
Representation of the results (3:52)
End of course
End of course
Conditional operations on a table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock