Statistical Analysis with Excel by Using ExTool
3.3 (25 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,510 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Statistical Analysis with Excel by Using ExTool

Learn how to do statistical analysis with Excel by using ExTool applications
3.3 (25 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,510 students enrolled
Last updated 9/2016
English
Price: Free
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • 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
+
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
About the Instructor
Zhenyu Zhu
3.4 Average rating
45 Reviews
3,781 Students
3 Courses
CEO at ParaTool

Dr. Zhenyu Zhu is a senior data analyst, database specialist, and seasoned structural engineer. Hehas 20 years of experience using Excel with advanced data analysis and presentation functionalities and 10 years of programming experience with multiple languages—including Excel VBA. Over the years, he has served as the lead analytical engineer for multiple landscape bridge projects, most significantly the San Francisco-Oakland Bay Bridge. During this time, he also implemented a cloud-based platform to facilitate data communication between multiple disciplinary workers of the design and construction project. The cloud-based platform has, hence, extended to other industrial fields and served as the infrastructure for all of the apps discussed within this course.

Jessica Keaton
3.4 Average rating
39 Reviews
2,525 Students
2 Courses
Writer; Digital Media Marketing Specialist at ParaTool

Jessica Keaton is a recent graduate of San Jose State University's MFA Creative Writing Program. Formally a college English instructor, she is now using her acquired writing skills in the tech industry on the ParaTool Marketing Team.