Course Details
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
Final Assessment
- Practical Performance (PP)
- Oral Questioning (OQ)
Course Info
Promotion Code
Promo or discount cannot be applied to WSQ courses
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 can download and install the following software:
Hardware: Windows and Mac Laptops
About Progressive Wage Model (PWM)
The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity.
Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.
For more information on PWM, please visit MOM site.
Funding Eligility Criteria
| Individual Sponsored Trainee | Employer Sponsored Trainee |
|
|
|
SkillsFuture Credit:
PSEA:
|
Absentee Payroll (AP) Funding:
SFEC:
|
Steps to Apply Skills Future Claim
- The staff will send you an invoice with the fee breakdown.
- Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
- Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
- Upload your invoice and click ‘Submit’
SkillsFuture Level-Up Program
The SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme
Get Additional Course Fee Support Up to $500 under UTAP
The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).
For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)
Steps to Apply UTAP
- Log in to your U Portal account to submit your UTAP application upon completion of the course.
Note
- SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
- All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
- An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount will be paid to training provider first and claimed after end of class by learner.
Appeal Process
- The candidate has the right to disagree with the assessment decision made by the assessor.
- When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
- If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
- If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
- If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
- If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
- The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
- The candidate must lodge the appeal within 7 days, giving reasons for appeal
- The assessor can help the candidate with writing and lodging the appeal.
- he assessment manager will collect information from the candidate & assessor and give a final decision.
- A record of the appeal and any subsequent actions and findings will be made.
- An Assessment Appeal Panel will be formed to review and give a decision.
- The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
- The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
- Please click the link below to fill up the Candidates Appeal Form.
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
Dr Alvin Ang: Dr Alvin Ang is an ACLP-certified trainer with a Ph.D. in Operations Research from Nanyang Technological University and over a decade of teaching and research experience . He has lectured at NTU, SUSS, Curtin University, and as an IBM Data Science Instructor, specializing in statistics, quantitative analysis, and data-driven decision-making. As the founder of DataFrens.sg, he has built a strong community for advancing applied data science in Singapore.
In his Excel-based statistical training, Dr Ang emphasizes practical application of statistical concepts for beginners. His sessions guide learners through data cleaning, descriptive and inferential statistics, and visualization using Excel tools. By blending academic rigor with industry-relevant examples, he equips participants to confidently apply Excel for statistical analysis and translate raw data into meaningful insights for business and research purposes.
Tan Khiang Meng: Tan Khiang Meng is a seasoned data analytics and business intelligence professional with extensive experience in applying statistical methods for performance tracking and operational optimization. With a strong background in Microsoft Excel, data modeling, and visualization, he has guided organizations in using descriptive and inferential statistics to make informed decisions. Over the past two decades, he has trained professionals across industries on data literacy, reporting automation, and analytical thinking, emphasizing clarity and precision in data interpretation.
In “Statistical Data Analysis with Excel for Beginners,” Khiang Meng introduces participants to the foundational concepts of statistics through hands-on exercises using Excel. His sessions cover descriptive analysis, data visualization, and hypothesis testing, focusing on real-world applications in business and research. By simplifying complex concepts, he helps learners build confidence in applying statistical tools to uncover trends, analyze variability, and support data-driven decisions effectively.
Jim Gan Chiu Liang: Jim Gan Chiu Liang is a data analytics and automation specialist with over 15 years of experience in financial modeling, process optimization, and Excel-based business solutions. His expertise includes developing statistical models and dynamic dashboards to support performance analysis and decision-making. With a practical teaching approach, Jim bridges theory with real-world applications, helping learners understand how statistical techniques can be integrated into daily business operations using Excel’s built-in tools and functions.
In “Statistical Data Analysis with Excel for Beginners,” Jim guides participants through step-by-step exercises in data preparation, analysis, and visualization. His sessions focus on applying Excel functions such as descriptive statistics, correlation, regression, and probability tools to analyze real datasets. By combining hands-on learning with relatable business scenarios, he empowers learners to gain practical skills in statistical thinking and use Excel confidently as an analytical tool.
Dwight Nuwan Fonseka: Dwight Nuwan Fonseka is a data engineer and analytics professional specializing in data visualization, automation, and statistical modeling. With expertise in Excel, Power BI, and Python, he has delivered data-driven insights that enhance business decision-making across multiple sectors, including finance and education. Dwight’s teaching philosophy centers on simplifying complex analytical concepts, making statistical methods accessible even to beginners in data analytics.
In “Statistical Data Analysis with Excel for Beginners,” Dwight helps learners grasp the core principles of statistical analysis through applied learning. His sessions cover organizing data, generating descriptive statistics, and creating visual summaries using charts and pivot tables. By integrating real-world examples and Excel-based techniques, he equips participants with the foundational skills needed to interpret data confidently and make evidence-based business decisions.
Liew Sing Loon: 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.
Customer Reviews (71)
- will recommend Review by Course Participant/Trainee
-
. (Posted on 8/4/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 - Thanks. Highly Recommend. Review by Course Participant/Trainee
-
Attended two courses conducted by Dr Alvin. He is patient and willing to impart lot of knowledge which applicable to my current job. Thanks. Highly Recommend. (Posted on 7/13/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 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) - will recommend Review by Course Participant/Trainee
-
. (Posted on 12/27/2021)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
-
. (Posted on 12/27/2021)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
-
. (Posted on 12/26/2021)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
-
. (Posted on 12/26/2021)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
-
. (Posted on 12/26/2021)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 Ang is knowledgeable and friendly. Review by Course Participant/Trainee
-
Dr Ang is knowledgeable and friendly. The class was interactive and interesting. (Posted on 12/21/2021)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
-
. (Posted on 11/29/2021)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 - Excellent teaching. Review by Course Participant/Trainee
-
Provide hard copy notes.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
Excellent instructor.
Excellent teaching.
Excellent materials. (Posted on 11/29/2021) - will recommend Review by Course Participant/Trainee
-
Dr. Alvin is experienced and knowledgeable in his field (Posted on 11/29/2021)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 Ang is very knowledgea on the statistics and can explain in layman terms to make us understand the topic easily. Review by Course Participant/Trainee
-
Make the content more applicable to current busines/ working requirements and maybe spread out into 1.5 days training to allow more discussions and practice (Posted on 10/26/2021)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
-
Dr Alvin Ang is very knowledgable and we could better understand with the examples he used. (Posted on 10/26/2021)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
-
. (Posted on 10/25/2021)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
-
so far is good, trainer is patient and give ample time to let us understand teh concept (Posted on 9/9/2021)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








