Statistical Analysis with Excel by Using ExTool

Name: Statistical Analysis with Excel by Using ExTool
Rating: 3.8 (215 reviews)

Learn how to do statistical analysis with Excel by using ExTool applications

Created byZhenyu Zhu, Jessica Keaton

Last updated 9/2016

English

What you'll learn

At the end of this course, students will be able to master their Excel statistical analysis skills by learning the ExTool Applications. Through this mastery, work efficiency will increase and result in a more productive, positive work or educational environment.

Course content

3 sections • 21 lectures • 51m total length

Introduction5:26
This lecture will introduce the course.
ExTool Introduction6:24
This lecture will introduce the ExTool platform.

Descriptive Statistics2:13
This lesson will demonstrate how to perform a Descriptive Statistics Test in Excel by using ExTool.
Correlation Test3:06
This lesson will demonstrate how to perform a Correlation Test in Excel by using ExTool.
Outlier Test2:16
This lesson will demonstrate how to perform an Outlier Test in Excel by using ExTool.
Normality Test2:08
This lesson will demonstrate how to perform a Normality Test in Excel by using ExTool.
One Sample Z Test1:19
This lesson will demonstrate how to perform a One Sample Z Test in Excel by using ExTool.
One Sample T Test1:14
This lesson will demonstrate how to perform a One Sample T Test in Excel by using ExTool.
Two Sample Z Test1:19
This lesson will demonstrate how to perform a Two Sample Z Test in Excel by using ExTool.
Two Sample T Test1:19
This lesson will demonstrate how to perform a Two Sample T Test in Excel by using ExTool.
Paired T Test1:45
This lesson will demonstrate how to perform a Paired T Test in Excel by using ExTool.
One Proportion Test1:24
This lesson will demonstrate how to perform a One Proportion Test in Excel by using ExTool.
Two Sample Proportion Test1:57
This lesson will demonstrate how to perform a two sample proportion test in Excel while using ExTool.
Two Sample Variance Test1:44
This lesson will demonstrate how to perform a Two Sample Variance Test in Excel by using ExTool.
Goodness Of Fit Test For Poisson2:26
This lesson will demonstrate how to perform a Goodness of Fit Test in Excel by using ExTool.
One Way ANOVA CRD2:04
This lesson will demonstrate how to perform a Completely Random Design ANOVA Test in Excel by using ExTool.
One Way ANOVA RCBD2:37
This lesson will demonstrate how to perform a Randomized Complete Block Design ANOVA Test in Excel by using ExTool.
Logistic Regression1:47
This lesson will demonstrate how to perform a Logistic Regression Analysis in Excel by using ExTool.
Multi-linear Regression1:49
This lesson will demonstrate how to perform a Multi-linear Regression Analysis in Excel by using ExTool.
Time Series Analysis2:35
This lesson will demonstrate how to perform a Time Series Analysis in Excel by using ExTool.

Requirements

Students will need the Excel software and will also need to download the ExTool Add-on Application from the ParaTool website. It would be helpful to know the basic statistics knowledge.

Description

This course will include statistical analysis in Excel with ExTool toolbox. Topics such as descriptive statistics, correlation test, outlier test, normality test, linear regression, logistic regression, ANOVA, T-test, Z-Test, Goodness of fit test, variance test, proportion test, time series analysis and prediction, etc. Each virtual lecture includes a visual demonstration along with audio or written commentary. Students should take this course if they are using Excel in their daily lives—especially if they are interested in doing statistical analysis with Excel. Excel itself has limited capability to handle statistical analysis tasks. By completing this course and learning the ExTool applications, students can handle basic statistical analysis without using other charged professional software like Minitab or SAS.

Who this course is for:

Students that use Excel in their daily work or education should take this course, no matter his or her proficiency.

Statistical Analysis with Excel by Using ExTool

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 12min

Statistical Analysis18 lectures • 35min

Conclusion1 lecture • 4min

Requirements

Description

Who this course is for: