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.

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.