## Predictive Analytics Using EXCEL

WHAT YOU'LL LEARN

• Learn how to solve real life problem using the Linear Regression technique
• Preliminary analysis of data using Univariate analysis before running Linear regression
• Predict future outcomes basis past data by implementing Simplest Machine Learning algorithm
• Understand how to interpret the result of Linear Regression model and translate them into actionable insight
• In-depth knowledge of data collection and data preprocessing for Machine Learning Linear Regression problem
• Course contains an end-to-end DIY project to implement your learnings from the lectures

WHO THIS COURSE IS FOR:

• Working Professionals beginning their Data journey
• Anyone curious to master Linear Regression in short span of time

COURSE CONTENT

• Getting Data Ready for Regression Model
• Univariate analysis and EDD
• Descriptive vs Predictive vs Prescriptive Analytics
• Descriptive Data Analytics in Excel
• Outlier Treatment
• Identifying and Treating Outliers in Excel
• Missing Value Imputation
• Identifying and treating missing values in Excel
• Variable Transformation in Excel
• Dummy variable creation: Handling qualitative data
• Dummy Variable Creation in Excel
• Correlation Analysis
• Correlation Coefficient in Excel
• Creating Correlation Matrix in Excel

CREATING REGRESSION MODEL

• The Problem Statement
• Basic Equations and Ordinary Least Squares (OLS) method
• Assessing accuracy of predicted coefficients
• Assessing Model Accuracy: RSE and R squared
• Creating Simple Linear Regression model
• Multiple Linear Regression
• The F - statistic
• Interpreting results of Categorical variables
• Creating Multiple Linear Regression model
• Excel: Running Linear Regression using Solver
• Multiple regression method for forecasting

WHAT IF ANALYSIS

• Transportation Problem in Excel using Goal Seek
• Profit Optimizer in Excel using Multiple Regression

Duration: 18 hours

#### Contact Number

+2 33318 403 - 33318 506

#### Contact information

• dummy33 El Messaha Street, Dokki A, Dokki, Giza Governorate, Egypt

• dummyP.O Box 12611

• dummy 16541 - +2 02 33318498

• dummy+2 02 37497928

• dummyinfo@eelu.edu.eg