Homework Help is Here – Start Your Trial Now!
Math
Geometry
You are designing a spherical tank to hold water for a small village. The volume of liquid it can hold can be computed as: 2 (3R – h) V = th 3 where : V = volume, m' h = depth, m R= radius, m If R = 3m, to what depth must the tank be filled so that it holds a volume of 30m? SO

You are designing a spherical tank to hold water for a small village. The volume of liquid it can hold can be computed as: 2 (3R – h) V = th 3 where : V = volume, m' h = depth, m R= radius, m If R = 3m, to what depth must the tank be filled so that it holds a volume of 30m? SO

Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter7: Analytic Trigonometry
Section7.2: Trigonometric Equations
Problem 97E
See similar textbooks
icon
Related questions
Question

help please

Instruction: 1. Review your Advance Mathematics and Numerical Methods specially on the topics of root finding. 2. Using root finding numerical methods, solve the given problem. 3. Make a program in Microsoft excel that will solve the problem at the given volume of the tank. 4. The program must tell us to stop the iteration when the approximate error is below 0.00001%. You can use any method you prefer, whether from bracketing methods or from open methods. 5. Provide also a graph showing the changes in volume vs height. 6. The theoretical formulae must be written within the file (DO NOT use the built in excel formulae). 5. Create your own format (it must be unique and different from your classmates). 6. Sheet 1 will be for the main program, use other sheets if needed for tables of properties. PROBLEM: You are designing a spherical tank to hold water for a small village. The volume of liquid it can hold can be computed as: 2 (3R – h) V = nh 3 where : V = volume, m² h = depth, m R = radius, m If R = 3m, to what depth must the tank be filled so that it holds a volume of 30m?
Transcribed Image Text:Instruction: 1. Review your Advance Mathematics and Numerical Methods specially on the topics of root finding. 2. Using root finding numerical methods, solve the given problem. 3. Make a program in Microsoft excel that will solve the problem at the given volume of the tank. 4. The program must tell us to stop the iteration when the approximate error is below 0.00001%. You can use any method you prefer, whether from bracketing methods or from open methods. 5. Provide also a graph showing the changes in volume vs height. 6. The theoretical formulae must be written within the file (DO NOT use the built in excel formulae). 5. Create your own format (it must be unique and different from your classmates). 6. Sheet 1 will be for the main program, use other sheets if needed for tables of properties. PROBLEM: You are designing a spherical tank to hold water for a small village. The volume of liquid it can hold can be computed as: 2 (3R – h) V = nh 3 where : V = volume, m² h = depth, m R = radius, m If R = 3m, to what depth must the tank be filled so that it holds a volume of 30m?
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS