Please do in Excel
Sodium in a series of samples is determined by emissionspectroscopy. The instrument was calibrated using a series of Nastandards (Table 1).
| Table 1 | |
| Concentration ppm (x-axis) | Instrument response (y-axis) |
| 0.0 | 3.1 |
| 20.0 | 21.5 |
| 40.0 | 40.9 |
| 60.0 | 57.1 |
| 80.0 | 77.3 |
A) plot data
B) Give the regression equation and r2
C) Calculate Standard Dev of the line, Sy and Sxx
| Table 2 | ||||
| Emission Response | ||||
| replicates | blank | A | B | C |
| 1 | 5.1 | 28.5 | 40.7 | 73.1 |
| 2 | 4.8 | 28.2 | 41.2 | 72.1 |
| 3 | 4.9 | 28.9 | 40.2 | 71.3 |
D)Table 2 gives data obtained for replicate 1.000g samples ofcement (A, B, & C) dissolved in HCl and diluted to 100 mL.Calculate the percentage of Na2O in each sample and itserror.
E)Calculate appropriate stats for each sample.
Expert Answer
A solution will be send to
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured