create a scatter plot using the concentration and absorbance data for your methylene blue standards and determine the slope and y-intercept using the linear model equation Y-mX+ b. Once you have appropriately set up your spreadsheet, you should be able to predict the unknown concentration of methylene blue using the absorbance data that you collected. This unknown concentration should be plotted as a separate data point on your figure (with an appropriate label in the key) and should fall along the trendline if calculated properly. Your figure should include the following: o Labelled axes (including titles and units) O A raw data "line" (raw data points) O A trendline that runs through the raw data O A separate data point for your unknown concentration of methylene blue O A key that clearly identifies the data set and the unknown O Figure number O Descriptive title Your spreadshcet should also include the following (which should not be part of your figure): O Slope O Y-intercept

create a scatter plot using the concentration and absorbance data for your methylene blue standards and determine the slope and y-intercept using the linear model equation Y-mX+ b. Once you have appropriately set up your spreadsheet, you should be able to predict the unknown concentration of methylene blue using the absorbance data that you collected. This unknown concentration should be plotted as a separate data point on your figure (with an appropriate label in the key) and should fall along the trendline if calculated properly. Your figure should include the following: o Labelled axes (including titles and units) O A raw data "line" (raw data points) O A trendline that runs through the raw data O A separate data point for your unknown concentration of methylene blue O A key that clearly identifies the data set and the unknown O Figure number O Descriptive title Your spreadshcet should also include the following (which should not be part of your figure): O Slope O Y-intercept

Appl Of Ms Excel In Analytical Chemistry

2nd Edition

ISBN:9781285686691

Author:Crouch

Publisher:Crouch

Chapter4: Least-squares And Calibration Methods

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The spectroscopic data in the table is generated with five solutions of known concentration. Concentration (M) 0.0133 m= 0.0266 0.0532 0.106 0.213 Absorbance 0.1271 What is the intercept of the linear regression line? 0.08531 0.5388 1.069 Use a spreadsheet program, such as Microsoft Excel, to graph the data points and determine the equation of the best-fit line. 1.954 What is the slope of the linear regression line formed by these points? M-1
What is the reason for the stoke shift for a fluorophore ? Please shortly answer at your own words. Answer should be to the point(specific 4-5 lines).
After determining the absorbance of several standards of known concentration, the trendline for a calibration curve (AKA a standard curve) plotting absorbance (y-axis) against concentration (M, x-axis) is determined to be y = 4.943x + -0.0001 The absorbance of a solution of unknown concentration is determined to be 0.48. Calculate the concentration of the unknown solution in M. Give your answer to three decimal places.
The absorbance of an unknown dye solution is measured to be 1.06 by a spectrometer. The calibration plot of the spectrometer is provided below. What is the molar concentration of the unknown sample (in mole L)? Absorbance vs. Molarity 18 y3 67024x-0.0343 16 14 12 1 0.8 0.6 0.4 0.2 01 0.2 0.000005 00001 0000015 Concentration of solutions, mol/L 0.00002 0.000025 000003 0 163e-5 O 2.35e-6 0 163 0 235 Absorbance
Enter this data set in Excel, construct an appropriate plot, develop a trendline (not forcing the trendline through 0,0), and determine a linear equation. If an unknown sample exhibits an absorbance of 0.517, determine the concentration of the compound in this sample. mM A 0 0 0.48 0.21076 0.96 0.4004 1.44 0.6072 1.92 0.7546 2.4 0.9086 O 1.00 mM O 1.10 mM O 1.20 mM O 1.40 mM O 1.30 mM
Using data from Table 1 plot a graph similar to Figure 4 in the manual that you will label as “Figure A - Bromophenol Blue Stock Solution Absorbance Spectrum”. Remember all graphs need x-y-axis labels and titles. Plot the graph of order 2 polynomial as the best fit curve. The best-fit curve should show the equation of the line, it does not need to pass through the origin (0,0).
Which of the curves seems to have the shortest vertical line around its equivalence point? Explain why. (If you suspect that your data are inaccurate, explain which curve you think should have been most vertical and why.)
The spectrophotometer is set at 600 nm. The absorbance of each cuvette is read. The data is shown below: Cuvette 1 is the clank Cuvette # ml albumin Absorbance 0. 0.2 .063 3 0.4 .163 4. 0.6 .187 0.8 .253 1.0 .289 Using this data, plot an Excel graph showing absorbance (y-axis) vs ml albumin (x-axis). Find the correlation coefficient (r). R2 > 0.99 = excellent data; r2 0.98-0.95 good data r2 0.94 -0.90 = fair data. How would you describe this data?- To find the relative sensitivity, for each of tubes 2-6 (neglect blank), perform the following operation absorbance (Lowry)/Absorbance (Biuret x 0.5 gram albumin (Biuret)/0.05 gram (Lowry) x 200 ml (Lowry)/100 mL (Biuret). This implifies to Relative sensitivity = 20 dilution factor x absorbance (Lowry)/Absorbance (Biuret). Report your relative sensitivity as an average of all 5 values.
A 0.1 g amine-containing compound is dissolved in water then diluted to 100 mL. To get the concentration of amine in this compound, you subject it to spectroscopic analysis. So, you get 1 mL of the previously diluted sample then dilute it again to 250 mL for measurement. Then, you fill 3/4 of a 1-cm cuvette with this diluted sample then you run an analysis using an AAS. The recorded absorbance is 0.545 at 410 nm. Solve for the molecular weight of the compound. The molar absorptivity is 1.23 x 104 cm-1 mol-1 L.
Please help me figure out how to put this in my calculator [0.8(1/12)]^2 The correct answer is 0.00445 My calculator is Casio fx-115 ES
Please confirm if my answer is correct or not. Due to the need for this to be correct I would like you to provide me with a confidence score in you answer on a scale from 1 to 10 how confident are you in your answer. Please be sure to double check your answer
Which of the following describes a gradient elution process? stationary phase has varying concentration stationary phase has static concentration mobile phase has varying concentration mobile phase has static concentration