Course Details
Course Details
What You'll Learn
Topic 1: Basic Statistics
Why Statistics Matter
Types of Data
Descriptive Statistics
Probability and Conditional Probability
Probability Distributions
Install Excel Statistical Analysis ToolPak
Topic 2: Sampling and Hypothesis Testing
Sampling
Central Limit Theorem
Sampling Distribution and Standard Errors of Sample Mean
Confidence Interval
Z and T Statistics
Overview of Hypothesis Testing
Types of Hypothesis Testing
Type 1 and Type 2 Errors
Analysis of Variance (ANOVA)
Topic 3: Regression and Correlation Analysis
Regression Modeling
Residues and Mean Square Error
Covariance and Correlation Analysis
Assessment
- Practical Exam
- Oral Questioning
Course Info
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
- Minimum 18 years old
Minimum Software/Hardware Requirement
Software:
You will need the following for this course:
- Microsoft Excel (desktop app, Microsoft 365) with the Analysis ToolPak add-in
Hardware: Windows PC or Mac laptop
Job Roles
Job Roles
- Data Analyst
- Business Analyst
- Financial Analyst
- Operations Manager
- Marketing Analyst
- HR Metrics Specialist
- Sales Operations Specialist
- Report Developer
- Project Manager
- Management Accountant
- Product Manager
- Supply Chain Analyst
- Performance Metrics Specialist
- Market Researcher
- Business Intelligence Coordinator
Trainers
Trainers
Dr. Alvin Ang is a data scientist and data science educator with a PhD in Operations Research, an MSc in Logistics and a BEng in Mechatronics, Robotics and Automation Engineering, all from Nanyang Technological University. Operations research is the mathematics of better decisions, and his published work on Kanban production-control systems at IEEE conferences reflects the quantitative rigour he brings to every class. He has served as an IBM Data Science Instructor, a Research Fellow at NUS, a Principal Consultant in data science and an Assistant Professor of Mathematics at SP Jain School of Global Management, where he was named Mathematics Professor of the Year, and he lectured undergraduates in statistics and quantitative methods at SUSS. Since 2021 he has trained professionals at Tertiary Infotech in Python, R, SQL, statistics, Excel analytics, Tableau, Power BI, Apache Spark, machine learning and deep learning, and he founded DataFrens.sg, a community for data scientists in Singapore. An ACLP-certified adult educator, he is known for connecting technical concepts to practical, real-world applications, a strength echoed in hundreds of learner recommendations.
In WSQ - Statistical Data Analysis with Excel for Beginners, Dr. Ang draws on years of lecturing statistics and quantitative methods to make statistical analysis approachable in Excel. Learners describe data, apply probability and sampling, run hypothesis tests, correlation and regression, and visualise results, with clear explanations of what each result means for a business decision.
Liew Sing Loon is an ACLP-certified trainer with strong expertise in adult education, workplace learning, and applied quantitative methods. With years of experience designing and delivering WSQ-aligned programs, he has trained professionals across diverse sectors in the application of statistical and analytical tools. His background in instructional design enables him to simplify complex statistical concepts, making them approachable and practical for beginners.
In his Excel-based statistical training, Liew focuses on building learner confidence in using spreadsheets for data analysis. He covers descriptive statistics, data visualization, hypothesis testing, and regression analysis using Excel’s built-in functions and add-ins. By emphasizing hands-on practice and workplace applications, Liew ensures participants gain both the conceptual understanding and the practical skills to apply statistical techniques effectively in business and decision-making contexts.
Review
Customer Reviews (74)
- This course will be useful for our work as Dr.Alvin guide us in a very professional way and it was easier to understand Review by Course Participant/Trainee
-
This course will be useful for our work as Dr.Alvin guide us in a very professional way and it was easier to understand1. 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 2/3/2023) - will recommend Review by Course Participant/Trainee
-
Trainer Dwight was excellent in his knowledge and lesson delivery (Posted on 1/15/2023)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 - might recommend Review by Course Participant/Trainee
-
Maybe inform the building management about the renovation, because it's very noisy and distracting for the class. (Posted on 11/14/2022)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 - will recommend Review by Course Participant/Trainee
-
Facilities wise, class delayed due to technical faults in classroom . Ongoing renovation disrupts learning experience. (Posted on 11/14/2022)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 - will recommend Review by Course Participant/Trainee
-
It will be great if Alvin can provide more real life examples on statistics, so trainee can have more appreciation to statistics and eventually data science & AI/ML. (Posted on 11/3/2022)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
Write Your Own Review
- Recommended Courses
- Related Courses