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