Tell me more ×
Cross Validated is a question and answer site for statisticians, data analysts, data miners and data visualization experts. It's 100% free, no registration required.
up vote 1 down vote favorite

Does anyone know of an existing implementation of ordinal logistic regression in Excel?

share|improve this question
does the following link help ? archives.math.utk.edu/ICTCM/VOL13/C013/paper.html – ayush biyani May 12 '11 at 9:04
yeah... I was looking at that earlier... It's good tutorial on how to use solver.. but it's less specific when it comes to ins and outs of ordianl logistic regression – user333 May 12 '11 at 10:25

3 Answers

up vote 5 down vote accepted

It sounds like your goal is didactic; that you are trying to explain ordinal logistic to some group of people. I have used Excel for this sort of thing when the topic is much simpler - e.g., crosstabs and chi-square - so that there is some intuition about the formulas.

I don't think that will be the case here. Even if you could find (or create) an Excel spreadsheet that does this, I think the intermediate steps are so numerous that it will not be clear to any audience that could not follow a more usual explanation of ordinal logistic.

I would use some standard software and give different examples. I've written a talk doing this, using SAS, but it could be done using R or whatever.

share|improve this answer
up vote 4 down vote

It's difficult to recommend Excel (which has shown itself to be unreliable for simpler problems than the one posed) when R has well worked-out packages for this.

share|improve this answer
Agree. But I need it in excel for demostration purpose. Excel is very transparent.. shows every estimation step. – user333 May 12 '11 at 12:29
1  
Not a good idea to demonstrate an untrustworthy platform, in my humble opinion. Plus you will limit yourself quit a bit in terms of features implemented. – Frank Harrell May 12 '11 at 21:07
Thanks Frank. I will be not demostrating the platform but the ordianl logistic regression concept. Transparent simple example in excel will do that very efficiently... I'd say. – user333 May 13 '11 at 9:21
up vote 2 down vote

Since you just need it for demonstration, how about using Minitab? It is similarly transparent.

RExcel looks promising too.

Of course, both of these options are somewhat opaque because all of the software is proprietary, closed-source software. You could also try R and Calc, which uses open-source software. (I know that's not what you meant by transparent.)

share|improve this answer
Thanks Thomas. When I say transparent. I mean something like excel which allows me to see every step of the calculation. – user333 May 13 '11 at 9:23
I don't need to see/know/understand source code of the platform I'm using... – user333 May 13 '11 at 9:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.