Consider the following data set:Sample12345Diluted Unknown (25% dilution)Diluted Unknown (50% dilution)Undiluted UnknownAbsorbance at 470 nm0.0320.0580.0900.1140.1400.0720.1380.210Concentration1.00 x 10-³ M2.00 x 10-³ M3.00 x 10-³ M4.00 x 10-³ M5.00 x 10-³ M1. Using MS Excel, plot a calibration curve for samples 1 to 5 (Attach a printed copy of the graph).Determine the molar absorptivity.2. Calculate the concentration of the diluted and undiluted unknown using the linear regression equationproduced from #1.3. Back-calculate the concentration of the undiluted unknown using the calculated concentration of the25% and 50% diluted unknown from #2.4. Explain any significant difference that you see between the concentration of the undiluted unknownthat is back-calculated from the absorbance of the 25% and 50% diluted unknown, and theconcentration that is directly calculated from the absorbance of the undiluted unknown.77

“Since you have posted a question with multiple sub-parts, we will solve the first three subparts…

Consider the following data set: Sample 1 2 3 4 5 Diluted Unknown (25% dilution) Diluted Unknown (50% dilution) Undiluted Unknown Absorbance at 470 nm 0.032 0.058 0.090 0.114 0.140 0.072 0.138 0.210 Concentration 1.00 x 10³ M 2.00 x 10-³ M 3.00 x 10-³ M 4.00 x 10-³ M 5.00 x 10-³ M . Using MS Excel, plot a calibration curve for samples 1 to 5 (Attach a printed copy of the graph).

Consider the following data set: Sample 1 2 3 4 5 Diluted Unknown (25% dilution) Diluted Unknown (50% dilution) Undiluted Unknown Absorbance at 470 nm 0.032 0.058 0.090 0.114 0.140 0.072 0.138 0.210 Concentration 1.00 x 10³ M 2.00 x 10-³ M 3.00 x 10-³ M 4.00 x 10-³ M 5.00 x 10-³ M . Using MS Excel, plot a calibration curve for samples 1 to 5 (Attach a printed copy of the graph).

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

Please create a caption for this table. Solution NaCl Conc. (%) Osmolality (mOsm) % transmittance Absorbance % hemolysis % crenation C distilled 0 0 0.001029 4.987584625 100 0.03354 1 0.177179111 54.61 0.001551 4.809388202 96.42720001 0.05837 2 0.297126222 91.58 0.01012 3.994819487 80.09527231 0.08444 3 0.442542222 136.4 3.849 1.414652089 28.3634704 0.134 4 0.590164444 181.9 64.8 0.188424994 3.777880643 0.2125 5 0.74752 230.4 95.64 0.019360433 0.388172513 0.3368 6 0.89644 276.3 99.56 0.001915112 0.038397585 0.5336 7 1.095648889 337.7 99.98 8.68676E-05 0.001741676 0.9834 8 1.336711111 412 100 0 0 2.1 9 1.755568889 541.1 100 0 0 7.9 10 2.674395556 824.3 100 0 0 57.83 11 4.490211111 1384 100 0 0 99.72
Penform the following and give your answer with the proper number of Saif.figs 0.0202 ÷ 4.50(2.3x10³)
37. A student recorded the following data for the alcohol content of a blood sample: % C.H5OH: 0.084, 0.068, and 0.079. Calculate the 95% confidence limit for the average of this data.
Simplify. Write each answer in scie 17) (5.4x 10")는 (7X/0") 19) (6 x 10°(4 x 10-1) 21) (7.68 x 10:)는 (9x/0°)
Sample IdentificationCodeConcentration of M%TA=2-log(%T)Q50004.00 x 10-417.90.75Q50013.20 x 10-425.00.6Q50022.40 x 10-435.70.46Q50031.60 x 10-450.20.3Q50048.000 x 10-570.80.15SampleIdentificationCode%TA=2-log(%T)AMQ0210150143.70.359518560.360.000192Q0210150244.10.355561410.360.00018Q0210150343.80.358525890.360.00017Q0210150444.10.355561410.360.00018Q0210150543.80.358525890.360.00017What was their percent error?43%Does Batch 021015 meet legal requirements?No, because it is not between 2.85 * 10(4) and 3.15 * 10(4)Well #DropsBluedye1234567891012345678910Drops 9Distilled water876543210Concne 0.26tration0.52Test Tube #0.781.041.3Solutions3Concentration (M)2.082.32.6Concentration (ppm)1:1 dilution11.82Starting Dilution21.562:1 dilution0A.Zero standard0Was your calibration curve as linear as you expected?B.Did you experience any â€œdriftâ€ of the resistance readings?C.What is the equation of your best-fit line?D.What commercial drink did you analyze?E.Assuming…
STANDARD SAMPLE PREPARATIONS FOR ABSORBANCE & CONCENTRATION DATA Concentration of stock nickel sulfate hexahydrate solution = .400 Molarity Sample Volume Absorbance Concentration (In Molarity) a 5 mL .179 10 mL .329 15 mL .588 20 mL .760 25 mL .939 Reference Blank = 0 Please show how to find Molarity, please show steps. Thank you and stay safe.
7) The homogeneity of the chloride level in a water sample from a lake was tested by an analyst. Below are the concentration in parts per million (ppm) of Cl: 27.32, 27.22, 27.21, 27.24, 27.20 i. Determine the mean and median. ii. Calculate the confidence limit at 90%. iii. Identify a possible outlier and use the Q-test to determine whether it can be retained or rejected at 90% confidence level
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
My answer here is 18.5 % and 1.98 ft3 please verify
i. ( Br. Br jo NaOH 200°C 1. (Sia) ₂BH 2. H₂O₂/NaOH Br₂ NaNH, 150°C Lindlar's/H₂ 3
4. A fat sample with combination of acids contain standard hydrochloric acid for blank and sample with 8mL and 5mL respectively. The normality of the standard hydrochloric acid is 0.93N and the weight of the sample is 3 grams. Calculate the saponification value.
The following Absorbance vs concentration of nitrite graph is obtained for a set of data: Absorbance Vs Concentration y = 1.6628x+0.0373 R? = 0.9893 1.8 1.6 1.4 1.2 1 0.8 0.6 0.4 0.2 0.2 0.4 0.6 0.8 1 Concentration of nitrite (mg/L) Determine the concentration of unknown solution for which the absorbance is determined as 0.69 A. More data is required В. 0.69 С. 0.65 D. 0.39 Absorbance