Good afternoon ,I am trying to solve a problem with two data series in a graph where I need find the interception of two series and find automatically a value .The problem is more easy to understand if is seen the example book that I attach to the post someone can help me please? I'll be very grateful for any help.
If you add a Logarithmic trend line and the related Equation, perhaps you can transpose the equation to get your required value
When you have a function defined by a table of values like this, there are basically two generic ways to get values in between the tabulated data points.
1) As noted by MickG, you can use a curve fitting/regression algorithm to find a suitable equation to describe the relationship between y and x. Then use suitable algebraic or numeric algorithms to solve this equation for the desired unkown. You can use the LINEST() function perform the regression, once you have determined a suitable equation. This is a fairly common topic here, so a suitable search through this site should find several examples of how to implement regressions in Excel.
2) Alternatively, you can use an interpolation algorithm. In an interpolation algorithm, we assume that the tabulated values are "exact" and use straight lines (or other curves) connecting these points to estimate values at intermediate points. Excel does not have a built in linear interpolation function (I know of at least one spreadsheet that does), so you have to build your own. We discuss this quite often, so a search through this site should find any number of examples of how to implement a linear interpolation in Excel.
Whichever approach you use, review what your searches find, then, if you still need help, let us know and we can help you implement whichever of these approaches you want to use.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks