ed
Member
Registered: 10th Sep 03
User status: Offline
|
Not sure where else to ask apart from my favourite general purpose internet forum, so here goes...
I've used CONFIDENCE(alpha,std_dev,size) to calculate a 90% confidence interval which is for example: 0.008192438. On my table I would like to be able to display this in the standard way, which would be 0.20±0.008192438 - is it possible to do this? (Probably should be working at 2 DP too actually).
Also, how do I then use this data to create error bars on by bar chart output? I'd been using SPSS in the past for this, but the charts it outputs are a bit rubbish and I'm a n00b at all this sort of stuff.
Links, tutorials or anything would be appreciated 
[Edited on 19-01-2012 by ed]
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
First one, complete guess but can you not just CONCAT a string together of all your bits?
Other stuff I've no idea, sorry.
|
ed
Member
Registered: 10th Sep 03
User status: Offline
|
Answered my own question, you can setup custom error bars in Excel - I wish I knew how to do this a year ago instead of pissing about with SPSS - I don't know how IBM can sell such buggy crappy software?
|
ed
Member
Registered: 10th Sep 03
User status: Offline
|
Will try what you said for the tabulated data Ian - cheers
|
