HRDF 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

                  HRDF SBL Claimable for Employers Registered with HRDF

For more information regarding this course please visit:https://www.tertiarycourses.com.my/statistical-data-analysis-training-with-excel-in-malaysia.html

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 

Ramzan has been conducting training and lectures in the IT industry for the past 18 years. She started her career as a college lecturer teaching NCC Diploma Computer Studies. Due to her in-depth experience and breadth of knowledge, Ramzan was selected by the Malaysian Ministry of Education to conduct training for Government School teachers called Program Latihan Penggunaan Peralatan TMK PPSMI 5. She has since then further forayed into academia training engagements with both public and private tertiary education institutions such as University Malaya, University Teknologi MARA, University Tunku Abdul Rahman (UTAR), University of Nottingham Malaysia and The SEGi Education Group.

Being an effective communicator with proven ability to build strong working relationships and generating results, Ramzan ventured into the corporate training field with her core expertise in productivity software suite training ie: Microsoft Office, IBM Lotus Smart Suites, Google Docs and Open Office applications.

Her corporate training portfolio achievements include training multitude business verticals and industry segments encompassing Government Linked Companies, Corporate Enterprise and Small Medium Businesses. This includes companies such as Khazanah Nasional Berhad, Felda, Petronas, UEM Land, Air Asia, Maybank, CIMB, Standard Charted, Honda, Perodua, BMW, Shell, DHL, Gamuda, Hewlett Packard, Prudential, Maxis, Celcom Axiata Group and others.