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 using MS-Excel
Introduction to the Course
Introduction to the Course
Statistics - Understanding the Basics
Introduction to Statistics- What is in it for me (1:46)
The DCOVA framework (2:23)
Descriptive Statistics and Inferential Statistics (1:55)
Variable types (Categorical Variables, Numerical Variables) (1:38)
Number of Variables - Types of Analysis (1:41)
Measurement Scales for Variables (2:07)
Data Sources (Primary Data sources, Secondary Data sources) (1:51)
Sort Data and Draw Random Samples
Sorting Data using Excel (3:27)
Sort Options and Advanced Filter (1:47)
Drawing Cluster Random Sample using Excel (3:57)
Drawing Stratified Random Sample using Excel (4:14)
Data Presentation
Creating Chart to get Bird's Eye View with Excel (3:25)
Descriptive Statistics
How to Load the Analysis Toolpak in Excel (1:42)
Calculating Descriptive Statistics with Analysis Toolpak (2:10)
Calculating Frequency Distribution and Histogram with Data Analysis Command (4:51)
The Empirical Rule - Tests of Normality (3:20)
Bivariate Analysis (Correlation Analysis)
Exploring Relationship using Scatter Plots (3:08)
Calculating Bivariate and Multivariate Correlation with Analysis Toolpak (5:27)
Casual Relationship (Regression Analysis)
Importance and assumptions of Simple Linear Regression (3:13)
Running Simple Linear Regression Analysis in Excel (5:02)
Multiple Linear Regression Analysis
Relevance and Assumptions of Multiple Regression Analysis (2:06)
Running Multiple Linear Regression Analysis in Excel (3:30)
Time Series Data Analysis
Moving Averages using Excel Data Analysis Toolpak (3:45)
Exponential Smoothing using Excel Data Analysis Toolpak (3:03)
Hypothesis Testing - Two Samples
Perform Paired t-test using Excel Data Analysis Toolpak (3:46)
Calculating Independent Sample t-test in Excel Data Analysis Toolpak (3:51)
Hypothesis Testing - Three or More Variables Analysis of Variance (ANOVA)
Introduction to One-way ANOVA (2:16)
Compute Analysis of Variance (ANOVA) with Excel Data Analysis Command (4:46)
Non Parametric test for Categorical Data
Chi-Square test for Independence in Excel (7:11)
Exponential Smoothing using Excel Data Analysis Toolpak
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock