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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: