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)
- Dr Alvin Ang was very good teaching this course and taught alot of application of the skills Review by Course Participant/Trainee
-
Dr Alvin Ang was very good teaching this course and taught alot of application of the skills (Posted on 6/9/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 - Dr Alvin is fun and engaging through the course, great to learn from too. Review by Course Participant/Trainee
-
Dr Alvin is fun and engaging through the course, great to learn from too. (Posted on 6/9/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 - Dr Alvin is very knowledgeable and are able to answer all of our doubts. Dr Alvin is also patient and impart us a lot of knowledge so that we understand better. Review by Course Participant/Trainee
-
Dr Alvin is very knowledgeable and are able to answer all of our doubts. Dr Alvin is also patient and impart us a lot of knowledge so that we understand better. (Posted on 5/16/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 - I enjoyed attending the WSQ Statistics with Dr. Alvin Ang Review by Course Participant/Trainee
-
The course presenter has exceed expectations and recommend to mantain his teaching style and method1. 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
I enjoyed attending the WSQ Statistics with Dr. Alvin Ang, hes method of delivery was good and the way he conduct hes lesson was easy to understand. HighlyRecommend Dr. Alvin Ang for any future courses (Posted on 5/16/2022) - Dr Alvin was very systematic in showing the application of the data analysis Review by Course Participant/Trainee
-
may be more work shops or homework for practice or refresher1. 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
Dr Alvin was very systematic in showing the application of the data analysis with relevant examples and inferences. He willingly shared his knowledge and understanding in simple language. (Posted on 2/20/2022)
Write Your Own Review
- Recommended Courses
- Related Courses