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.
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
Show the steps and the formula on how to create this.
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
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
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
