## Multiple Linear Regression Analysis in Excel

In a previous article, we explored Linear Regression Analysis and its application in financial analysis and modeling. You can read our Regression Analysis in Financial Modeling article to gain more insight into the statistical concepts employed in the method and where it finds application within finance. This article will take Read more…

## Regression Analysis in Financial Modeling

Regression Analysis represents a set of statistical methods and techniques, which we use to evaluate the relationship between variables. These are one dependent variable (our target) and one or more independent variables (predictors). We have three primary variants of regression – simple linear, multiple linear, and non-linear. However, most of Read more…

## Seasonality and Trend Forecast with Regression in Excel

In our last article, we discussed Seasonality in Financial Modeling and Analysis. We went over an example Excel model of calculating a forecast with seasonality indexes. Today we will use regression analysis in Excel to forecast a data set with both seasonality and trend. Let’s look at the quarterly sales Read more…