posted on Mar, 23 2014 @ 04:59 PM
reply to post by HomerinNC
Homer, my deepest, deepest of condolences. I had a lot of classmates that struggled with statistics just like you are currently. It is really pretty
convoluted seeming, totally get that. I felt confused most of the time but still manage to ace both classes. I still question those grades. I
dunno, maybe my prof thought I was cute or something.
Anyways, I wish I still had my Stats book but I quickly sold that back to the school after I was done with the thing. Don't have any of my excel (or
excel right now for that matter) or else I'd see what I could pull together for you. However, excel does have statistics functions capability in it.
I'm not sure if it's an add on that you need to download. If it is, it's around the Windows icon, named something like addons and it'll be
called statistics.
For that ugly standard deviation formula:
x sub 1 = that's your data unit for the first in the sample
bar x = that's the mean
N = sample size so if you asked 20 people a question, your sample size is 20.
Sigma in this case means sum it all up. That means doing the (x1 - barx)^2 for each bit of data from your sample of 20.
Then divide it by N-1. In our example, that'd be 19.
Then take that number and get the square root of it.
I really hope that helps. Statistics is really scary looking because they replace so much with different greek letters and wingdings. Just figure
out what each of those represent and it's just a matter of plugging it in.
Hang in there. Like I said, you have my deepest of condolences.