In a multiple regression with 16k cases 2 IV (non-normally distributed) and one dependent variable that is also not normally distributed. DV see below:
I've tried three ways of transforming the DV (sqrt/ln/log) to normal but the K-S statistic reports it clearly as non-normal .
The best I could come up with was the ln or log transformation, which clearly shows a trend in the detrended qq plot. Any ideas how to "fine-tune" the ln transformation to remove that trend?
Now I've performed the same ln-transformation which on both the IV which were also not normally distributed. The result of the transformation is shown below:
My approach was instead of trying harder to better transform the IV and DV, to bootstrap the regression in spss and and use the ln_RT_vol_in as the DV and ln_AT_vol_in and ln_FF_vol_in as the predictors. The residuals look fine at least the histogram.
The regression without bootstrapping:
/STATISTICS COEFF OUTS CI(95) R ANOVA COLLIN TOL
/METHOD=ENTER LN_AT_vol_in LN_AT_bin_in_deg
/RESIDUALS DURBIN HISTOGRAM(ZRESID) NORMPROB(ZRESID).
And with bootstrapping. I have the same B values but slightly bigger confidence intervals for the bootstrapped version and a slightly less see below.
/VARIABLES TARGET=LN_RT_vol_in INPUT= LN_AT_vol_in LN_AT_bin_in_deg
/CRITERIA CILEVEL=95 CITYPE=PERCENTILE NSAMPLES=1000
What do you think of this approach? Do you have any comments on how to improve the transformation in order to maybe get rid of the trend in the de-trended versions of the qqplots?
Another problem is that the bootstrapping doesnt seem to fit the 1000 samples in my memory instead only 49 see below. What can I do about it apart from increasing my mem?