Call +60 3-7490 2093 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

Topic 1: Get Started ....

  • Excel Statistics Essentials
  • Excel Functions
  • Excel Statistical Functions
  • Excel Graphics
  • Excel Analysis ToolPak

Topic 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

Topic 3: Hypothesis Testing Using Excel

  • Z-Test Hypothesis Testing
  • T-Test Hypothesis Testing
  • F-test Hypothesis Testing
  • Chi-Square Hypothesis Testing

Topic 4 Analysis of Variance (ANOVA)

  • Single-Factor (multi-levels) ANOVA
  • Two Factors ANOVA
  • Post-ANOVA Testing

Topic 5 Regression

  • Linear Regression
  • Multiple Regression
  • Non-Linear Regression

Topic 6 Correlation

  • Two Factors Covariance
  • Multiple Factors Covariance Matrix
  • Two Factors Correlation
  • Multiple Factors Correlation Matrix

Topic 7 Time Series & Forecasting

  • Time Series
  • Forecasting

Topic 8 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 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.

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.

Statistical Data Analysis TrainerDr. 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 a strong fundamental knowledge of research methodology, extensive experience with Excel, SPSS, R and MINITAB in writing and presenting reports. At present, she is conducting a 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 (12)

might consider 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 24/02/2020)
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 17/02/2020)
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 17/02/2020)
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 17/02/2020)
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 17/02/2020)
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 26/12/2019)
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
The white board too small, please provide bigger white board :) (Posted on 10/12/2019)
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