Call +60 3-2711 7241 Email: sales@tertiarycourses.com.my

HRDF Approved Training Provider in Malaysia - Modular Fast Track Skill-Based Trainings

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.

Course Highlights

  • Excel Data Analysis Tool
  • Basic Statistical Concepts
  • Hypothesis Testing
  • Correlation Analysis
  • Analysis of Variance
  • Regression
  • Bayesian Probability Analysis
  • Simulation

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

 

HRDF SBL Claimable for Employers Registered with HRDF

HRDF claimable

Course Code: M263

Course Booking

MYR880.00

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Course Details

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 

Course Admin

Nil

Who Should Attend

  • Data analysts using Excel for statistical data analysis
  • Financial analysts using Excel for market and time series analysis

Trainers

Microsoft and Google TrainerRamzan 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.

R TrainerDr. Zahra Nazemi has PhD in mathematical statistics from Universiti Putra Malaysia. Her research interests are applied statistics, medical statistics, Bayesian statistics, statistical inference and Software R. She has worked as a lecturer in different universities for more than 4 years. She also consulted and worked on assignments for parametric and non-parametric analysis, univariate and multivariate regression analysis in various areas such as medical, economics and psychology. Her other skills are knowledge of research methodology, extensive experience with SPSS, AMOS, R and MINITAB and writing and presenting reports. Moreover, she conducted special training program in mathematical programming including optimization, advanced multivariate data analysis, and simulation techniques

R Statistics TrainerMostafa has more than 5 years’ experience in teaching mathematics and statistics. His main teaching interests are statistical topics such as descriptive analysis and basic data modeling, regression analysis, design of experiment, non-parametric methods, and statistical software such as SAS, R, SPSS, and Minitab. He has started computer programming using visual basics and C++ around 15 years ago, and he has more than 10 years’ experience in programming using R.

Statistical Data Analysis With Excel TrainerHaving spent a large part of his professional years in the IT world, Metta then spent 5 years on a personal journey into the realm of direct selling, personal health & people development.

Equipped with his vast experience gained from the Hospitality industry, the Commodities & Trading industry and the many facets of the Information Technology industry, Metta now endeavours to leverage his knowledge gained from his stints in Evangelism, Creating Sales Models & Solutions Sales Models, identifying Revenue Sales Models, Solutions Development & Solutions Selling, developing & perfecting Partner engagements, crafting & managing Reseller & Channel business models to enrich the lives of the people he comes in contact with.

Blockchain TrainerMuhammed Siraj is an IT executive, lecturer, trainer, security expert, developer, hardware technician, and entrepreneur with over 15 years of experience in the IT profession. He is an experienced IT instructor who has delivered several lecturers in the area of Cybersecurity, Computer Forensics, and Fraud detection to the military, police, CID, Financial Institutions, among others. In addition to training, he provides consultancy services to Educational and Governmental Institutions in the area of computer security and adoption of Open Source solutions. His experience and knowledge acquired from Ghana, Mali, Denmark, South Africa, and Malaysia, enables him to interact with people of different cultural backgrounds very well.

Skillset:

  • Degrees in IT, Economics, Psychology. Currently pursuing his PhD in Computer Science (Security in Computing field)
  • Certified CEH, CHFI, Hardware repairs and maintenance.
  • Data mining, Office automation, filemaker, Fraud detection, Blockchain, Hardware repairs, Google Power Searcher, Drupal/Laravel/CakePHP developer.
  • Proficient in Python, Ruby, PHP, Java, Solidity, VBA, Google Apps Script, Javascript, HTML, CSS, SQL.

R Statistics TrainerSultan Maideen has over 8 years of experience in Business Intelligence with Predictive Analytics and Data Visualization. His colleagues regard him as a self-motivated thought leader in building governed self-service BI/Analytical models in Tableau, QlikView, MicroStrategy, and Power BI.

He specializes in enhancing the quality of business strategy and helping companies improve top-line & bottom-line by devising creative solutions & managing stakeholders’ expectations successfully.

Dr. Ummul Fahri Abdul Rauf has PhD in Applied Statistics from RMIT University, Australia. Her research interests are applied statistics, multivariate analysis, statistical modelling, statistical inference and programming using R Software. As per her affiliation with National Defence University of Malaysia (NDUM) for 12 years, she is also experienced as principal investigator and has worked on a few research grants for parametric and non-parametric analysis, univariate and multivariate analysis using copulas in various areas in engineering, social science and psychology. She has strong fundamental knowledge of research methodology, extensive experience with Excel, SPSS, R and MINITAB in writing and presenting reports. At present, she is conducting special training program in statistical programming including advanced multivariate data analysis using Copulas. Besides teaching and research, her additional duties involve assisting the Director of Quality Assurance and Data Management Centre at NDUM to coordinate and monitor implementation of Quality Management System (QMS) and conduct internal and external audits, to coordinate collection and verification of data for continual enhancement and liaise with relevant external agencies on academic quality compliance issues e.g. Ministry of Higher Education, Malaysian Qualification Agency. Dr. Ummul Fahri currently is the deputy director for Quality Assurance and Data Management Centre and has been holding the post for 4 years .

Customer Reviews (5)

Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 30/07/2019)
Navaneswary Magaswaran Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
* Should provide some more examples on how data analysis can be done with excel.
* Should be more sensitive of the participants as the course was conducted on a Friday (Prayers timing). Should inform on the extending timing of the course beforehand. (Posted on 30/04/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Nil (Posted on 28/04/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More details in the slides on step-by-step guide on the specific excel functions for data analysis (Posted on 14/01/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
maybe with more complicated exercises (Posted on 20/07/2017)

Write Your Own Review

You're reviewing: Statistical Data Analysis Training with Excel

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha
    Attention: Captcha is case sensitive.

Product Subjects

Other people marked this product with these Subjects:

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses