Tip :Regression Models using MS Excel

Did you know that you can create a regression tool in MS Excel for regression of upto 16 variables. You can automate it using record Macro feature even if you donot know Excel Macros.

SAS ETS and SPSS Trends can both make time series models. But so can MS Excel by linking up of cells. In addition you can use the solver add-in to minimize the square of the error term by changing the parameters of the exponential smoothening forecasts used.

Regression is one of the simplest technique to use, and is the industry standard for analytics, yet is sometimes overlooked for segmentation or decision trees to get even more simplicity.

Unknown's avatar

Author: Ajay Ohri

http://about.me/ajayohri

Leave a comment