Statistical Analysis with Excel by Using ExTool
- 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.
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.
- 06:24ExTool Introduction
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 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.