Calculate the standard deviation as a percent of the mean for each element (% de

Question

Calculate the standard deviation as a percent of the mean for each element (% deviation). This is a measure of the precision of the analyses for each element.

How do I work out the % deviation in excel 2013?

I have the mean, standard deviation 1 and standard deviation 2.

Below is a sample of the data.

WEI-21 ME-ICP61 ME-ICP61 ME-ICP61 ME-ICP61 ME-ICP61 ME-ICP61 ME-ICP61 SAMPLE Standard 1 Recvd Wt. Ag Al As Ba Be Bi Ca DESCRIPTION kg ppm % ppm ppm ppm ppm % 10WW 215/50S 0.06 2.2 8.07 10 680 1 4 3.54 10WW 215/100S 0.06 2.1 7.86 8 660 0.9 5 3.46 10WW 215/200S 0.06 2.2 7.73 2.5 650 0.9 3 3.33 MEAN 2.17 7.89 6.83 663.33 0.93 4.00 3.44 STD 1 0.06 0.17 3.88 15.28 0.06 1.00 0.11 STD 2 0.12 0.34 7.77 30.55 0.12 2.00 0.21 % deviation Thank you .

Explanation / Answer

To find % deviation the required formula is,

% deviation = (Std / Mean) * 100

For example

% deviation = (Std / Mean) * 100 = (0.06/2.17)*100 = 2.8%

similarlly do for all,

MEAN 2.17 7.89 6.83 663.33 0.93 4 3.44 STD 1 0.06 0.17 3.88 15.28 0.06 1 0.11 STD 2 0.12 0.34 7.77 30.55 0.12 2 0.21 % deviation (STD1) 2.8 2.2 56.8 2.3 6.5 25.0 3.2 % deviation (STD2) 5.5 4.3 113.8 4.6 12.9 50.0 6.1

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.