standard deviation

[Guest]

i don't know how to find standard deviation for grouped data. this is for my
add maths project. pls help me. explain to me step-by-step coz i really don't
have a clue how to find it using excel. thnx.

 

[Guest]

Use the STDEV() function. For example if A1 thru A6 contain:

1.2
1.1
1.1
1.3
1.6
1.7


then

=STDEV(A1:A6) will display 0.25819889

 

[Guest]

What summary statistics do you have for the groups?

The overall mean is a weighted average of the group means.
DEVSQ(groups1&2) =
DEVSQ(group1)+DEVSQ(group2)+(AVERAGE(group1)-AVERAGE(group2))^2*COUNT(group1)*COUNT(group2)/(COUNT(group1)+COUNT(group2))

Jerry