Question
The data table given below lists the freezing points of aqueous solutions of ethylene glycol. Wt% Ethylene Glycol Freezing Point, F 0.0 32.0 5.0 29.4
The data table given below lists the freezing points of aqueous solutions of ethylene glycol.
Wt% Ethylene Glycol |
Freezing Point, F |
0.0 | 32.0 |
5.0 | 29.4 |
10.0 | 26.2 |
15.0 | 22.2 |
20.0 | 17.9 |
25.0 | 12.7 |
30.0 | 6.7 |
35.0 | -0.2 |
40.0 | -8.1 |
45.0 | -17.5 |
50.0 | -28.9 |
55.0 | -42.0 |
60.0 | -54.9 |
a. Using Excel, convert the temperatures to the Celsius scale and plot the data points with Wt% Ethylene Glycol on the x-axis with major units marked every 10% from 0 to 60% and Freezing Point, C on the Y-axis with major units marked every 20C from -60 to 0
b. Fit the data to a 4th order equation: T = aW4 + bW3 + cW2 + dW + e
c. Plot the calculated equation as a continuous line on the same graph as the displayed data points.
d. Using the fitted 4th order equation calculate the freezing points in C of 17.6 wt% and 48.8 wt% ethylene glycol.
3. (20 pts) The data table given below lists the freezing points of aqueous solutions of ethylene glycol. a. Using Excel, convert the temperatures to the Celsius scale and plot the data points with Wt% Ethylene Glycol on the x-axis with major units marked every 10% from 0 to 60% and Freezing Point, C on the Y-axis with major units marked every 20C from 60 to 0 b. Fit the data to a4th order equation: T=aW4+bWW3+cW2+dW+e Plot the calculated equation as a continuous line on the same graph as the displayed data points. c. Using the fitted 4th order equation calculate the freezing points in C of 17.6wt% and 48.8wt% ethylene glycolStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started