Math Is Fun Forum

  Discussion about math, puzzles, games and fun.   Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫ • π ƒ -¹ ² ³ °

You are not logged in.

#1 2008-04-09 19:42:30

anyone
Guest

project on excel

hi guys plz help me....
how to calculate standard deviation using Excell
thnz
CHEERS

#2 2008-04-10 03:41:30

mathsyperson
Moderator
Registered: 2005-06-22
Posts: 4,900

Re: project on excel

The excel function STDEVP should do it for you.
For example, =STDEVP(1,9) would calculate the standard deviation of 1 and 9 and so return 2.

If you want to use the formula that divides by n-1 instead of n, then use STDEV instead (although if you're using a large amount of data then it shouldn't matter too much).


Why did the vector cross the road?
It wanted to be normal.

Offline

#3 2008-04-10 08:43:08

John E. Franklin
Member
Registered: 2005-08-29
Posts: 3,588

Re: project on excel

"P" stands for Population?


igloo myrtilles fourmis

Offline

Board footer

Powered by FluxBB