View Single Post
  #6  
Old April 20th, 2010, 08:21 PM posted to microsoft.public.excel.misc
Joe User[_2_]
external usenet poster
 
Posts: 757
Default median standard deviation

"Omics" wrote:
This will give me the median of the data.


Not really. It computes the median of a set of standard deviations. In
other words, the data are a set of standard deviations.

If that does not make much sense to you, don't worry. I see little use for
it myself.

Judging from your response, it is not applicable to you.


----- original message -----

"Omics" wrote:
Thanks, a lot. This will give me the median of the data. But how can I
calculate the median standard deviation?

Omics

"dlw" wrote:

let's say your standard deviations were in cells a1 to a5, the median would be:
=median(a1:a5)

"Omics" wrote:

Hi, Anybody can tell me which function or formula should I use in excel to
calculate the median standard deviation? Thanks a lot.

Omics