Question
This must be donein VBA and NOT any other programming language!
Write a computer program that calculates the zero(s) of the following equations using the bisection method: To determine the number of zeros, plot these functions by hand or using a spreadsheet For each zero, choose your initial guess to be on either side so one initial guess is a positive f(x) and the other is a negative f(x). Stop the program when a successive iteration (i.e.. cycle through the loop) changes the estimate zero by less than 0.0001% (1 part in a million). Report your initial guesses and the number of iterations it takes to find the zero.
Explanation / Answer
This will help you.Please check and rate this
http://www.engr.uky.edu/~aseeched/SummerSchool/2007/session_handouts/Spreadsheets/4 Spreadsheet Programming & Interconnectivity/4 Documents/VBA Basics/VBA_bisection_example.pdf