need help with this question to apply in excel

Suppose an anemometer is set up at a height of 2 m above the ground in a corn field. Use equation (3.27) to calculate the velocity profiles up to a height of 5 m above the ground when the anemometer measures a velocity of 4 m/s and

a. the corn is at a height of 0.5 m;

b. the corn is at a height of 1.5 m. Plot both profiles on the same graph (arithmetic axes), with z on the vertical axis (m) and u(z) on the horizontal axis (m/s)

Box 3.1 Example Calculations of Wind Profiles Suppose an anemometer is set up at a height of 2 m This value is then used in equation (3.27) to gen- above the ground in a corn field. Use equation (3.27) to erate the vertical wind profile (figure 3.11). calculate the velocity profiles up to a height of 5 m b. When Zveg = 1.5 m, the zero-plane displacement above the ground when the anemometer measures a height, z, and the roughness height, zo, are velocity of 6.0 m/s when (a) the corn is at a height of 0.5 m and (b) the corn is at a height of 1.5 m. Plot both pro- Z= 0.7 x 1.5 m = 1.05 m; files on the same graph. Zo =0.1 x 1.5 m = 0.15 m. a. When Zveg = 0.5 m, equations (3.28) and (3.29) give Then equation (3.27) becomes the zero-plane displacement height, z, and the roughness height, zo as w(z) = 2.5 . U. . In 2-1.05 0.15 Z =0.7 x 0.5 m = 0.35 m; Zo =0.1 x 0.5 m = 0.05 m. The friction velocity when u(2 m) = 6 m/s is thus Then, with k = 0.4, equation (3.27) becomes 6 m/s U.=- = 1.30 m/s. u(z) = 2.5 . u. . In Z-0.35 2.5 - In 2-1.05 0.15 0.05 Using equation (3.30a), the friction velocity when This value is then used in equation (3.27) to gen- u(2 m) = 6 m/s is thus erate the vertical wind profile when the corn is higher (figure 3.1 1). 6 m/5 = 0.69 m/s. 2-0.35 2.5 . In 0.05