Statistical Data Analysis with Excel for Beginners
About This Course
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.
What You'll Learn
- perform data analysis with descriptive statistics, probability theory and probability distributions,
- perform data analysis with sampling theory and hypothesis tastings
- perform data analysis with regression and correlation analysis.
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
Entry Requirements
Knowledge and Skills
• Able to operate 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