Standard deviation calculation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Based on an earlier post, I am using the below method to calculate standard
deviation.

load in a simple SUM measure (x) - the sum of fact column (aggregated in
the cube)
load in a simple SUM measure of x squared (x2) - sum of square of fact
column (aggregated in the cube)
load in a counter called cnt - count of a fact column (aggregated in the
cube)

((x2 - ((x^2)/cnt))/cnt)^0.5

But this result is different from what I get with the excel stdev funtion.
Have I got the above formula wrong?

thanks in advance

--
Message posted via http://www.sqlmonster.com
.

Relevant Pages

  • every number has its own significance.....
    ... 18 is the only number that is twice the sum of its digits. ... 21 is the smallest number of distinct squares needed to tile a square. ... 26 is the only number to be directly between a square and a cube. ... 27 is the largest number that is the sum of the digits of its cube. ...
    (sci.crypt)
  • Re: Calculate deviation
    ... then it's useful to add a base measure that sums the square ... Subject: Re: MDX Stdev ... the trick is to load up your base measures as follows: ... load in a simple SUM measure of x squared ...
    (microsoft.public.sqlserver.olap)
  • Mathematical calendar (long)
    ... A pentagonal pyramid is formed of 5 triangles ... and 1 square ... 7/1 - Cube line picking: The minimum straight line distance between any ... There are 14 known tilings with pentagons ...
    (sci.math)
  • Re: How do I...
    ... where I want it to be AND square with the front face? ... If the jaws are good and the cube is true then it should be held square ... which will be in the centre of each face as you swing the chuck. ... against the jaw pressure. ...
    (uk.rec.models.engineering)
  • Re: How do I...
    ... where I want it to be AND square with the front face? ... If the jaws are good and the cube is true then it should be held square ... which will be in the centre of each face as you swing the chuck. ... against the jaw pressure. ...
    (uk.rec.models.engineering)