= (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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |