Stats raving mad

The blog

Damn those businesses!

by M. Parzakonis on December 27, 2009

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!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">