Data Validation and Statistical Analysis with Excel

Perform the statistical validation component for the role of a junior data scientist, Statistician and/or Researcher.

Validate dataset statistically to support data analysis and modelling

Explore on data distribution and identify statistical anomalies

Compute Statistical Indicators for the dataset

Check normality assumption for a data series

Perform statistical test and validation on dataset

Conduct further statistical analysis

What You'll Learn

Effective data science project relies on one critical aspect, data quality. With the right data quality, statistical analysis can then take place which translates data into meaningful insights for businesses. Data Validation plays an important role in ensuring the data is correct and useful in preparation for analysis.

This course is designed to introduce the general concepts of Data Science with a focus on Data Validation and Statistical Analysis for participants with non-programming backgrounds. By the end of this course, participants will be able to leverage on Excel for Data Validation and Statistical Analysis.

Minimum Entry Requirement

Recommend to complete Aacdemy's

• Foundation of Data Science
• Data Wrangling and Preparation with Excel

Some literacy and competency in basic mathematics, statistics and Microsoft Excel.