In the cell where the formula is written a value between 0-100 will be reported.
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. = (STDEV(Data Range) / AVERAGE(Data Range))*100 To calculate the %RSD in Microsoft Excel a short formula must be used: %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. Percentage relative standard deviation is a widely used statistical tool but strangely there is no automated function in any version of Microsoft Excel. This guide will detail how to calculated the relative standard deviation (%RSD) using Excel, then walk through a worked example and finally detail the limitations of the calculation. Excel and Relative Standard Deviation %RSD
