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

Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
7th Edition
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Alexander, Daniel C.; Koeberlein, Geralyn M.
ChapterP: Preliminary Concepts
SectionP.CT: Test
Problem 1CT
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
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Elementary Geometry for College Students
Elementary Geometry for College Students
Geometry
ISBN:
9781285195698
Author:
Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS