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
Teach online with
Conditional operations on a table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock
