Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Enhance Your Employability with Certified Skills and Courses in Singapore - WSQ , IBF-STS, Skills Certification

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

Click the links below to apply. Note that you need to register the course first.

SkillsFuture Credit

For individuals, please submit your SkillsFuture Credit

SSG TG and AP Application

For companies, please fill in the required details for grant application. SSG Training Grant Application Form

Please do not pay up front. We will advise you on the eligibility and nett fee after registration

UTAP

Eligible NTUC members can apply for 50% cash rebate of the unfunded fee from UTAP, capped at $250 per year. Click here to submit UTAP

Course Code: TGS-2020500938

Course Booking

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

$298.00 (GST-exclusive)
$324.82 (GST-inclusive)

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 and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


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

SSG Training Grant

SSG TG is $15 per pax. Net fee after SSG TG is $309.82. Absentee Payroll is not eligible.

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’

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.

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)

Might 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
Perhaps have more examples to practice on, and also an instructional summary document of what we did with examples i.e. what to use, where to find the appropriate tool

Dont mind starting earlier so we dont have to rush towards the end. It was only the 3 of us but the time extended only from a few questions. (Posted on 6/25/2019)
Might 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
Course info states no prerequisites required to attend. I think there should be as the topics covered go beyond basic level for both statistics & knowledge of Excel.


To increase training time to maybe 1 & half days where half a day could be spent going through the basic & intermediate excel functions before embarking on the various modules later.
(Posted on 2/25/2019)
Might 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
Certificate was not given (though it was promised) when course was completed. (Posted on 2/10/2019)
Might 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
Classroom can be more conducive, in the sense that the doors can be stronger to block out external noises.

Tutor was good, but would be good to inform participants to have some basic knowledge of statistics, as it might be difficult for them to follow as there are many modules (Posted on 1/30/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/26/2018)
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
this course is too advanced for my needs.
trainer is very knowleageable (Posted on 11/26/2018)
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/23/2018)
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/23/2018)
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
need more examples and practice questions (Posted on 8/19/2018)
Might 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
Nil (Posted on 4/25/2018)
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
Mr Tan is very knowledgeable and uses different examples to Ensure we understood the training materials provided. Interactive and fun to attend his class. (Posted on 2/11/2018)
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
Probably extend an hour or so, else feel very rushed if you're not well familiar with Excel

But otherwise, the class is small, and the trainer (Mr Tan) can easily explained it on the spot if we have any questions. Very enriched in how Excel can do more functions than the basics I know. (Posted on 2/11/2018)
Might 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 hands on examples

Trainer is knowledgeable however topic taught is not too relevant to my daily work. Perhaps the trainer can shared how these excel skills can be applied to our daily work function. Thank you. (Posted on 1/23/2018)
Might 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
Practical case studies that allow the use of analytical tools learnt in the course. It will also helps if we were taught how to frame and report the results in writing. (Posted on 1/8/2018)
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
Notes can have finished examples so that we can practice at our own time.

Trainer is patient and has in depth knowledge in subject. Although time was short, he adequately went through the course. He also managed to explain the underlying concepts which I am grateful for. (Posted on 1/7/2018)
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
hough it was long hours in a day, the pace was just right. =) (Posted on 12/4/2017)
Might 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
Perhaps to differentiate into beginner, intermediate and advanced level.

Please minimise your admin staff from walking into the room. It is very distracting. (Posted on 11/28/2017)
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
The case studies used can be from real life. (Posted on 10/2/2017)
Might 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
Explanation at a slightly slower pace (Posted on 7/12/2017)
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
Very well organised and well presented. The trainer has an in-depth knowledge of the subject and is passionate about it. (Posted on 6/28/2017)

Items 41 to 60 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
    Attention: Captcha is case sensitive.

You May Be Interested In These Courses

WSQ – Data Visualisation with Tableau

WSQ – Data Visualisation with Tableau

218 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

62 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

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

WSQ - Data Storytelling with Tableau

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

WSQ – Software Automation with Excel VBA Programming

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

WSQ - Create Interactive Dashboard Using Excel

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