View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Creating macro for slightly complicated formula

Hello,

Why do you want to code this?

There are built-in worksheet functions to calculate the standard
deviation in Excel, for example STDEV and STDEVP.

See the Excel help on those for more details.

But if you still need to do it on your own,
http://sulprobil.com/html/statistics...ed_values.html
might give you a hint (look at the STDEV part of the macro - your
question would be answered if all weights are set to 1).

Regards,
Bernd