Rsd Calculation Formula In Excel. S σ x x 2 n 1 rsd s 100 x where mean x n x summation of x value n the count of mean values s standard deviation value x mean of the data related calculator. A formula for relative standard deviation is relative standard deviation rsd s 100 x.
The formula for calculation of rsd is std deviation x 100 average values. X 1 x n the sample data set. Rsd is a powerful tool to statistically inspect the variation in sets of data but a specific function is not available in excel 2003 2007 or even 2010.
So that by selecting single function i can calculate the values.
The following table shows prices for stock xyz. A formula for relative standard deviation is relative standard deviation rsd s 100 x. Standard deviation will be rsd 78 18 60. The above rsd example has been entered into the excel formula bar and will calculate the percent relative standard deviation of the 5 value data set e6 to e11.
