Skip to main content
1 of 7

Linear/Non-linear Regression - SPSS

Hopefully somebody will be able to shed some light on my SPSS problems!

I have been given 65 values. 57 of these data values are quarterly results and 8 are the holdback data to be used.

I have to do:

  • Regression with Dummy variables with a linear trend cycle component
  • Dummy variables with a nonlinear trend cycle component

Does anyone know what to do as my results aren't making much sense?

For the first part - I obviously split the data into dummy variables for the relevant quarters (Q1-Q4).

I then performed regression analysis - linear. But all my values are extremely large and not significant. Also Q2 has been listed as 'excluded variables' in the results? I have followed the steps and I am unsure why this has happened.

Then I thought of removing Q4, due to multi-collinearity but again the values are still quite large (>.450).

Not sure if I am doing something wrong at the start (especially with the excluded variables aspect)

Anybody got any idea? This is driving me nuts