Take the 2-minute tour ×

Does anyone know how to use Excel to do multiple regession to show full and partial mediation using Baron and Kenny's method and alternatively Preacher and Hayes. I've been looking around for algorithms in R or even Statistica but most of these are blackboxes. If there are any datasets (that can be transferred or are in an .xls file) then it would be better.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Two references I could locate,

share|improve this answer
@nik thanks for this! I actually read the first site all the time but I haven't seen the MedGraph site :) –  user4100 Aug 7 '09 at 10:11
@pageman, I had two different references for Sobel, turns out, i messed up while linking.. just fixed that. –  nik Aug 7 '09 at 10:21

Your Answer


