How to do Regression Analysis in Excel

This video shows you how to perform a linear regression analysis in an Excel spreadsheet.

Three major uses for regression analysis are determining the strength of predictors, forecasting an effect, and trend forecasting.

First, the regression might be used to identify the strength of the effect that the independent variables have on a dependent variable. Typical questions are what is the strength of the relationship between dose and effect, sales and marketing spending, or age and income.

Currency Exchange Rates Forecasting in Excel