Statistical Data Analysis Training with Excel
Details
SkillsFuture Course - Statistical Data Analysis Training with Excel
Microsoft Excel is an important tool to perform statistical data analysis. This course provides an overview of the fundamentals, from performing common calculations to conducting Bayesian analysis with Excel. The trainer will start with the foundational concepts,
including an introduction to the central limit theorem, and then shows how to visualize data, relationships, and future results with Excel's histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating
the covariance and correlation between data sets. The course closes with a look at calculating Bayesian probabilities in Excel.
Topics include:
- Excel Data Analysis Tool
- Basic Statistical Concepts
- Hypothesis Testing
- Correlation Analysis
- Analysis of Variance
- Regression
- Bayesian Probability Analysis
- Simulation
Outline
Module 1: Get Started ....
- Excel Statistics Essentials
- Excel Functions
- Excel Statistical Functions
- Excel Graphics
- Excel Analysis ToolPak
Module 2 Basic Statistics Using Excel
- Mean, Median, Mode
- Variance and Standard Deviation
- Probability Distributions
- Normal Distribution
- Central Limit Theorem
- Estimation and Confidence Level
- Hypothesis Testing
Module 3: Hypothesis Testing Using Excel
- Z-Test Hypothesis Testing
- z-score
- One-tailed test
- Two-tailed test
- T-Test Hypothesis Testing
- t-score
- F-test Hypothesis Testing
- Chi-Square Hypothesis Testing
Module 4 Analysis of Variance (ANOVA)
- Single-Factor (multi-levels) ANOVA
- Two Factors ANOVA
- Post-ANOVA Testing
Module 5 Regression
- Linear Regression
- Multiple Regression
- Non-Linear Regression
Module 6 Correlation
- Two Factors Covariance
- Multiple Factors Covariance Matrix
- Two Factors Correlation
- Multiple Factors Correlation Matrix
Module 7 Time Series & Forecasting
- Time Series
- Forecasting
Module 8 Simulation
- Monte Carlo Simulation
- Business Simulation
WDA Training Grant Applicable for Company
For more details, please visit our website at
https://www.tertiarycourses.com.sg/statistical-data-analysis-training-with-excel-in-singapore.html or contact us at [email protected]
Speaker/s
Tertiary Courses Singapore offer many SkillsFuture courses in Singapore. We offers wide range of classroom instructor-led technical training courses for working professionals and executives in Singapore. Many of our courses and trainings are SkillsFuture Approved and eligible for WDA Absentee Payroll Grant.
Our courses include Infocomm, Digital Media, Robotics, Semiconductor,Telecommunication, Life Science, Horticulture Industries , and Business Administration . Below are some of our popular courses
- Python Programming
- R Programming
- Tableau
- Machine Learning
- Raspberry Pi
- Arduino
- 3D Printing
- iOS Apps Development
- Android Apps Development
- Magento eCommerce
- Wordpress
- Joomla
- Search Engine Optimization
- Web Design
- Google Analytics
- Facebook Marketing