2. Several standards were chromatographed, 0.5 1.0 2.0 Conc (ug/ml) Peak area 5.0 10.1 17.2 and the results are shown below: 3.0 6.0 8.0 19.8 39.7 57.3 10.0 66.9 15.0 95.3 Graph using concentration as the X-axis and peak area as the Y-axis. Use Excel to determine the equation of the line. What type of standardization was used above?

2. Several standards were chromatographed, 0.5 1.0 2.0 Conc (ug/ml) Peak area 5.0 10.1 17.2 and the results are shown below: 3.0 6.0 8.0 19.8 39.7 57.3 10.0 66.9 15.0 95.3 Graph using concentration as the X-axis and peak area as the Y-axis. Use Excel to determine the equation of the line. What type of standardization was used above?

Appl Of Ms Excel In Analytical Chemistry

2nd Edition

ISBN:9781285686691

Author:Crouch

Publisher:Crouch

Chapter2: Basic Statistical Analysis With Excel

Section: Chapter Questions

Problem 4P

See similar textbooks

Similar questions

What is the relative average deviation in the following percent KHP values in ppt? 46.80% 47.23% 48.03%
Q1: The following are relative peak areas for chromatograms of standard solutions of methyl vinyl ketone (MVK) MVK concentration mmol/L 0.5 Relative peak area 3.76 1.5 9.16 2.5 15.03 3.5 20.42 4.5 25.33 5.5 31.97 A sample containing MVK yielded relative peak area of 21.3. Calculate the concentration of MVK in the sample.(use excel)
Chromatography is based on molecules differing physical properties as a means of separating compound mixtures. Group of answer choices True False
Chromatography involves the separation of two or more compounds/ions caused by their molecular interactions with two phases. True False
1) Consider the data in the table below for chromatograms collected on different lengths of gas chromatography columns. Answer the following questions using Excel. L = 15 m L = 30 m L = 60 m Species tR (min) W1/2 (min) 4R (min) W1/2 (min) tR (min) W1/2 (min) 1 1.290 0.016 2.581 0.023 5.147 0.031 2 1.309 0.016 2.616 0.023 5.222 0.032 3 1.332 0.017 2.664 0.024 5.325 0.034 4 1.401 0.018 2.804 0.025 5.616 0.036 a. Calculate both the average number of plates and the average plate height (in µm) for each column, considering all four species. b. Calculate the measured resolution between peaks 1 and 2, 2 and 3, and 3 and 4 for each column.
6. The concentration of caffeine in an energy soft drink was determined by standard addition using HPLC. The following procedure was used: a standard caffeine solution was prepared by adding 0.09850g of caffeine to 25.0 cm3 of water.A series of solutions were prepared by adding known volumes of the standard solution to the soft drink before diluting to 100 cm3. The volume of standard and the caffeine peak area are shown in the table: Energy Drink (cm3) Added caffeine Std (cm3) Peak area 15 0 965 15 5 1352 15 10 1739 15 15 2126 15 20 2513 Determine the concentration of caffeine in the soft drink as mg cm-3. A. 3.3 B. 2.3 C. 4.3 D. 7.3
[References) A method for the determination of the corticosteroid methylprednisolone acetate in solutions obtained from pharmaceutical preparations yielded a mean value of 3.7 mg mL with a standard deviation of 0.3 mg mL. For quality control purposes, the relative uncertainty in the concentration should be no more than 3%. How many samples of each batch should be analyzed to ensure that the relative standard deviation does not exceed 9% at the 95% confidence level? samples
According to the information given below, compute the correlation coefficient and the covariance coefficient between stock A and stock B. Standard deviation of the portfolio (stock A and stock B) : 0.37Standard deviation of the stock A : 0.38Standard deviation of the stock B : 0.43Weight for stock A : 0.60Weight for stock B : 0.40NOTE: PLEASE SHOW HOW YOU COMPUTE EACH OF THE ITEMS.
A new method for the analysis of mercury was in an ore sample was tested and obtained the following data: Trial % Hg 1 12.76 2 12.57 3 12.72 4 12.79 5 12.76 Average: 12.72 St. Deviation: 0.08746 The standard method for mercury analysis was also used to test the ore. Is the mean value of the new method significantly different from the mean value of the accepted value at the 95% confidence interval? You may assume the standard deviations are the same. Accepted Method Results # of samples = 6 Average = 12.63% Hg Standard deviation = 0.053
A chromatographic analysis is performed with a sample containing toluene and benzene. The column length was 25 m and the flow rate 45 mL/min. Solute tR air 1.75 benzene (A) 7.00 1.85 toluene (B) 16.10 1.65 Calculate the theoretical plate height for each peak. Benzene: 109 mm/plate and Toluene 16 mm/plate Benzene: 105 mm/plate and Toluene 49.7 mm/plate Benzene: 172 mm/plate and Toluene 175 mm/plate Benzene: 119 mm/plate and Toluene 181 mm/plate
What is the relative average deviation in the following percent KHP values in ppt? (Enter your answer as a number without units.) 46.89 % 47.51 % 47.92 %
Analysis of a standard solution at a concentration of 5 ppm Fe (III) is done with a new analysis method. The experiment is repeated 3 times, and the average iron ion concentration is determined as 4.7 ppm. The standard deviation, s = 0.1, is calculated according to the results of the three experiments. Does the new analysis method contain systematic errors at a 95% confidence level? (Choose the t value from the Table) t values Degrees of freedom 95% CL 1 12.7 4.3 3.18 4 2.78 O a. A systematic error exists O b. Only random error exists