GATEWAY CONSULTING SINGAPORE

The AIDA course will be conducted over 3 consecutive days, covering 7 lectures on data analytics principles and techniques, 4 lab sessions in which participants get to acquire basic data analytics skills and training on the use of the CHATGPT-PLUS Advanced Statistical Analysis system.

Participants are required to bring their own notebook/laptop computer for the lab sessions and to have ChatGPT-Plus pre-installed for the Labs (licence fee of USD$20 to be paid by participant)

(no coding is needed).

Unit 1. Exploratory Data Analysis

1.1 What is Exploratory Data Analysis?

1.2 How to check for coding errors

1.3 How to tell extreme values (outliers) from coding errors

1.4 Importance of understanding study variables and their distributions

1.5 Types of missing values and how to handle them

Unit 2. Processing and Summaring Data

2.1 Why the need to process and summarize data

2.2 Descriptive vs Inferential Statistical Methods

2.3 What to know about Descriptive Statistical Methods

2.4 Importance of knowing statistical distributions including the Normal Distribution

Unit 3. Data Visualization

3.1 Why visualize data?

3.2 Techniques of visualizing data for Measurement and Non-Measurement data

3.3. Deciding between Tables vs Graphs

3.4 How not to be misled by data visualizations

3.5 Usefulness of Dashboard and their do’s and dont’s

Unit 4. Statistical Estimation and Hypothesis Testing

4.1 Understanding Statistical Estimation

4.2 Understanding the difference between standard deviation and standard error

4.3 Understanding the 95% Confidence Interval to derive a Statistical Estimate

4.4 Understanding the statistical concept of Sampling Distribution

4.5 Understanding the statistical concept and mechanics of Hypothesis Testing

Unit 5. Dealing with Measurement Data

5.1 Statistical concepts associated with Hypothesis Testing

5.2 Understanding Null Hypothesis, p-value and interpretation of test outcomes

5.3 Statistical tests involving 2-group measurement data

5.4 Statistical tests involving multi-group measurement data

5.5 Non-parametric tests for measurement data

Unit 6. Dealing with Non-Measurement Data

6.1 Understanding the concept of statistical association

6.2 When to use the chi-square test for statistical association

6.3 When to apply the chi-square test with continuity for correction

6.4 Fisher’s Exact Probability Test for very small sample size

6.5 Dealing with matched data – application of McNemar’s Test

Unit 7. Statistical Correlation and Regression

7.1 What is predictive analytics?

7.2 Predicting one outcome variable from a predictor variable – simple linear regression

7.3 Predicting one measurement outcome variable from several predictor variables – multiple linear regression

7.4 Predicting one binary outcome variable from several predictor variables – multiple logistic regression

7.5 Misuses of regression techniques in predictive analytics