LOGO
General Discussion Undecided where to post - do it here.

Reply to Thread New Thread
Old 05-09-2007, 06:11 AM   #1
popsicesHoupe

Join Date
Oct 2005
Posts
417
Senior Member
Default math guys: how does one figure out a standard deviation
1. excel
2. stdev([cell range])
popsicesHoupe is offline


Old 05-09-2007, 06:21 AM   #2
teentodiefows

Join Date
Oct 2005
Posts
558
Senior Member
Default
find the mean
then find the variance
then take the square root of the variance.
teentodiefows is offline


Old 05-09-2007, 06:47 AM   #3
averkif

Join Date
Oct 2005
Posts
405
Senior Member
Default
The population standard deviation can be simply calculated as follows:

1) sum all values
2) sum the squares of all values
3) square the result from (1)
4) Divide (3) by N (the number of values)
5) Subtract (4) from (2)
6) Divide (5) by N
7) Take the square root of (6)

So, if we have 3, 6, and 7 as values:

1) = 3+6+7 = 16
2) = 9 + 36 + 49 = 94
3) = 16*16 = 256
4) = 256/3 = 85.33
5) = 94 - 85.33 = 8.67
6) = 8.67/3 = 2.89
7) = SQRT(2.89) = 1.7
averkif is offline


Old 05-09-2007, 06:48 AM   #4
Obgrfbke

Join Date
Nov 2005
Posts
457
Senior Member
Default
uuuuh yeah.

SE = Stdev/sqrt(n)
Obgrfbke is offline


Old 05-09-2007, 06:51 AM   #5
eXC3Kvnn

Join Date
Oct 2005
Posts
404
Senior Member
Default
Originally posted by Lawrence of Arabia
uuuuh yeah.

SE = Stdev/sqrt(n) You must be an idiot...
eXC3Kvnn is offline


Old 05-09-2007, 06:52 AM   #6
JewJoleSole

Join Date
Oct 2005
Posts
384
Senior Member
Default
oh, one more thing. you proved my point in your previous post

6) Divide (5) by N
7) Take the square root of (6)

what happens when n=100. when n= 1000? when n= 10000

JewJoleSole is offline


Old 05-09-2007, 06:58 AM   #7
chipkluchi

Join Date
Oct 2005
Posts
398
Senior Member
Default
Originally posted by Lawrence of Arabia
oh, one more thing. you proved my point in your previous post

6) Divide (5) by N
7) Take the square root of (6)

what happens when n=100. when n= 1000? when n= 10000

What happens is that the difference in the sums grows linearly, you idiot.
chipkluchi is offline


Old 05-09-2007, 07:04 AM   #8
NanoGordeno

Join Date
Oct 2005
Posts
414
Senior Member
Default
Let's make this absolutely clear: you are claiming that the standard deviation of any set of independent dice rolls approaches 0 as the size of the set approaches infinity?

thats correct. its called the Law of Large Numbers. The variance of X_bar which is equal to sigma^2/n approaches zero as n increases.
NanoGordeno is offline


Old 05-09-2007, 07:19 AM   #9
mtvlover571

Join Date
Oct 2005
Posts
408
Senior Member
Default
In fact, if you were to roll a die many times (or to roll many dice at once) then the set of values you receive would have a standard deviation which approaches sqrt(35/12)

duh
mtvlover571 is offline


Old 05-09-2007, 07:26 AM   #10
VewCoorkPow

Join Date
Oct 2005
Posts
408
Senior Member
Default
swiss math?
VewCoorkPow is offline


Old 05-09-2007, 07:33 AM   #11
opdirorg

Join Date
Oct 2005
Posts
445
Senior Member
Default
Originally posted by Lawrence of Arabia
In fact, if you were to roll a die many times (or to roll many dice at once) then the set of values you receive would have a standard deviation which approaches sqrt(35/12)

duh

no. your sample average X_bar would have a standard deviation approaching zero when you roll a dice many times. You're a ****ing idiot. The set of values is different from the mean of the set.

A set of independently determined means has a variance which approaches 0 as the number of trials in each determination of the mean increases. Any given set of actual trials has a variance which approaches 35/12

You're like a ****ing child.
opdirorg is offline


Old 05-09-2007, 07:36 AM   #12
Foucceedo

Join Date
Oct 2005
Posts
420
Senior Member
Default
Lawrence reminds me of the undergrads I TA. They know a bunch of formulas, but don't have a ****ing clue what any of them mean, or where they're applicable.
Foucceedo is offline


Old 05-09-2007, 07:42 AM   #13
Kghyutgykim

Join Date
Oct 2005
Posts
442
Senior Member
Default
standard deviation of any set of dice rolls iid approaches zero as the number of elements in the set (n) approaches infinity: FACT. as you increase the sample size of each set, your variance approaches zero.

the variance of x_bar decreases as the number of trials in each determination of x_bar increases: FACT
Kghyutgykim is offline


Old 05-09-2007, 07:44 AM   #14
HawksBurnDown

Join Date
Oct 2005
Posts
695
Senior Member
Default
Originally posted by self biased
unfortunately i don't have access to a laptop when i'm playing a game. i need to be able to figure out if a set of rolls is within one or not more or less on the fly. What you want to do is the following (assuming normal 6-sided dice):

1) Take the total number of dice rolled (if you're interested in two dice rolled 5 times, then use 2*5 = 10). Multiply by 3.5
2) Sum the values of the rolls (you should be summing 10 numbers between 1 and 6 in above example)
3) subtract (1) from (2)
4) Multiply 1.7 * sqrt(total number of dice rolled)
5) Divide (3) by (4)

(5) is the number of standard deviations high (+ve) or low (-ve) the series of rolls was

Please note that this is only a good estimator of probabilities for large total numbers of dice.

If I rolled 100 dice and ended up with a score of 380 then:

(1) is 350
(2) is 380
(3) is 30
(4) is 17
(5) is 1.8 or so (which is not that unusual)
HawksBurnDown is offline


Old 05-09-2007, 07:48 AM   #15
Stoniaanapy

Join Date
Nov 2005
Posts
352
Senior Member
Default
Originally posted by Lawrence of Arabia
which means that your little example here

The population standard deviation can be simply calculated as follows:

1) sum all values
2) sum the squares of all values
3) square the result from (1)
4) Divide (3) by N (the number of values)
5) Subtract (4) from (2)
6) Divide (5) by N
7) Take the square root of (6)

So, if we have 3, 6, and 7 as values:

1) = 3+6+7 = 16
2) = 9 + 36 + 49 = 94
3) = 16*16 = 256
4) = 256/3 = 85.33
5) = 94 - 85.33 = 8.67
6) = 8.67/3 = 2.89
7) = SQRT(2.89) = 1.7

approaches zero as n increases. Could you please provide me with an estimate of the standard deviation of a set of 100 dice rolls then?

Stoniaanapy is offline


Old 05-09-2007, 07:53 AM   #16
zttrftwsq

Join Date
Oct 2005
Posts
410
Senior Member
Default
Just because I'm a nice guy, I'll provide you with an excel spreadsheet which does it for 1000 rolls

The standard deviation (both pop and sample) for those 1000 pseudo-random rolls is provided and is suspiciously close to sqrt(35/12). Rolls are generated by taking a uniform deviate from 0 to 1, multiplying by 6 and taking the ceiling.
zttrftwsq is offline


Old 05-09-2007, 08:29 AM   #17
Overlord

Join Date
Oct 2005
Posts
608
Senior Member
Default
everyone is right but too stubborn to admit it.
Overlord is offline


Old 05-09-2007, 08:30 AM   #18
itepearce

Join Date
Oct 2005
Posts
420
Senior Member
Default
This thread makes me cry. Is LoA really about to get a degree in economics?
itepearce is offline


Old 05-09-2007, 08:33 AM   #19
Efksqhyu

Join Date
Oct 2005
Posts
546
Senior Member
Default
Originally posted by KrazyHorse
No, lawrence doesn't understand the difference between the set and the mean of the set.

hes like a kid with all the legos but no schematic to build something with.
Efksqhyu is offline


Old 05-09-2007, 08:42 AM   #20
LomodiorCon

Join Date
Oct 2005
Posts
480
Senior Member
Default
I don't know any of my TA's.
LomodiorCon is offline



Reply to Thread New Thread

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 9 (0 members and 9 guests)
 

All times are GMT +1. The time now is 08:46 PM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.6.0 PL2
Design & Developed by Amodity.com
Copyright© Amodity