How Do You Find Zeros Of Functions In Excel?
The zeros of a function are the values of the variable that make the function equal to zero. For example, the zeros of f(x)=x^2-1 are x=1 and x=-1. Here, the caret ^ denotes exponentiation. In Excel, you can use the Solver application to find a zero for a function using the methods of the field of mathematics called “numerical analysis.” You don’t need to know the details of the method. All you need to do is come up with a close guess as to one of the zeros of the function, and Excel will finish the job. Type your function into cell A1 of your Excel spreadsheet, using cell A2 in place of the variable. For example, if your function is f(x)=x^2-1, enter into cell A1 exactly the following: =A2^2-1. Enter your best guess in cell A2 as to what the zero of f(x) is. For example, for f(x)=x^3-3x+10, you might enter a number between -2 and -1 into cell A2, after noticing that f(-2) is -11 while f(-1) is +12. Since they are on opposite sides of zero on the number line, a zero for f(x) exists bet
