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
icon
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.
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
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,