Statistical tests with 2-factor data

[ThGreenMoFo]

I'm trying to run mean, variance, standard deviation, and standard error
statistical tests on two factor data. I have two columns set up - weight in
A and number in B. I need to run the tests that I mentioned before inclusive
of both sets up data. For instance,

A B
100 6
120 25
140 38
160 25
180 6

So I have 6 individuals that weight 100 kg, 25 that weigh 120 kg, etc. How
do I get Excel to factor both columns into the values of the stats tests?
Thanks a lot.

[Jerry W. Lewis]

Mean
=SUMPRODUCT(B1:B5,A1:A5)/SUM(B1:B5)
Variance
=SUMPRODUCT(B1:B5,(A1:A5-mean)^2)/(SUM(B1:B5)-1)
Std Dev
=SQRT(variance)
Std Err
=SQRT(variance/SUM(B1:B5))

Jerry

"ThGreenMoFo" wrote:

> I'm trying to run mean, variance, standard deviation, and standard error
> statistical tests on two factor data. I have two columns set up - weight in
> A and number in B. I need to run the tests that I mentioned before inclusive
> of both sets up data. For instance,
>
> A B
> 100 6
> 120 25
> 140 38
> 160 25
> 180 6
>
> So I have 6 individuals that weight 100 kg, 25 that weigh 120 kg, etc. How
> do I get Excel to factor both columns into the values of the stats tests?
> Thanks a lot.
>