Home > statistics > Damn those businesses!

Damn those businesses!

So many times you’ve in a situation where Excel is your god-sent tool. Yeap, I’m talking about statistics & excel, the 8th sin! I found myself tutoring a couple of days ago and I found myself stuck with Excel. How to perform a stepwise procedure overcoming the burden of VB (which I know nothing about it) or defining cell functions?

There is an add-in that comes handy I must admit, Stepwise Regression Add-In. There is one or two problems when installing and I had a problem with variables names (I solved it using the usual notation x1,x2,…,xn,y I suggest you do the same) but it’s overall good. When in a situation as mine , use it!

  1. No comments yet.
  1. No trackbacks yet.

Leave a comment