O'Reilly logo

Predictive Analytics: Microsoft® Excel by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2. Linear Regression

In This Chapter:

Correlation and Regression

Simple Regression

Multiple Regression

Assumptions Made in Regression Analysis

Using Excel’s Regression Tool

When two variables are related to one another, they are said to be correlated. Weight and height are correlated: Taller people tend to weigh more. Personal income and tax liabilities are correlated: People who make more money tend to pay more income taxes. Unit price and units sold are correlated: Other things being equal, the more that a product costs, the fewer units that you tend to sell.

Correlation and Regression

There are some important points hidden in the prior paragraph. One of them is the word tend. Most interesting pairs of variables do not move together in lockstep. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required