Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 05-01-2012
Member
 
Join Date: Nov 2011
Posts: 81
Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel

How to calculate RSD ( relative standard deviation) in Microsoft Excel ? Is there a ready for this function or do I tinker the formula. Then they would have standard deviation / mean.
Reply With Quote
  #2  
Old 05-01-2012
Member
 
Join Date: Aug 2011
Posts: 578
Re: Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel

I like your description you should interpreter with the function
Code:
RSD ( relative standard deviation) 

=100*ABS(STDEV(data)/AVERAGE(data))

or

=ABS(STDEV(data)/AVERAGE(data))

perhaps formatted as percentage
Reply With Quote
  #3  
Old 05-01-2012
Member
 
Join Date: Aug 2011
Posts: 561
Re: Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel

The functions specified by you only refer to the standard deviation. Depending on time to a population or sample, or with a different point of view dealing with texts instead of numbers. I am looking for a function that represents the standard deviation relative to mean = coefficient of variation. But since I still can not find anything --- which means nothing, because Excel does not name things always at the correct name.
Reply With Quote
  #4  
Old 05-01-2012
Member
 
Join Date: Aug 2011
Posts: 459
Re: Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel

Ah! You have therefore calculated the standard deviation. You simply divide it by the arithmetic mean of values to obtain a quotient which is the relative standard deviation. But important is how to calculate the standard deviation. Well I also would like to know how to calculate the relative difference between 6320 and 6380. But I think I have found the formula but I do not understand.
Reply With Quote
  #5  
Old 05-01-2012
Member
 
Join Date: Jul 2011
Posts: 432
Re: Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel

The relative standard deviation is obtained by dividing the standard deviation for the expected value (or mathematical expectation) and, for example in Physics, provides a 'measure' of the precision of measurement, namely, its value (inversely proportional to it).
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel"
Thread Thread Starter Forum Replies Last Post
Need help to Annualize a standard deviation in Excel Saddys MS Office Support 2 17-02-2012 08:06 PM
Is it possbile to undo saved changes in Microsoft Excel Haimi-32 MS Office Support 2 02-02-2012 01:18 PM
What is the way to calculate standard error in Microsoft Excel Edha MS Office Support 4 24-01-2012 05:06 PM
I need help to find second standard deviation in Microsoft Excel Weddel MS Office Support 4 24-01-2012 02:10 PM
How to create formula to find relative percent difference in Excel Aarti C Windows Software 1 06-01-2012 08:38 PM


All times are GMT +5.5. The time now is 12:00 PM.