Please type up the code and the excel is not needed.
Part 1: The Bisection method The Colebrook equation is a popular expression in fluid mechanics to approximate the friction factor for a given material. The friction factor (f) is impacted by turbulent intensity of the fluid Re), and relative pipe roughness (eD), 0.25 2.51 02 3.7D Ref log 1. Write a program that solves the Colebrook equation using the bisection method and prompts the user for (in mm), D (in mm), and Re# and solves for the friction factor. Assume 10 iterations. Choose appropriate values and report your results, check that your solution makes sense using the Moody Diagram (See the next page) (50 pts) Part 2: Verification with fzero 1. Use fzero to solve the problem in Part 1. You for sure should get the same answer (within reason). Use goal seek in excel to verify the answer provided in part 1 and 2. Obviously use the same inputs as Part 1 (25 pts) Part 1: The Bisection method The Colebrook equation is a popular expression in fluid mechanics to approximate the friction factor for a given material. The friction factor (f) is impacted by turbulent intensity of the fluid Re), and relative pipe roughness (eD), 0.25 2.51 02 3.7D Ref log 1. Write a program that solves the Colebrook equation using the bisection method and prompts the user for (in mm), D (in mm), and Re# and solves for the friction factor. Assume 10 iterations. Choose appropriate values and report your results, check that your solution makes sense using the Moody Diagram (See the next page) (50 pts) Part 2: Verification with fzero 1. Use fzero to solve the problem in Part 1. You for sure should get the same answer (within reason). Use goal seek in excel to verify the answer provided in part 1 and 2. Obviously use the same inputs as Part 1 (25 pts)