Put a Pin on the Map View my Forum Guestmap
Free Guestmaps by Bravenet.com

The Old Acclaimed Music Forum

Go to the NEW FORUM

Music, music, music...
Start a New Topic 
Author
Comment
Attn Henrik: Statistics question

When you did that factor analysis for the 2009 album poll, how did you do it? Do you have a program that does it for you or did you run the analysis yourself? If it's a program, where can I get it?

Re: Attn Henrik: Statistics question

I think I did it all in Excel. It required a bit of manual work but hopefully it's merely just copy and paste for you. I don't have time to look closer into this right now. Remind me if you don't hear from me again soon.

Re: Attn Henrik: Statistics question

I found this program Plainstat on the web that just lets you load stuff in from a text file. I didn't know you could do it all directly from Excel.

I'm going to test it with the 00's movie poll data.

Re: Attn Henrik: Statistics question

I checked it and it turns out that what I did in Excel was a time-consuming and complicated thing that after all didn't work as well as the traditional factor analysis (that I didn't do in Excel). However, even with the factor analysis I used Excel to present the data in a scatter plot. If you also want to visualize your data you may want to use it as a template. Here it is.

Re: Attn Henrik: Statistics question

Does anyone know of a free programme for Windows in the vein of Plainstat? I'm looking to analyse some end of year lists for Factor Analysis, Pearson's and so on. Trying to do it in Excel looks like an nightmare (speaking as Statistician as well!)

Any help much appreciated

Re: Attn Henrik: Statistics question

SPSS is perfect for factor analysis, maybe there's some trial version available for it. Alternatively, if you're still in university like me you can usually get it for close to nothing.

Re: Attn Henrik: Statistics question

Just to get back to this, it is indeed possible to get a 14 day trial of SPSS here. I've been using SPSS for quite a while, but it is like $2000+ to buy, whereas I paid some $15. It's possible get download it illegally as well, but that requires some effort to get running.