HRDF Course Statistical Data Analysis Training with Excel
Details
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 Statistical Concepts
- Mean, Median, Mode
- Variance and Standard Deviation
- Conditional Probability and Bayesian Probability
- Probability Distributions
- Normal Distribution
- Central Limit Theorem
- Estimation and Confidence Level
- Hypothesis Testing
Module 3: Hypothesis Testing
- Z-Rest Hypothesis Testing
- T-Test Hypothesis Testing
- F-test Hypothesis Testing
- Chi-Square Hypothesis Testing
Module 4 Analysis of Variance (ANOVA)
- Two Factors ANOVA;
- Multiple Factors AVOVA
- Post-ANOVA Testing
Module 5 Regression
- Linear Regression
- Multiple Regression
- Non-Linear Regression
Module 6 Time Series
- Time Series
- Forecasting
Module 7 Correlation
- Two Factors Covariance
- Multiple Factors Covariance Matrix
- Two Factors Correlation
- Multiple Factors Correlation Matrix
Module 8 Performing Bayesian Analysis
- Introducing Bayesian Analysis
- Classification Matrix
- Calculating Bayesian Probabilities in Excel
Module 9 Simulation
- Monte Carlo Simulation
- Business Simulation
Speaker/s
All our courses and trainings are funded by HRDF (Human Resources Development Fund Malaysia). 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 Optimizatoin
- Web Design
- Google Analytics
- Facebook Marketing