Statistical Analysis with Excel by Using ExTool
3.3 (25 ratings)
1,512 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Statistical Analysis with Excel by Using ExTool to your Wishlist.

# Statistical Analysis with Excel by Using ExTool

Learn how to do statistical analysis with Excel by using ExTool applications
3.3 (25 ratings)
1,512 students enrolled
Last updated 9/2016
English
Price: Free
Includes:
• 1 hour on-demand video
• Access on mobile and TV
• Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
• Students that use Excel in their daily work or education should take this course, no matter his or her proficiency.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
51:04
+
Introduction
2 Lectures 11:50

This lecture will introduce the course.

Introduction
05:26

This lecture will introduce the ExTool platform.

ExTool Introduction
06:24
+
Statistical Analysis
18 Lectures 35:02

This lesson will demonstrate how to perform a Descriptive Statistics Test in Excel by using ExTool.

Descriptive Statistics
02:13

This lesson will demonstrate how to perform a Correlation Test in Excel by using ExTool.

Correlation Test
03:06

This lesson will demonstrate how to perform an Outlier Test in Excel by using ExTool.

Outlier Test
02:16

This lesson will demonstrate how to perform a Normality Test in Excel by using ExTool.

Normality Test
02:08

This lesson will demonstrate how to perform a One Sample Z Test in Excel by using ExTool.

One Sample Z Test
01:19

This lesson will demonstrate how to perform a One Sample T Test in Excel by using ExTool.

One Sample T Test
01:14

This lesson will demonstrate how to perform a Two Sample Z Test in Excel by using ExTool.

Two Sample Z Test
01:19

This lesson will demonstrate how to perform a Two Sample T Test in Excel by using ExTool.

Two Sample T Test
01:19

This lesson will demonstrate how to perform a Paired T Test in Excel by using ExTool.

Paired T Test
01:45

This lesson will demonstrate how to perform a One Proportion Test in Excel by using ExTool.

One Proportion Test
01:24

This lesson will demonstrate how to perform a two sample proportion test in Excel while using ExTool.

Two Sample Proportion Test
01:57

This lesson will demonstrate how to perform a Two Sample Variance Test in Excel by using ExTool.

Two Sample Variance Test
01:44

This lesson will demonstrate how to perform a Goodness of Fit Test in Excel by using ExTool.

Goodness Of Fit Test For Poisson
02:26

This lesson will demonstrate how to perform a Completely Random Design ANOVA Test in Excel by using ExTool.

One Way ANOVA CRD
02:04

This lesson will demonstrate how to perform a Randomized Complete Block Design ANOVA Test in Excel by using ExTool.

One Way ANOVA RCBD
02:37

This lesson will demonstrate how to perform a Logistic Regression Analysis in Excel by using ExTool.

Logistic Regression
01:47

This lesson will demonstrate how to perform a Multi-linear Regression Analysis in Excel by using ExTool.

Multi-linear Regression
01:49

This lesson will demonstrate how to perform a Time Series Analysis in Excel by using ExTool.

Time Series Analysis
02:35
+
Conclusion
1 Lecture 04:12

This lecture will conclude the course and provide information for further research.

Conclusion
04:12