Given: The head loss due to friction in a pipe is given by, hu, KOⁿ where K includes the effects of the pipe diameter, length, and roughness, as well as the fluid viscosity. For the Darcy- Weisbach formula (Delleur, 2002), K is given as: K = 8fL/(π²gD⁵) and n = 2. L is the pipe length, Q is the discharge, and D is the pipe diameter. The pipe length is 30ft., the discharge is normally distributed with mean 1.5ft.³/s and standard deviation 0.7 ft.³/s, the pipe diameter is 1.2 ft., and the f factor ranges from 0.1 to 1.2 and could take any value within this interval.
Find run a simulation of head loss in Excel using 100 trials and the above parameters. Show results in a table including formula used to run the simulation.