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)
- Clear, engaging and easy to follow Review by Course Participant/Trainee
-
I had a great learning experience attending the Statistics with Excel course conducted by Dr. Alvin Ang. The lecture was clear, engaging, and easy to follow, with practical examples that made understanding statistics and using Excel much easier. Dr. Alvin was knowledgeable, patient, and explained the concepts in a very approachable way. I especially appreciated how the lessons connected statistical concepts with real-world applications. Highly recommended for anyone looking to strengthen their understanding of statistics and improve their Excel skills! Come and join his classes, you won't regret it. Thank you once again Sir. (Posted on 10/26/2026)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 - Average Rating: 5.0/5 Review by Course Participant/Trainee
-
N/A (Posted on 8/27/2026)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 - Clear and structured teaching style Review by Course Participant/Trainee
-
I had the privilege of being trained by Dr. Alvin Ang during a Statistics with Excel course at Tertiary Infotech, and I am truly grateful for the experience. Dr. Alvin has a very clear and structured teaching style that made complex statistical concepts easy to understand, even for someone without a strong background in the subject. He guided us through practical tools such as Excel Analysis ToolPak, covering techniques like hypothesis testing, t-tests, ANOVA, and data visualization in a very hands-on and engaging way. What stood out most was his humor, patience and willingness to ensure every learner have a good time and kept up. He created an environment where asking questions was encouraged, which really helped build my confidence in applying these skills. Thanks to his guidance, I have been able to apply what I learned to my work and continue developing my data analysis skills. I highly recommend Dr. Alvin to anyone looking to build a strong foundation in statistics and data analysis. Thank you again for your guidance and support, Dr. Alvin. (Posted on 3/24/2026)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 - Average Rating: 5.0/5 Review by Course Participant/Trainee
-
overall performance is good (Posted on 3/12/2026)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 - Average Rating: 5.0/5 Review by Course Participant/Trainee
-
N/A (Posted on 3/12/2026)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