WSQ , IBF, SkillsFuture, PEI Approved Training Provider

Statistical Data Analysis Training with Excel

Embrace the power of Excel in the realm of statistical data analysis with our specialized training. This course covers a wide array of topics from fundamental statistical concepts, hypothesis testing, to advanced methods like Bayesian probability analysis and simulation. With hands-on experience, learners will become proficient in using the Excel Data Analysis Tool, enabling them to handle large data sets efficiently and with precision.

Additionally, topics like correlation analysis, analysis of variance, and regression are meticulously explained, ensuring participants are well-equipped to draw meaningful conclusions from complex datasets. Whether you're an analyst, student, or a professional looking to enhance your data interpretation skills, this training is a pivotal step in your journey to becoming a data-driven decision maker.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

For WSQ funding, please checkout the details at WSQ - Statistical Data Analysis with Excel for Beginners

Course Code: C201

Fee

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

The course fee listed above is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

Course Date

* Required Fields

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.

Course Cancellation/Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
  • 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

Topic 1 Basic Statistics

  • Why Statistics Matter
  • Types of Data
  • Descriptive Statistics
  • Probability and Conditional Probability
  • Probability Distributions
  • Install Excel Data 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

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • 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.

Target Age Group: 21-65 years old

Minimum Software/Hardware Requirement

Software:

You can download and install the following software:

Hardware: Windows and Mac Laptops

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

Jim Gan Chiu Liang: Jim Gan Chiu Liang is a ACTA certified trainer. Jim Gan Chiu Liang obtained his Master of Technology (M.Tech Knowledge Engineering) from National University of Singapore (NUS) Institute of System Science

He is currently working as adjunct trainer at PACE (Professional Adult Continuing Education) Academy, Singapore Polytechnic. His past experience included being a chief instructor for Kumon Education.

Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally.

Liew Sing Loon: Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.

In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).

Customer Reviews (62)

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 5/24/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 5/23/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 5/23/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 11/22/2020)
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 7/14/2020)
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
May be the trainer can slow down a bit but overall everything are fine and excellent.

Trainer is very experience and professional even the class is conduct in virtual Classroom using Zoom. Apologised for the addressing the system issue as my laptop is quite old. (Posted on 6/29/2020)
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
more coverage on ANOVA(single/multiple factor) and regression (Posted on 6/14/2020)
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
Will be helpful to provide clearer examples to practise on.

Trainer is very helpful, honest and patient in answering questions. Course was conducted at a good pace allowing me to read and ask questions. Will be smoother if trainer is more familiar with common but advanced functions in excel eg ANOVA, regression. (Posted on 6/14/2020)
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
It is better through classroom based (Posted on 4/28/2020)
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 2/24/2020)
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 2/24/2020)
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/24/2019)
Trainer was very helpful. 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
Classroom is not clean. (Posted on 12/24/2019)
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 11/25/2019)
might consider 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 11/25/2019)
might consider 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 11/25/2019)
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 11/25/2019)
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 11/17/2019)
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 10/21/2019)
Might Consider 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 9/23/2019)

Items 21 to 40 of 62 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Write Your Own Review

You're reviewing: Statistical Data Analysis Training with Excel

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
  • Reload captcha

You May Be Interested In These Courses

WSQ - Data Visualisation with Tableau

WSQ - Data Visualisation with Tableau

375 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Statistical Data Analysis with Excel for Beginners

WSQ - Statistical Data Analysis with Excel for Beginners

71 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI

WSQ - Data Analytics and Visualization with Power BI

266 Review(s)
$800.00 (GST-exclusive)
$872.00 (GST-inclusive)
WSQ - Data Storytelling with Tableau

WSQ - Data Storytelling with Tableau

41 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Software Automation with Excel VBA Programming

WSQ - Software Automation with Excel VBA Programming

89 Review(s)
$750.00 (GST-exclusive)
$817.50 (GST-inclusive)
WSQ - Create Interactive Dashboard Using Excel

WSQ - Create Interactive Dashboard Using Excel

75 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)