ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to obtain the root of f(x) in this interval? (https://www.excelbanter.com/charts-charting-excel/55898-how-obtain-root-f-x-interval.html)

Gaenn

How to obtain the root of f(x) in this interval?
 
I am trying to draw a graph here, plotted graph x, with function f(x) at
y-axis, does anyone know how to get the approximation to the root of f(x) in
this interval. What is the value of x if i wish to obtain f(x)=0?

Tushar Mehta

How to obtain the root of f(x) in this interval?
 
In article ,
says...
I am trying to draw a graph here, plotted graph x, with function f(x) at
y-axis, does anyone know how to get the approximation to the root of f(x) in
this interval. What is the value of x if i wish to obtain f(x)=0?

If you know the function, use Solver. If you don't, eyeball the graph.
What I do is zoom in on the segment of interest by changing the axes
Xmin, Xmax, Ymin, and Ymax values.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Bernard Liengme

How to obtain the root of f(x) in this interval?
 
Lots of examples in book ISBN 0 7506 5613 1
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gaenn" wrote in message
...
I am trying to draw a graph here, plotted graph x, with function f(x) at
y-axis, does anyone know how to get the approximation to the root of f(x)
in
this interval. What is the value of x if i wish to obtain f(x)=0?





All times are GMT +1. The time now is 06:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com