Statistical Analysis with Excel by Using ExTool

Learn how to do statistical analysis with Excel by using ExTool applications
Rating: 3.8 out of 5 (186 ratings)
8,238 students
English
English [Auto]
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.

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.

Course content

3 sections21 lectures51m total length
  • Introduction
    05:26
  • ExTool Introduction
    06:24

Instructors

CEO at ParaTool
Zhenyu Zhu
  • 3.8 Instructor Rating
  • 388 Reviews
  • 19,489 Students
  • 3 Courses

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.

Writer; Digital Media Marketing Specialist at ParaTool
Jessica Keaton
  • 3.8 Instructor Rating
  • 262 Reviews
  • 19,489 Students
  • 2 Courses

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.