Page 119 - Excel for Scientists and Engineers: Numerical Methods

96 EXCEL: NUMERICAL METHODS

Problems

Data for, and answers, to the following problems are found in the folder "Ch. 05
(Interpolation)" in the "Problems & Solutions" folder on the CD.

1. Using the table "Freezing and Boiling Points of Heat Transfer Fluid" shown
in Figure 5-1 (also found on the CD-ROM), obtain the freezing point of
30.5% and 34.5% solutions of ethylene glycol.

3. Using the table "Freezing and Boiling Points of Heat Transfer Fluid," find
the wt% ethylene glycol that has a freezing point of 0°F.

3. Using the following table (also found on the CD-ROM)

obtain an interpolated value for z at the following values of x and y by cubic
interpolation: x = 1 1/3, y = 1 2/3; x = 1.55,~ = 1.425.

4. Using the table "Viscosity of Heat Transfer Fluid" shown in Figure 5.4 (also
found on the CD-ROM), obtain the viscosity of a 30.5% solution of ethylene
glycol at 95"C, and the viscosity of a 74.5% solution of ethylene glycol at
195°C.

5. Using the following table (also found on the CD-ROM), obtain a value for
the refractive index of benzene at the following pressure and wavelength
values: 1 atm, 5000 A; 1 atm, 6600 A; 500 atm, 5000 A; 900 atm, 5000 A; 1
atm, 4600 A.