Any good with statistics and presenting data?

englishpremier · 25 Feb 2010 at 18:23

Hi,

Just a quick question about a project i'm working on. If you had the data below (or similar) and had to present that in excel, which type of chart would you use?

Code:

Fake Comapny X created the X widget, does this supprise you? 				
			
Base // Hardcore enthusiasts // mild enthusiasts
			
Base		529	//347 //99
	A lot	7%	7%	9%
	A little	33%	32%	36%
	Not at all	60%	61%	55%

I'm thinking a stacked bar chart but presumably one of you guys out their is a statistician and has another opinion.

Cheers

platinum87 · 25 Feb 2010 at 18:56

You could do 3 pie charts, if you want to pad a bit

im a bit confused by the way the data is written, not 100% sure wtf is going on

californiadream · 25 Feb 2010 at 19:04

Also slightly confused by the layout of the data but whilst I guess you could go with pie charts I've always been taught that bars are the way to go as people have a harder time decoding and measuring difference from pie charts (area) than they do from bars (length).

Destination · 25 Feb 2010 at 19:34

Yes it surprises me, why are the fanbois not jumping all over it like a rash.
Do a correlation between the usergroups and find if there is a statistic difference between the groups and their appreciation. On non-scientific investigation it would seem there is little to no statistical difference, so Fake Company X have really really fluffed up on either marketing, or the value of the product.
Probably marketing, as people are stupid and will buy any tosh if they are fanbois.

Now get me S and p values!