Multivariate statistics

paulinoluciano

New Member
Joined
Dec 12, 2005
Messages
11
"Have you some sheet or add in devoted to perform multivariate statistics (including discriminant analysis and principal component analysis) using excel?"
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

mightymishra

Board Regular
Joined
Oct 18, 2002
Messages
65
have you checked <xlstat>.
its a nice tool, but for such heavy analysis i believe SPSS is more flexible.
 

paulinoluciano

New Member
Joined
Dec 12, 2005
Messages
11
Yes, I have checked. However, I would like to use some excel application in order to perform multivariate statistics.
 

wellinth

Board Regular
Joined
Aug 6, 2004
Messages
57
There is an Excel add-in called XLSTAT-Pro which does both discriminant analysis and PCA. When installed, it creates an extra pull down menu in Excel with several dozen multivariate statistical procedures.

For more information, including how much it costs, go to www.xlstat.com. I think you can download a free thirty day trial of it at this URL. I've use an old version of this add-in and I like it. I payed about $250 and it was worth it.

Regards,

- Tom Wellington

e-mail: thomaswellington@msn.com
 

Watch MrExcel Video

Forum statistics

Threads
1,118,386
Messages
5,571,829
Members
412,421
Latest member
grace_abar
Top