Given data:

The range of ambient air temperature is −30° C<Ta<10° C.

The range of wind speed is 20 kmh<V<80 kmh

Formula used:

Formula to calculate the more common equivalent windchill temperatures is,

Tequivalent=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33

Here,

Ta is the ambient air temperature in °C, and

V is the wind speed in kmh.

Calculation:

Refer to the Figure 1:

Column A shows the wind speed (V) with range from 20 kmh<V<80 kmh in increment of 10 and Row 8 shows the ambient air temperature with range from −30° C<Ta<10° C in increment of 5.

For the cell B9, the formula used to find the equivalent windchill temperatures as “=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33”.

Written as “=(0.045*((5.27*($A$9)^0.5)+10.45-(0.28*$A$9))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is −30 and $A$9 is an absolute cell reference which represent the value of cell A9 as 20. The result obtained in the cell B9 would be −47.6. Use the Fill command to copy the formula into cell C9, only the B8 cell in the formula is automatically substituted by C8, resulting in a value −41.2. Then, by click and drag the bottom corner of the C9 cell extend through J9 in row-wise. The result is obtained as in Table 1.

For the cell B10, the formula used to find the equivalent windchill temperatures as “=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33”.

Written as “=(0.045*((5.27*($A$10)^0.5)+10.45-(0.28*$A$10))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is −30 and $A$10 is an absolute cell reference which represent the value of cell A10 as 30. The result obtained in the cell B10 would be −54.6. Use the Fill command to copy the formula into cell C10, only the B8 cell in the formula is automatically substituted by C8, resulting in a value −47.7. Then, by click and drag the bottom corner of the C10 cell extend through J10 in row-wise. The result is obtained as in Table 1.

For the cell B11, the formula used to find the equivalent windchill temperatures as “=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33”.

Written as “=(0.045*((5.27*($A$11)^0.5)+10.45-(0.28*$A$11))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is −30 and $A$11 is an absolute cell reference which represent the value of cell A11 as 40. The result obtained in the cell B11 would be −59.4. Use the Fill command to copy the formula into cell C11, only the B8 cell in the formula is automatically substituted by C8, resulting in a value −52.0. Then, by click and drag the bottom corner of the C11 cell extend through J11 in row-wise. The result is obtained as in Table 1.

For the cell B12, the formula used to find the equivalent windchill temperatures as “=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33”.

Written as “=(0.045*((5.27*($A$12)^0.5)+10.45-(0.28*$A$12))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is −30 and $A$12 is an absolute cell reference which represent the value of cell A12 as 50. The result obtained in the cell B12 would be −62.6. Use the Fill command to copy the formula into cell C12, only the B8 cell in the formula is automatically substituted by C8, resulting in a value −55.0. Then, by click and drag the bottom corner of the C12 cell extend through J12 in row-wise. The result is obtained as in Table 1.

For the cell B13, the formula used to find the equivalent windchill temperatures as “=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33”.

Written as “=(0.045*((5.27*($A$13)^0.5)+10.45-(0.28*$A$13))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is −30 and $A$13 is an absolute cell reference which represent the value of cell A13 as 60. The result obtained in the cell B13 would be −64.7. Use the Fill command to copy the formula into cell C13, only the B8 cell in the formula is automatically substituted by C8, resulting in a value −57.0. Then, by click and drag the bottom corner of the C13 cell extend through J13 in row-wise. The result is obtained as in Table 1.

For the cell B14, the formula used to find the equivalent windchill temperatures as “=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33”.

Written as “=(0.045*((5.27*($A$14)^0.5)+10.45-(0.28*$A$14))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is −30 and $A$14 is an absolute cell reference which represent the value of cell A14 as 70. The result obtained in the cell B14 would be −66.1. Use the Fill command to copy the formula into cell C14, only the B8 cell in the formula is automatically substituted by C8, resulting in a value −58.2. Then, by click and drag the bottom corner of the C14 cell extend through J14 in row-wise. The result is obtained as in Table 1.

For the cell B15, the formula used to find the equivalent windchill temperatures as “=0.045(5.27V0.5+10.45−0.28V)(Ta−33)+33”.

Written as “=(0.045*((5.27*($A$15)^0.5)+10.45-(0.28*$A$15))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is −30 and $A$15 is an absolute cell reference which represent the value of cell A15 as 80. The result obtained in the cell B15 would be −66.8. Use the Fill command to copy the formula into cell C15, only the B8 cell in the formula is automatically substituted by C8, resulting in a value −58.8. Then, by click and drag the bottom corner of the C15 cell extend through J15 in row-wise. The result is obtained as in Table 1.

Table 1 is created to shows a Wind Chill Temperature.

Table 1

Figure 2 shows a wind chill table in the excel sheet has obtained as similar to given Problem 14.19 in the textbook

Conclusion:

Hence, a table is created for the windchill temperatures with the given range of an ambient air temperature, and wind speed have been explained using excel.