Re: Question about function in gnumeric: variance

["Andreas J. Guelzow" <aguelzow pyrshep ca>]

On Thu, 2008-09-18 at 11:17 +0800, Uwe Dippel wrote:
> I was looking in vain for a specific function of variance.
> In my case I get a bunch of data in form of a frequency distribution;
> like
>
> Result Frequency
> 1      7
> 2      12
> 3      2
>
> Now I wonder how to use Gnumeric to calculate the variance (or all 
> functions of descriptive statistics, that is) without writing all stuff 
> myself.
> Actually, I guess that there is a way in Gnumeric, but I have searched 
> for more than an hour and still couldn't find it.

I don't believe there ris a way other than just entering the formula.
Since the formulas are quite simple that would have been much faster
than searching for an hour:

mean:       =sumproduct(Sheet1!A1:A3,Sheet1!B1:B3)/sum(B1:B3)
variance:   =sumsq(B1:B3*(A1:A3-B5))/(sum(B1:B3)-1)
            where B5 is the mean and the formula is entered as an array
formula.

Andreas

-- 
"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau

Andreas J. Guelzow
Pyrenean Shepherds