The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.

Footnote on Calculating Regression: The regression on the Excel chart above is an exponential regression to match the logarithmic vertical axis. I used the Excel Growth function to draw the line.

The regression line is used as a point of analysis when attempting to determine the correlation between one independent variable and one dependent variable.

Daniel Hoyer, Calculating the Use-Wear Rates of Roman Coins Using Regression Analysis: A Case Study of Bronze Sestertii from Imperial Gaul, American Journal of Numismatics (1989-), Vol. 25 (2013), pp.

What Are Some Ways Linear Regression Can Be Applied in Business Settings?. During the course of operation, businesses accumulate all kinds of data such as numbers related to sales performance and ...

When multiple variables are associated with a response, the interpretation of a prediction equation is seldom simple.

This newest book in the series continues in this vein, opening with a refresher on the basic math needed for regression analysis, before teaching readers how to calculate regression equations, assess ...

It is the purpose of this article to describe how a logistic regression model, or a Cox regression model, can be defined in order to produce the output that is needed for assessment of biological ...