• Home
  • WSQ - Statistical Data Analysis with Excel for Beginners

WSQ - Statistical Data Analysis with Excel for Beginners

Course Information

  • Sessions 1 day
  • Duration 8 hrs
  • Level Beginner
  • Assessment 1 hr

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Skills Framework

TSC Title
Data and Statistical Analytics
TSC Code
PTP-BIN-4055-1.1

Funding Validity

Funding for this course is valid from 1 Sep 2020 to 31 Aug 2026. Register and complete the course within this period to qualify for funding support.

Learning Outcomes

By the end of the course, learners will be able to 

  • LO1: Perform data analysis with descriptive statistics, probability theory and probability distributions.
  • LO2: Perform data analysis with sampling theory and hypothesis tastings.
  • LO3: Perform data analysis with regression and correlation analysis.

Course Brochure

Download Course Brochure

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.
  • OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

WSQ - Statistical Data Analysis with Excel for Beginners

Course Code: TGS-2020505317
  • WSQ
  • SFC
  • PSEA
  • UTAP
  • SFEC
  • Absentee Payroll
  • MCES

71 Review(s) | Add Your Review

Share

What's This Course About

Kickstart your journey into the world of data analytics with our WSQ-endorsed course on Statistical Data Analysis with Excel for Beginners. This course is tailored for those who are new to data analysis, covering foundational topics like basic statistical formulas, data sorting, and introductory data visualization. Through practical exercises and real-world case studies, you’ll learn how to use Excel to process and interpret data in a meaningful way.

Upon completing the course, you’ll have the basic skills needed to handle datasets and perform statistical analysis in Excel. You’ll be equipped to create basic charts, apply statistical formulas, and interpret data for decision-making purposes. This course serves as a stepping stone for anyone looking to make more informed decisions based on data, be it in a professional setting or for personal projects.

WSQ Funding

Full Fee $350.00 Before GST
GST $31.50 9% of fee
Baseline Nett $206.50 SG/PR age 21+ · 50% funded
MCES / SME Nett $136.50 SG age 40+ · 70% funded
SkillsFuture Enterprise Credit (SFEC)

Eligible Singapore-registered companies can tap on $10000 SFEC to cover out-of-pocket expenses.

View on SkillsFuture for Business

SkillsFuture Credit (SFC)

Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used.

Direct Application on SkillsFuture Portal

UTAP

Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year.

Submit UTAP Claim

PSEA

Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.

Check PSEA Eligibility

  • Scroll down to “Keyword Tags” to verify for PSEA eligibility.
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form, then submit the completed form to us:

PSEA Withdrawal FormSubmit PSEA Form

Course FeeBefore Funding

$350.00 (GST-exclusive)
$381.50 (GST-inclusive)

Course Date

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

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

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
  • Singapore Citizens or Singapore Permanent Residents of age 21 and above
  • From 1 October 2023, attendance-taking for SWDA's (formerly SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.​
  • Trainee must pass all prescribed tests / assessments and attain 100% competency.
  • We reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria.
  • Singapore Citizens or Singapore Permanent Residents who are DIRECT EMPLOYEE of the sponsoring company.
  • From 1 October 2023, attendance-taking for SWDA's (formerly SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.​
  • Trainee must pass all prescribed tests / assessments and attain 100% competency.
  • We reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria.

 SkillsFuture Credit: 

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

 PSEA:

  • To check for Post-Secondary Education Account (PSEA) eligibility, goto mySkillsFuture portal and search for this course code.
  • Scroll down to "Keyword Tags" to verify for PSEA eligibility.
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.  
  • And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA. 
  • Not all courses are eligible for PSEA funding.

 Absentee Payroll (AP) Funding: 

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year.
  • AP funding will be computed based on the actual number of training hours attended by the trainee.

 SFEC:

  • If the Training Provider has submitted an enrolment for course fee grant claim in Training Partners Gateway (TPGateway), SWDA would be able to derive SFEC funding based on this record. There is no need for enterprise to submit any claim request and the SFEC claim will be automatically generated and disbursed.
  • Where there is no such record, eligible employers are required to submit an SFEC claim after course completion via the SFEC microsite.
  • SkillsFuture Enterprise Credit (SFEC) Microsite 

 

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

  • SWDA 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

  1. The candidate has the right to disagree with the assessment decision made by the assessor.
  2. When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
  3. If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
  4. If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
  5. If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
  6. 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.
  7. The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
  8. The candidate must lodge the appeal within 7 days, giving reasons for appeal 
  9. The assessor can help the candidate with writing and lodging the appeal.
  10. he assessment manager will collect information from the candidate & assessor and give a final decision.
  11. A record of the appeal and any subsequent actions and findings will be made.
  12. An Assessment Appeal Panel will be formed to review and give a decision.
  13. The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
  14. The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
  15. Please click the link below to fill up the Candidates Appeal Form.

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 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 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.
Jim Gan Chiu Liang is an experienced software developer and data automation specialist with over 15 years of experience in designing and implementing Microsoft Excel VBA solutions for business process optimization. His expertise lies in developing automated workflows, interactive dashboards, and complex financial models that reduce manual workload and improve data accuracy. Jim has worked with organizations across finance, logistics, and education sectors, helping them leverage Excel’s advanced programming capabilities to drive efficiency and decision-making.
Dwight Nuwan Fonseka is Head of Data Science at Plano Pte. Ltd. and an ACLP-certified trainer with deep expertise in data analytics, machine learning, and AI applications. He has extensive hands-on experience developing predictive models, RShiny dashboards, and deep learning solutions using R, Python, TensorFlow, and Keras. With a strong professional background in healthcare, finance, and customer analytics, Dwight brings an applied perspective to teaching AI, focusing on both the opportunities and risks of emerging technologies.

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 (71)

I enjoyed attending the WSQ Statistics with Dr. Alvin Ang 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 course presenter has exceed expectations and recommend to mantain his teaching style and method
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
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
may be more work shops or homework for practice or refresher
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
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 12/27/2021)
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 12/27/2021)
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 12/26/2021)

Items 46 to 50 of 71 total

per page
Page:
  1. 1
  2. ...
  3. 8
  4. 9
  5. 10
  6. 11
  7. 12
  8. ...
  9. 15

Write Your Own Review

You're reviewing: WSQ - Statistical Data Analysis with Excel for Beginners

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