Multiple Regression in Excel - Predict Results with Numerical & Non-Numerical Data with 3 Values!

Multiple Regression in Excel - Predict Results with Numerical & Non-Numerical (Categorical) Data with 3 Values!

In this video, you will learn how to Predict Results with Numerical & Non-Numerical (Categorical) Data with 3 Values, using Multiple Regression in Excel! You will learn how to predict a person’s “Salary” based on their “Age” and “Company”. So what is Multiple Regression? Multiple regression is a statistical technique used to understand the relationship between one dependent variable and two or more independent variables. An example of Numerical Data is Age (22, 37). An example of Non-Numerical Data is Company (Company A, Company B, Company C). Excel’s Regression data analysis tool cannot analyse non-numeric data such as Company A, Company B, Company C. You need to convert the non-numerical data to numeric form. Sounds interesting? Let’s dive in!

Other related resources to this video:
~ How to use Simple Linear Regression for Prediction with Excel!
~ Multiple Regression with Excel - How to predict the output based on multiple numerical variables!
~ Multiple Regression in Excel Predict Results with Numerical & Non Numerical Data with TWO (2) Values!
~ How to create a CORRELATION MATRIX for STOCKS with EXCEL!
~ How to run DESCRIPTIVE STATISTICS with EXCEL!
~ How to run Sentiment Analysis with Microsoft Excel!
~ How to create a Word Cloud with Microsoft Word!
~ How to find the CORRELATION for DRINK SALES with EXCEL!
~ Getting started with Minitab
~ Descriptive Statistics with Minitab
~ Correlogram with Minitab

By Cedric Ng,
AUTHOR of International Best Sellers,
~ “Predictive HR Analytics, Text Mining & ONA with Excel” &
~ “IISS: Employee Experience & Engagement with Predictive Analytics”