Reproduce the spreadsheet in Figure 2-23 and the graph in Figure 2-24. Figure 2-23 Figure 2-24 A

Reproduce the spreadsheet in Figure 2-23 and the graph in Figure 2-24.

Figure 2-23

Figure 2-24

Transcribed Image Text:

A E F G H Calculating Density of H2O with Equation 2-4 (from the delightful book by Dan Harris) 3 1.00100 4 Constants: Temp (C) Density (g/mL) 1.00000 a0 = 0.99997 0.99900 6 0.99989 10 0.99970 0.99800 7 a1 = 15 0.99911 0.99700 Density 8 5.3322E-05 20 0.99821 0.99600 a2 = 25 0.99705 0.99500 0.99400 10 -7.5899E-06 30 0.99565 0.99300 11 a3 = 35 0.99403 0.99200 12 3.6719E-08 40 0.99223 0.99100 13 10 20 30 40 50 14 Formula: Temperature (°C) 15 C5 = SA$6+$A$8*B5+$A$10*B5^2+$A$12*B5^3 16 17 2. Density (g/mL)