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.