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.

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

--
Gary''s Student - gsnu200738


"Ina" wrote:

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.

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

"Ina" wrote:

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.