Page 333 - Excel for Scientists and Engineers: Numerical Methods
P. 333
3 10 EXCEL: NUMERICAL METHODS
4. Fit the data for freezing point of ethylene glycol by wt% shown in the
following table (also found in the problems for Chapter 5) to a cubic fitting
function and estimate the freezing points of 33.3 wt% and 42.3 wt% ethylene
glycol.
I Wt% Ethylene I Freezing Point, OF I
0.0 32.0
22.2
20.0 17.9
25.0 12.7
40.0
45.0 -17.5
50.0 -28.9
~~ ~ ~.
~
55.0 -42.0
60.0 -54.9
Table 13-3. Heat transfer fluid freezing point data.
5. Table 13-4 (also found on the CD) gives the specific heat of water at various
temperatures from 0°C to 100OC. Using LINEST, fit the data to a
-
polynomial of order 5.
Table 13-4. Specific heat of water at various temperatures.
6. Power output (P) from a gas turbine engine was measured at several different
throttle settings (7) and output shaft speeds (S). The data are shown in Table
13-5 and are also found on the CD-ROM. Use linear regression to obtain
