Need help? We are glad to help you
Find out how to contact us here.
Domain:
Digitalisation; Infocomm Technology & Smart Systems; Our Core Competencies
Content Type:
Classroom
Course Code:
CRPAME1
Remark:
You should have attended CSC’s Data Analytics - Basic Principles and Applications (CRDDA10/CRDDAVL) programme, or are familiar with basic data analytics. You should also be familiar with foundational statistical concepts and are very comfortable with Excel & its basic functions. After registration, you will be required to complete a pre-programme survey form that allows us to to assess your suitability for the programme.
Who Should Attend:
You are a Singapore Public Officer who is an individual contributor and interested in doing predictive analytics work with Excel.
Programme Overview
Would you like to generate relevant and useful insights from existing data so that you can better predict and support decision making at your workplace?
When harnessed right, Excel would allow you to do that and more. Sign up for this programme today and you will learn not only how to apply fundamental predictive analysis techniques to data using tools that already exist in Excel, you will also learn techniques like time series and advanced forecasting, and linear and logistic regression.
When harnessed right, Excel would allow you to do that and more. Sign up for this programme today and you will learn not only how to apply fundamental predictive analysis techniques to data using tools that already exist in Excel, you will also learn techniques like time series and advanced forecasting, and linear and logistic regression.
Learning Outcomes
- Demonstrate the ability to forecast time series using different methods like moving averages and exponential smoothing
- Describe advanced forecasting techniques (e.g. Holt Winters model) for time series with seasonality and trend
- Apply and make predictions (of numbers) using the regression tool in Excel
- Explain how logistic regression can be used to predict classes (or categories)
Last updated:
Time series forecasting
- Forecasting with moving averages
- Exponential smoothing and smoothing constant
- Forecasting using Excel’s Exponential Smoothing tool
- Using Excel Solver to choose smoothing constant
- Limitations of data-driven forecasting
Advanced forecasting techniques
- Understanding seasonality and trend
- Holt Winters model
Linear regression
- Use cases for linear regression
- Principle of correlation
- Simple and multiple linear regression
- Performing regression using Excel’s Regression tool
Logistic regression
- Use cases for logistic regression
- Concept of odds and maximum likelihood
- Introduction to logit function
- Setting up logistic regression in Excel
- Using Solver to perform logistic regression
- Probability of correct classification (validating model)