Technical

Exponential Regression using Excel

Exponential Regression with Linear Model

In this video, we discuss another technique for making predictions on Time Series Data, i.e. Exponential Regression using Linear Model.

We try to predict the Dependent Variable for 1 Independent Variable.

Optimising Exponential Regression using Solver

The Exponential Regression using a Linear Model suffers from the shortcoming that it doesn’t actually minimise the sum of the squares of the deviations. We now show how to use Solver to create a better, nonlinear, regression model.

Exponential Regression using LOGEST()

In this video, I discuss how we can conduct Exponential Regression using Excel Function LOGEST().

I also discuss how we can make predictions using Excel function GROWTH().

Multi Variate Exponential Regression

We round up our discussion on Exponential Regression with discussion on how to conduct Exponential Regression when we have to deal with more than 1 Independent Variables. We will use the LOGEST() and GROWTH() functions. We will see how we can use Data Analysis Toolkit.

Advertisements

This site uses Akismet to reduce spam. Learn how your comment data is processed.