In Chapter 10, we discussed fluid pressure and the role of water towers in small towns. Recall that the function of a water tower is to create a desirable municipal water pressure for household and other usage in a town. To achieve this purpose, water is stored in large quantities in elevated tanks. Also recall that the municipal water pressure may vary from town to town, but it generally falls somewhere between 50 and 80 Ibfin2 (psi). In this assignment, use Excel to create a table that shows the relationship between the height of water above ground in the water tower and the water pressure in a pipeline located at the base of the water tower. The relationship is given by

P = ρgh

where

P = the water pressure at the base of the water tower in pounds per square foot (Ib/ft ² ) p = the density of water in slugs per cubic foot, p = 1.94 slugs/ft ³ g = the acceleration due to gravity, g = 32.2 ft /s ² h = the height of water above ground in feet (ft) Create a table that shows the water pressure in lb/in ² in a pipe located at the base of the water tower as you vary the height of water in increments of 10 ft. Also plot water pressure (lb/in ² ) vs. the height of water in feet What should be the water level in the water tower to create 80 psi water pressure in a pipe at the base of the water tower?