Data Analysis Tool Pak – Multiple Linear Regression (Excel 2010)

In this segment – I demonstrate the use of Data Analysis Tool Pak to build a multiple linear model using only Excel 2010 and basic interpretation of the results.

While the Data Analysis Toolpak does not replace a dedicated statistical tool, it does allow you to quickly check and do basic tests, analysis on Excel in a user friendly way, however it’s capabilities are limited and not recommended as a dedicated tool.

Demo on Time Series using Exponential Smoothing (IBM SPSS and Excel)

Following up on our last week’s Webex session on Logistic Regression for credit scoring (you can catch it here), this Sunday we will demonstrate the technique of exponential smoothing in time series forecasting.

More specifically, during the webinar we will take you through the basic decomposition of a time series into its components:

  • Trend
  • Seasonality
  • Cyclic
  • Error

We will concentrate on extracting and forecasting the trend and seasonality of a series. Trend component can be extracted using Exponential smoothing (Single, double and triple depending on the slope and pattern) and building a seasonal index to forecast the seasonal variation.

The webinar will demonstrate how this can be done using simple formulas on an excel sheet itself and then introduce the time series function in IBM SPSS. A basic introduction to Box-Jenkins (ARIMA) modelling will also be covered.

A trial version of IBM SPSS version 20 can be downloaded from here. (You will need to fill in some details). Those interested in attending the seminar can drop an email at info@learnanalytics.in or fill in the form at http://www.learnanalytics.in/contact.html  and we will mail you the webex invite. The webinar is scheduled on Sunday, 15th Jan, 0930 IST – 0400 GMT.

The webinar is free to attend.

To receive regular updates, please join our linkedin group Learn Analytics.