Question: I need help calculating the emission intensity for my excel. My data set is 4B and I included the data already seperated by metal below.

I need help calculating the emission intensity for my excel. My data set is 4B and I included the data already seperated by metal below. Thank you!
I need help calculating the emission intensity for my excel. My data
set is 4B and I included the data already seperated by metal
below. Thank you! 21. For each metal, plot a separate linear calibration
curve showing the concentration of metal in ppm (y-axis) vs. emission intensity

21. For each metal, plot a separate linear calibration curve showing the concentration of metal in ppm (y-axis) vs. emission intensity (x-axis) for the four standard solutions you analyzed. Include (0, blank intensity) as a data point but don't force your graph through this data point because a "weighted" linear graph is preferred for ICP-OES analysis. Record the correlation coefficient and linear equation of your graph. NOTE: the intensities are very high numbers; you may have to format the way in which the numbers are displayed. 22. Insert the emiceinn Intonnitt B D N 1 3 4 6924865.66 7129692.4 4208175.6 2740320.32 1455622.75 3 4 in 9 6660425.45 6866890.96 4045400.39 2646244.22 1378945.73 12 ws A 1 Blank Fe 2 1 3 2 4 3 5 6 7 8 Blank Mg 9 1 10 2 11 3 4 13 14 15 Blank Na 16 1 17 2 18 3 4 20 21 22 Blank Zn 23 1 24 2 25 3 26 4 27 28 29 30 31 w NP 62550953 64726521.3 4045400.39 24443718.6 12405130.4 19 W NA 2190642.65 2201630.59 1296133.82 847467.855 2569989.46 ppm Bb https://learn-us-east-1-prod-fleet01-xythos.content.bl... PG COLUNDUGU Eignments - CHM122 B03 - GENERAL CHEM... LOOD 2.003 g cereal 3B blank 4B blank 4B blank 4B blank 4B solution 1 4B solution 1 4B solution 1 4B solution 1 4B solution 24B solution 24B solution 24B solution 24B solution 3 4B solution 3 4B solution 3 4B solution 3 4B solution 4 4B solution 4 4B solution 4 4B solution 4 4B 1.994g cereal 4B 127 Zn 206.200 38 Fe 238.204 38 Mg 285.213 38 Na 589.592 38 Zn 206.200 39 Fe 238.204 39 Mg 285.213 39 Na 589.592 39 Zn 206.200 40 Fe 238.204 40 Mg 285.213 40 Na 589.592 40 Zn 206.200 41 Fe 238.204 41 Mg 285.213 41 Na 589.592 41 Zn 206.200 42 Fe 238.204 42 Mg 285.213 42 Na 589.592 42 Zn 206.200 43 Fe 238.204 735070.6197 6924865.657 6660425.449 62550952.98 2190642.648 7129692.399 6866890.959 64726521.26 2201630.585 4208175.599 4045400.388 37542400.34 1296133.824 2740320.318 2646244.219 24443718.55 847467.855 1455622.753 1378945.73 12405130.41 435238.7077 2569989.459 43 1.994g cereal 4B 1.994g cereal 4B 1.994g cereal 4B 43 Mg 285.213 Na 589.592 Zn 206.200 3600804.952 13831817.44 704856.1529 43 21. For each metal, plot a separate linear calibration curve showing the concentration of metal in ppm (y-axis) vs. emission intensity (x-axis) for the four standard solutions you analyzed. Include (0, blank intensity) as a data point but don't force your graph through this data point because a "weighted" linear graph is preferred for ICP-OES analysis. Record the correlation coefficient and linear equation of your graph. NOTE: the intensities are very high numbers; you may have to format the way in which the numbers are displayed. 22. Insert the emiceinn Intonnitt B D N 1 3 4 6924865.66 7129692.4 4208175.6 2740320.32 1455622.75 3 4 in 9 6660425.45 6866890.96 4045400.39 2646244.22 1378945.73 12 ws A 1 Blank Fe 2 1 3 2 4 3 5 6 7 8 Blank Mg 9 1 10 2 11 3 4 13 14 15 Blank Na 16 1 17 2 18 3 4 20 21 22 Blank Zn 23 1 24 2 25 3 26 4 27 28 29 30 31 w NP 62550953 64726521.3 4045400.39 24443718.6 12405130.4 19 W NA 2190642.65 2201630.59 1296133.82 847467.855 2569989.46 ppm Bb https://learn-us-east-1-prod-fleet01-xythos.content.bl... PG COLUNDUGU Eignments - CHM122 B03 - GENERAL CHEM... LOOD 2.003 g cereal 3B blank 4B blank 4B blank 4B blank 4B solution 1 4B solution 1 4B solution 1 4B solution 1 4B solution 24B solution 24B solution 24B solution 24B solution 3 4B solution 3 4B solution 3 4B solution 3 4B solution 4 4B solution 4 4B solution 4 4B solution 4 4B 1.994g cereal 4B 127 Zn 206.200 38 Fe 238.204 38 Mg 285.213 38 Na 589.592 38 Zn 206.200 39 Fe 238.204 39 Mg 285.213 39 Na 589.592 39 Zn 206.200 40 Fe 238.204 40 Mg 285.213 40 Na 589.592 40 Zn 206.200 41 Fe 238.204 41 Mg 285.213 41 Na 589.592 41 Zn 206.200 42 Fe 238.204 42 Mg 285.213 42 Na 589.592 42 Zn 206.200 43 Fe 238.204 735070.6197 6924865.657 6660425.449 62550952.98 2190642.648 7129692.399 6866890.959 64726521.26 2201630.585 4208175.599 4045400.388 37542400.34 1296133.824 2740320.318 2646244.219 24443718.55 847467.855 1455622.753 1378945.73 12405130.41 435238.7077 2569989.459 43 1.994g cereal 4B 1.994g cereal 4B 1.994g cereal 4B 43 Mg 285.213 Na 589.592 Zn 206.200 3600804.952 13831817.44 704856.1529 43

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!