A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

median standard deviation



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2010, 07:24 PM posted to microsoft.public.excel.misc
Omics
external usenet poster
 
Posts: 11
Default median standard deviation

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

Omics
  #2  
Old April 20th, 2010, 07:39 PM posted to microsoft.public.excel.misc
Luke M[_4_]
external usenet poster
 
Posts: 451
Default median standard deviation

That is two seperate statistical functions!

Median:
=MEDIAN(...)

Standard Deviation:
=STDEV(...)

Check out the help file on statistical functions for more details.

--
Best Regards,

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

Omics



  #3  
Old April 20th, 2010, 07:56 PM posted to microsoft.public.excel.misc
dlw
external usenet poster
 
Posts: 1,600
Default median standard deviation

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

  #4  
Old April 20th, 2010, 08:07 PM posted to microsoft.public.excel.misc
Omics
external usenet poster
 
Posts: 11
Default median standard deviation

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

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

"Omics" wrote:
Hi, Anybody can tell me which function or formula
should I use in excel to calculate the median
standard deviation?


You will need to be more careful with your terminology if you want a
meaningful answer.

First, are you referring to the median or the mean (arithmetic average)?

The median is the middle value of the data. The mean is the average of the
data. For example, if the data are 1, 4 and 5, 4 is the median, whereas the
mean is about 3.33.

Note that the standard deviation (emphasis on "standard") is defined as a
deviation from the mean, not the median.

I 'spose that you could substitute the median for the mean in the standard
deviation formula. (See the STDEVP help page.) But then it would not be
"standard" ;-). And the usefulness of such a measure is unclear.

On the other hand, the median deviation is defined as the average of the
absolute deviations from the median.

To my knowledge, there is no Excel formula for that. You can compute it
with the following array formula[*]:

=SUM(ABS(A2:A100-A1:A99))/100
[*] Enter an array formula by pressing ctrl+shift+Enter instead of just
Enter. In the Formula Bar, you will see curly braces around the entire
formula, viz. {=formula}. You cannot type the curly braces yourself; that is
just Excel's way of denoting an array formula. If you make a mistake, select
the cell, press F2, edit as needed, then press ctrl+shift-Enter.

Lastly, if you mean that you have a set of standard deviations, and you want
to calculate their median, you could use =MEDIAN(A1:A10). But again, the
usefulness of such a measure is unclear.
  #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

  #7  
Old April 20th, 2010, 09:37 PM posted to microsoft.public.excel.misc
dlw
external usenet poster
 
Posts: 1,600
Default median standard deviation

If you are doing a homework assignment which is asking to calculate the
"median standard deviation" it is in fact a trick question, because there is
no such thing. My statistics professor was always pulling stunts like
that... Like asking us to calculate the "3rd order angular mean" or the
"compressed flux regression test" etc...

"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

  #8  
Old April 21st, 2010, 12:03 AM posted to microsoft.public.excel.misc
Joe User[_2_]
external usenet poster
 
Posts: 757
Default median standard deviation

Errata....

I wrote:
the median deviation is defined as the average of the absolute deviations
from the median. [....] You can compute it with the following array
formula[*]:
=SUM(ABS(A2:A100-A1:A99))/100


Brain fart! I mean:

=SUM(ABS(A1:A100-MEDIAN(A1:A100)))/100

And note that for "/100", 100 relates to the number of data points (100),
not a constant like "percent".


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

"Joe User" joeu2004 wrote in message
...
"Omics" wrote:
Hi, Anybody can tell me which function or formula
should I use in excel to calculate the median
standard deviation?


You will need to be more careful with your terminology if you want a
meaningful answer.

First, are you referring to the median or the mean (arithmetic average)?

The median is the middle value of the data. The mean is the average of
the
data. For example, if the data are 1, 4 and 5, 4 is the median, whereas
the
mean is about 3.33.

Note that the standard deviation (emphasis on "standard") is defined as a
deviation from the mean, not the median.

I 'spose that you could substitute the median for the mean in the standard
deviation formula. (See the STDEVP help page.) But then it would not be
"standard" ;-). And the usefulness of such a measure is unclear.

On the other hand, the median deviation is defined as the average of the
absolute deviations from the median.

To my knowledge, there is no Excel formula for that. You can compute it
with the following array formula[*]:

=SUM(ABS(A2:A100-A1:A99))/100

[*] Enter an array formula by pressing ctrl+shift+Enter instead of just
Enter. In the Formula Bar, you will see curly braces around the entire
formula, viz. {=formula}. You cannot type the curly braces yourself; that
is
just Excel's way of denoting an array formula. If you make a mistake,
select
the cell, press F2, edit as needed, then press ctrl+shift-Enter.

Lastly, if you mean that you have a set of standard deviations, and you
want
to calculate their median, you could use =MEDIAN(A1:A10). But again, the
usefulness of such a measure is unclear.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.