I am using Data which contain multi- collinearity between variables. the r-square was very low as well. When we aggregate the data using:
SPSS- Data- Aggregate,
the R- square become better, and the there become no more multi-collinearity between variables. the question is, can I use the new Data (aggregated data) instead of my original data and get the same results related to relationships between variables and R-square ?
Thank you,
Anas