1. Below is given the FT-IR (Fourier Transform Infra Red) data of a 1:1 (by weight) mixture of ethylene carbonate (EC) and dimethyl carbonate (DMC). Absorbance P is given as a function of wavenumber, m. Table 1 Absorbance as a function of wavenumber Absorbance, P | (arbitrary unit) Wavenumber, m |(cm-1) 804.184 827.326 846.611 0.1591 0.0439 0.0050 869.753 0.0073 889.038 0.0448 892.895 900.609 0.0649 0.1204 Regress the above data to a linear and second order polynomial. Use MS Excel.
1. Below is given the FT-IR (Fourier Transform Infra Red) data of a 1:1 (by weight) mixture of ethylene carbonate (EC) and dimethyl carbonate (DMC). Absorbance P is given as a function of wavenumber, m. Table 1 Absorbance as a function of wavenumber Absorbance, P | (arbitrary unit) Wavenumber, m |(cm-1) 804.184 827.326 846.611 0.1591 0.0439 0.0050 869.753 0.0073 889.038 0.0448 892.895 900.609 0.0649 0.1204 Regress the above data to a linear and second order polynomial. Use MS Excel.
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter7: Analytic Trigonometry
Section7.6: The Inverse Trigonometric Functions
Problem 94E
Related questions
Question
Show the steps and the formula on how to create this.
![1. Below is given the FT-IR (Fourier Transform Infra Red) data of a 1:1 (by weight) mixture of
ethylene carbonate (EC) and dimethyl carbonate (DMC). Absorbance P is given as a function of
wavenumber, m.
Table 1 Absorbance as a function of wavenumber
Wavenumber, m
(cm-1)
Absorbance, P
|(arbitrary unit)
804.184
0.1591
827.326
0.0439
846.611
0.0050
869.753
0.0073
889.038
0.0448
892.895
0.0649
900.609
0.1204
Regress the above data to a linear and second order polynomial. Use MS Excel.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff7ea06d7-c5d2-444f-aa86-9b83c6e4fec3%2F7543c88c-56b2-46c4-bb1f-c70272ed1086%2Frebpep7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:1. Below is given the FT-IR (Fourier Transform Infra Red) data of a 1:1 (by weight) mixture of
ethylene carbonate (EC) and dimethyl carbonate (DMC). Absorbance P is given as a function of
wavenumber, m.
Table 1 Absorbance as a function of wavenumber
Wavenumber, m
(cm-1)
Absorbance, P
|(arbitrary unit)
804.184
0.1591
827.326
0.0439
846.611
0.0050
869.753
0.0073
889.038
0.0448
892.895
0.0649
900.609
0.1204
Regress the above data to a linear and second order polynomial. Use MS Excel.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage