Excel HW 3 Fall 2023 (2)

xlsx

School

Louisiana State University *

*We aren’t endorsed by this school

Course

2001

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

26

Uploaded by ColonelMusic12437

Report
Instructions for Homework 3 Clearly label any graphs, label the x and y axes, and give a descri When you upload your excel file to moodle, please include your f Do not use any special symbols, periods, commas in the filename Clearly label each answer with the number and letter of the quest Homework is due 10-31-2023 Your score: HPLC Question 1 15 GC/MS Question 2 15 TLC Question 3 5 AAS-errors Question 4 20 FTIR Question 5 10 PCB Question 6 5 vocabulary Question 7 30 total 100 0 Possible points
iptive title for each chart. full name as part of the filename. e. tion, so that you can receive full credit.
The concentration of each of the drug standards was 10 ug/L. Data for retention times and detector response is provided in the table below. (5 pts) A. Calculate the response factor for each compound. (5 pts) B. Identify each of the peaks (match the retention times) for the patient sample. (5 pts) C. Calculate the concentrations for the compounds in the patient sample. Calibration table area response Identity Response Factor 2.50 125,408 Pravastatin 0.00007974 3.92 115,899 Atorvastatin 0.00008628 5.75 114,250 Fluvastatin 0.00008753 8.11 108,566 Lovastatin 0.00009211 Question 1. An HPLC chromatogram & peak IDs for analysis of cholesterol-loweri retention time (min)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
10.15 105,426 Simvastatin 0.00009485 Patient sample area response Identity Concentration 2.50 - 3.92 54,000 Atorvastatin 4.659 5.75 - 8.11 - 10.15 168,886 Simvastatin 16.02 retention time (min)
Response Factor = standard concentration/ peak area Enter information in the table below Enter information in the table below Concentration 10 ing drugs is shown above.
Concentration = response * area
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(5 pts) (5 pts) (5 pts)
Analysis with GC/MS The concentration of each of the drug standards was 100 mg/L. Data for retention times and detector response is provided in the table below. A. Calculate the response factor for each compound and fill in the table below. B. Identify each of the peaks (match the retention times) for the patient sample, by filling in the second table. C. Calculate the concentrations for the compounds in the patient (unknown) sample, and enter this information Calibration table peak peak area Rf Peak ID response factor = standard 1 9.82 247886 0.0004034 Methamphetamine 2 11.53 248955 0.0004017 Nicotine concentration: 3 18.21 184233 0.0005428 Caffeine 4 18.72 192115 0.0005205 Diphenhydramine 5 18.95 240336 0.0004161 Lidocaine 6 20.82 161000 0.0006211 Phenobarbital 7 24.05 212456 0.0004707 Methadone 8 25.41 218364 0.0004580 Amitriptyline 9 25.81 141551 0.0007065 Cocaine 10 26.45 118000 0.0008475 Desipramine 11 29.65 151988 0.0006579 Codeine 12 30.55 158655 0.0006303 Diazepam 13 30.72 41258 0.002424 Morphine 14 34.02 125432 0.0007972 Heroin 15 34.48 152466 0.0006559 Prazepam 16 35.76 142566 0.0007014 Fentanyl Unknown sample - patient peak peak area Peak identity Concentration = Response 1 9.82 0 Methamphetamine 0 2 11.53 24844 Nicotine 10 3 18.21 32166 Caffeine 17 4 18.72 0 Diphenhydramine 0 5 18.95 0 Lidocaine 0 6 20.82 0 Phenobarbital 0 7 24.05 31698 Methadone 15 8 25.41 0 Amitriptyline 0 9 25.81 0 Cocaine 0 10 26.45 0 Desipramine 0 11 29.65 0 Codeine 0 12 30.55 0 Diazepam 0 13 30.72 2153 Morphine 5 14 34.02 0 Heroin 0 Question 2. A chromatogram & peak IDs for analysis of certain drugs of abuse are shown to the left. retention time (min) retention time (min) concentration (ppm)
15 34.48 0 Prazepam 0 16 35.76 0 Fentanyl 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
in the table. d concentration / peak area 100 e * Peak
For the TLC (3 pts) A. What is S1 = 52/60 S2 = 34/60 S3 = 11/60 (2 pts) B. What is P is S2 whi
C plate shown on the left, calculate the following. S1 = standard 1, red dye A S2 - standard 2, green dye B S3 = standard 3, yellow dye C the Rf for the standards and product, S1, S2, S3 and P? 0 = 0.8667 0 = 0.5667 0 = 0.1833 s the identity of P? ich is green dye B
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Question 4 (20 points) fferent US rivers and tested for iron using flame AAS. The table below shows the AAS results for iron in mg (5 pts) A.) Calculate the average, standard deviation and standard error values using Exc (5 pts) B.) Plot the average iron value for each site. (5 pts) C.) To this graph, add error terms for a fixed 5% value. (5 pts) D.) Prepare the same graph with error terms for the standard deviation value. Hint: after preparing the graph, select the chart tools tab for layout to find the e Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 site Saginaw River Mississippi river Ohio river Red River Colorado River 1 26.8 32.2 44.9 42.1 16.3 2 24.2 30.2 48.6 44.2 14.2 3 20.3 36.6 46.5 40.2 15.9 4 22.6 35.2 40.2 38.6 16.9 5 23.5 40.2 41.5 35.9 16.8 6 28.6 28.9 44.8 48.6 13.4 7 29.9 25.1 42.7 45.2 18.7 8 30.2 32.6 47.6 44.6 17.4 9 12.6 35.9 49.3 43.9 16.5 10 16.8 33.1 50.4 41.2 16.4 11 18.9 30.6 41.5 42.7 13.9 12 25.5 33.4 48.8 40.2 19.2 13 29.9 32.8 47.2 39.4 17.4 14 28.6 34.6 43.9 38.2 15.6 15 30.2 40.2 44.4 37.6 15.4 Average Iron, mg/L 24.6 33.4 45.5 41.5 16.3 standard deviation 5.46 3.99 3.16 3.40 1.63 standard error 1.41 1.03 0.816 0.879 0.421 n 15.0 15.0 15.0 15.0 15.0
g/L. cel. Remember to label the X and Y axes. error bar tools. Saginaw River Mississippi river Ohio river Red River Colorado River 0.0 5.0 10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 Question B + C 5% Err Sites Average Iron (mg/L) Saginaw River Mississippi river Ohio river Red River Colorado River 0.0 5.0 10.0 15.0 20.0 25.0 30.0 35.0 40.0 45.0 50.0 Question D Sites Average Iron (mg/L)
Question 5. (5 pts for each spectra) Two FTIR spectra are shown at the right, identify the compounds. Top spectra: Decane Bottom spectra: Ethanol Hint #1 - use SDBS to compare to FTIR results. Hint #2 - here are some possibilities: methanol ethanol hexanol benzene decane acetone toluene AIST SDBS https://sdbs.db.aist.go.jp/sdbs/cgi-bin/cre_index.cgi
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Polychlorinated biphenyls or PCBs are a family of toxic organic chemicals known as chl were manufactured in the US from 1929 until manufacturing was banned in 1979. Due chemical stability, high boiling point and electrical insulating properties, PCBs were use commercial applications. EPA website: https://www.epa.gov/pcbs/learn-about-polychlorinated-biphenyls-pcbs PCBs are mixtures which have characteristic sets of peaks, which are identified as arocl chromatograms for aroclor standard samples analyzed with gas chromatography with a Decachlorobiphenyl was used as an internal standard, and was added to each sample e was added to each of the initial calibration standards and the unknown sample at 1000 in each chromatograms.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Question 6. (3 points) A. Identify the "unknown" aroclor for the chro (2 points) B. How would you quantify the amount of the lorinated hydrocarbons. PCBs to their non-flammability, ed in hundreds of industrial and lor number. Below are an electron capture detector. extract prior to analysis, and 0 ppb. It is identified as peak 1
omatogram below. Aroclor 1260 e aroclor for the "unknown" sample? Pace Analytical Services Aroclor analysis
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
e r c i p i 1 E 2 E x t r a 3 T 4 i t r a n t l n d 5 M e d i u m d p c i 6 C o l o r i m e t r y 7 D c i r i 9. A f f i n i t y 10 C h r o m a t o t t o n d o F 12 l C e 13 B u r e T u a a I 14 P l a s m a p r R n t r M 15 u a 16. A m e d e o A v o g a d r o y b b e s i o 17 L e w i s a c i d r e b G 18 p 19. P a a h n u 20. A u t o p r o t o l y s c s s e 21 S i z e e x c l u s i o n i 22. A r n o l d O r v i l l e B e n d F 23 E 24 25. S i r A l a n W a l s h s a u p t m a l r e t c i e 27 B u f f e r u t i 28 C o l u m n B l e e d
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
n
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
t a t i o n c t i o n 8 C h g r a 11. p h y o h m o a t t o o i g o r n a i m z a t o i s n c k m a n
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
one point for each word of the crossword puzzle ACROSS: 5. Statistical term which defines the central value of a distribution of numbers. 9. Molecules bind to a chromatography column and can finally be released by concentrated salt solutions or a change in pH. 16. Famous Italian mathematician/physicist who introduced the concept of the mole. 25. The Australian scientist who invented atomic absorption spectrophotometry. 28. This is what occurs when the stationary phase detaches from the column, observed as a change in the baseline of a chromat DOWN: 8. The visual output of a chromatograph, in which different peaks or patterns correspond to different components of the separa 10. An instrument component used for GC and HPLC separations 11. A non-destructive GC detector which responds to aromatic and saturated compounds. 12. A type of molecular spectroscopy which detects the absorbance of light in the infra-red region of the electromagnetic spect 18. A Bell shaped distribution of measurements. 23. Used to burn/heat samples to create ionization processes with certain types of AAS or GC methods. 24. The fluid or vapors which emerge from the end of a chromatography column. 26. A chromatographic technique which uses high liquid pressure for rapid separations 2.        The transfer of a solute between two immiscible liquids, or from one phase to another. 3. The reagent solution placed in a buret during a titration. 6. Any technique that uses color to measure chemical concentrations. 13. Piece of glassware used for titrations. 14. In ICP-AES, a very high temperature (7000-8000 K) excitation source that efficiently vaporizes, excites, and ionizes atoms 17. A molecule which accepts a pair of electrons. 19. An analytical separation which is based on the differences in solubility of various components. 20. The ability of a molecule to undergo self-ionization, to form both an acid and a base. 21. A type of chromatography where small molecules penetrate the pores of particles, and large molecules are excluded. 22. The American scientist who invented the pH meter. 27. A mixture of a weak acid and its conjugate base. 1.        As reagents are added during a titration procedure, a sudden change in physical properties (color change, light absorbance, 2.        A GC detector with a radioactive source for ionizing molecules, which is extremely sensitive to halogenated molecules. 4. This reagent shows a physical change (color change) when the equivalence point is reached in a titration. 7. A detector for UV/Vis measurements made of semiconductor elements. 15. The carrier gas or liquid in chromatographic separations. 16. A function of the incident light versus that which is transmitted through a sample.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Activity8-ErrorsAndPower-AnswerSheet (1).pdf
Activity6-Chi-SquareTests_AnswerSheet (1).pdf
ps33.pdf
ps55.pdf
ps44.pdf
HW2 Fall 2023.xlsx
ME_Unknown_Date_2.pdf
Stat 205 HW6.docx
MTH154Project2Soccer-1.xlsx
Homework 1 Spring 2024.docx
LAB3 Handout.docx
IMG_8077.png
Related Questions
Press | Esc to exit full screen All changes saved 5. What is the amplitude of the graph below? y 8- 7+ 6- 5- -1- -2+ -3+ -4+ -5+ -6- -7+ -8+ -9+ 4 PREVIOUS 5 of 17 NEXT
Oct 15, 12:51:13 PM Watch help video Graph the inverse of the provided graph on the accompanying set of axes. You must plot at least 5 points. *Click the graph to make a point. Click it again to erase. 10 9- 4 3 2 -10 -9 -8 -7 -4 -3 -2 -1 4 6. 9 10 -2 -3 -4 -5 -6 -7 -8 -9 -10 Submit Answer attempt 1 out of a
Please choose correct answer.
Please help
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Related Questions
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
SEE MORE TEXTBOOKS