Calculating Percent RSD. The calculation of percent RSD involves several steps: 1. Calculate the mean (average) value. 2. Determine each data point’s deviation from the mean. 3. Square each deviation.

To begin, the data you want to calculate the RSD for should be entered into Excel. You can input your data manually or import it from another source if it’s already in an electronic format. Step 2: ...