Question

Solution number Concentration Absorbance 1 1 0.01 2 2 0.01 3 16 0.06 4 26 0.12...

Solution number Concentration Absorbance
1 1 0.01
2 2 0.01
3 16 0.06

4

26 0.12
5 100 0.53

Can someone plot this in excel along with slope equation and R2( add trendline) thank you!!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

y = 0.005 2x R2 = 0.9954 Absorbance 0 20 40 60 80 100 120 ConcentrationSlope = 0.0052

Add a comment
Know the answer?
Add Answer to:
Solution number Concentration Absorbance 1 1 0.01 2 2 0.01 3 16 0.06 4 26 0.12...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Section 1 Tube [FeSCN^+] M Absorbance 1 0.0005 0.016 2 0.0011 0.0422 3 0.00367 0.0917 4...

    Section 1 Tube [FeSCN^+] M Absorbance 1 0.0005 0.016 2 0.0011 0.0422 3 0.00367 0.0917 4 0.00727 0.224 5 0.00965 0.267 6 0.0137 0.398 Part B unknown sol.   0.175 SCENARIO: Five standard solutions containing different known concentrations of an iron (II) thiocyanate (FeSCN+ ) complex are analyzed using spectrophotometry, a technique which measures the quantity of light absorbed by the solution as a function of the concentration of the analyte in solution (in this case, FeSCN+ ). The results of...

  • Table 3: Absorbance for varying concentrations of Co(NO3)2 at max wavelength Sample Number Concentration (mM) Absorbance...

    Table 3: Absorbance for varying concentrations of Co(NO3)2 at max wavelength Sample Number Concentration (mM) Absorbance 0 0 mM 0.00 1 30 mM 0.13 2 60 mM 0.27 3 90mM 0.40 4 120mM 0.53 5 150 mM 0.67 Answer the following questions based on your calibration curve Calculate the l value from the slope of your graph

  • .79 Dilution #1 Dilution #2 Dilution #3 Dilution #4 Absorbance Concentration (M) 5.000e-4 M .54 3.750e-4...

    .79 Dilution #1 Dilution #2 Dilution #3 Dilution #4 Absorbance Concentration (M) 5.000e-4 M .54 3.750e-4 M 2.500e-4M 1.250e-4 M Construct a plot of absorbance (van) versus concentration (axis) from the data above. Determine the slope of the best-hit line. Make sure to force the best hit straight line through the origin. Excel has an option to do the instructions for Excel 2011 on Windows, instructions for Excel 2011 on Mac). > Submit your answer to this question to the...

  • .79 Dilution #1 Dilution #2 Dilution #3 Dilution #4 Absorbance Concentration (M) 5.000e-4 M .54 3.750e-4...

    .79 Dilution #1 Dilution #2 Dilution #3 Dilution #4 Absorbance Concentration (M) 5.000e-4 M .54 3.750e-4 M 2.500e-4M 1.250e-4 M Construct a plot of absorbance (van) versus concentration (axis) from the data above. Determine the slope of the best-hit line. Make sure to force the best hit straight line through the origin. Excel has an option to do the instructions for Excel 2011 on Windows, instructions for Excel 2011 on Mac). > Submit your answer to this question to the...

  • Absorbance Concentration (M) Dilution # 1 .79 S.000e-4 M Dilution #2 .54 3.750e-4 M Dilution #3...

    Absorbance Concentration (M) Dilution # 1 .79 S.000e-4 M Dilution #2 .54 3.750e-4 M Dilution #3 .31 2.500e-4 M ilution #4 .11 1.250e-4 M Construct a plot of absorbance (y-axis) versus concentration (x-axis) from the data above. Determine the slope of the best-fit line. Make sure to force the best fit straight ine through the origin. Excel has an option to do this (instructions.for Excel 2013.on Windows, instructions.for Excel.2011 on Mac) >Submit your answer to this question to the correct...

  • 1. Make a scatter plot (on the computer again) of absorbance versus concentration for the calibration samples. On the...

    1. Make a scatter plot (on the computer again) of absorbance versus concentration for the calibration samples. On the plot, add a linear trendline and display the equation on the chart. Take your time to label the axes. Attach the chart to the end of this experiment. 2. From your plot, what is the value of eb? Data 25 Mass of Acetylsalicylic acid in solution g Solutions Absorbance 1.20 Standard made from 0.500mL of stock solution 1.1 Standard made from...

  • Prelaboratory assignment Exp. 4 Beer’s Law 1.Calculate the Concentration of the Crystal Violet Solutions in Table...

    Prelaboratory assignment Exp. 4 Beer’s Law 1.Calculate the Concentration of the Crystal Violet Solutions in Table 1 of the Procedureusing Vinitial x Minitial = Vdiluted x Mdiluted (Note: Vdiluted = 15 mL). Record the concentrationsin Table 1 AND in the Data table in the report sheet. 2.Plot the following data as absorbance vs concentration of X in excel Absorbance, A    Molar Concentration of X 0.045 3.0 x 10-4 mol/L 0.097 6.2 x 10-4 mol/L 0.14 9.0 x 10-4 mol/L...

  • Plot of absorbance vs concentration for calibration curve. Data sheet stapled to back of DRA. Solution...

    Plot of absorbance vs concentration for calibration curve. Data sheet stapled to back of DRA. Solution Stock solution Dilution 1 (50.0%) Dilution 2 (25.0%) Dilution 3 (12.5%) (SCN) (FeSCNI. 2.0 x10M 2.0 X10M 1.0 x 10-4 M 1.0104M 5.0 x10-5M 5.0*10-5M 2.5 x 10-5Ma.5 x10 -5M 0.836 0.389 0.180 0.085 Calibration curve trendline equation_=43 15.1 % - 0.032 Rvalue of trendline 0.9993 Absorbance Sample Number 0.0020 M Fe(NO), (ml) 0.0020 M KSCN (ML) - - - - - 0. 129...

  • Please show calculations for all 4 trials 3cer's law states that the absorbance of a solution...

    Please show calculations for all 4 trials 3cer's law states that the absorbance of a solution is directly proportional to the molar Concentration of a solution. If you plot absorbance versus molar concentration (molarity), the esulting graph yields a straight line. The equation for the straight line can be used to determine he concentration of an unknown solution from a measurement of its absorbance. You need to prepare 10.0 mL of diluted Cuso, solutions with the concentrations listed for Trials...

  • If the original sodium tartrate solution had a concentration of 1.00 M instead of 0.100 M,...

    If the original sodium tartrate solution had a concentration of 1.00 M instead of 0.100 M, what would the concentration of copper be in a solution created by combining 10 mL of it with 10 mL of the 0.100M copper (II)sulfate solution. Use the Ksp you found in the experiment. For the ionic solid copper tartrate, the solubility equilibrium reaction is: CuC4H4O6 (s) Cu2+ (aq) + C4H4O6 2- (aq) Just like any equilibrium reaction, an equilibrium expression can be created....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT