Hello, you just have to change the initial guesses (a and b) to find the other root. Try changing a = -2 and b = -1 , you'll get that the second root is -1.628.
Yes, if you can narrow your initial [a,b] to a domain with only one zero-crossing root in it. Your problem could quickly become numerically unstable though.
Hi! Our teacher wants us to use only 6 decimal places, yet I can't figure out where I should format the cells because it would only display in 6 decimal places but does not actually use it as the value. Can you help?
Hello, i'm not so sure what you mean by this, can't you just change the amount of decimal places on excel manually through the excel settings so that it becomes 6 decimal places?
Our teacher is very strict when it comes to rounding off; that's why we are following 6 decimal places. I already tried to tweak the number of decimal places in Excel, but this is just the display. What we actually need is the number rounded off already (say, for the value of c, the value that is already rounded off must be used in x). I hope you can help. This is for our practical. Thank you very much for your response.@@swaneeriverlearning
Our teacher is very strict when it comes to rounding off; that's why we are following 6 decimal places. I already tried to tweak the number of decimal places in Excel, but this is just the display. What we actually need is the number rounded off already (say, for the value of c, the value that is already rounded off must be used in x). I hope you can help. This is for our practical. Thank you very much for your response.@@swaneeriverlearning
![Bisection Method on Excel [Numerical Methods]](/img/logo.svg){kind=logo}
