Excel - Standard Deviation

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

I have to do some SD calculations, however Excel will
only allow for 30 groups to be evaluated, I have 120
groups to evaluate, any ideas?

Thanks
Dean
 
I have to do some SD calculations, however Excel will
only allow for 30 groups to be evaluated, I have 120
groups to evaluate, any ideas?
Click to expand...

Are you using ranges to hold the values you want to analyze? If so, you could
replace formulas like

=STDEV(A1,A2,A3,A4,B1,B2,B3,B4)

with

=STDEV(A1:B4)

You could replace other references like

=STDEV(A1,B2,C3,D4,E5,F6,...)

with

=STDEV((A1,B2,C3,D4,E5,F6,...))

the last using a reference to a multiple area range, which would count as a
*single* argument.

If these don't exactly match your needs, you might consider pasting one of your
formulas (AS PLAIN TEXT!) into a follow-up so the rest of us don't have to guess
what you're doing.
 
Back
Top