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 4^th order equation: T = aW⁴ + bW³ + cW² + dW + e

c. Plot the calculated equation as a continuous line on the same graph as the displayed data points.

d. Using the fitted 4^th 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 glycol