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

Our site on Google map