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:

REGRESSION 
/MISSING LISTWISE 
/STATISTICS COEFF OUTS CI(95) R ANOVA COLLIN TOL 
/CRITERIA=PIN(.05) POUT(.10) 
/NOORIGIN 
/DEPENDENT LN_RT_vol_in 
/METHOD=ENTER LN_AT_vol_in LN_AT_bin_in_deg 
/PARTIALPLOT ALL 
/SCATTERPLOT=(*ZRESID ,*ZPRED) 
/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.

BOOTSTRAP 
/SAMPLING METHOD=SIMPLE 
/VARIABLES TARGET=LN_RT_vol_in INPUT=  LN_AT_vol_in LN_AT_bin_in_deg 
/CRITERIA CILEVEL=95 CITYPE=PERCENTILE  NSAMPLES=1000 
/MISSING USERMISSING=EXCLUDE.

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?

Best Regards Thomas

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:

REGRESSION 
/MISSING LISTWISE 
/STATISTICS COEFF OUTS CI(95) R ANOVA COLLIN TOL 
/CRITERIA=PIN(.05) POUT(.10) 
/NOORIGIN 
/DEPENDENT LN_RT_vol_in 
/METHOD=ENTER LN_AT_vol_in LN_AT_bin_in_deg 
/PARTIALPLOT ALL 
/SCATTERPLOT=(*ZRESID ,*ZPRED) 
/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.

BOOTSTRAP 
/SAMPLING METHOD=SIMPLE 
/VARIABLES TARGET=LN_RT_vol_in INPUT=  LN_AT_vol_in LN_AT_bin_in_deg 
/CRITERIA CILEVEL=95 CITYPE=PERCENTILE  NSAMPLES=1000 
/MISSING USERMISSING=EXCLUDE.

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?