So, the term k/m is now the slope of this equation and 1/m is the intercept. Remember, we’ve linearized the hyperbolic equation into the form: (How about that? It’s almost like I planned it that way. Just as a quick check, we can plot these two new columns (E and F) on a chart and see that the relationship between them is indeed linear.
When the formulas are filled down, we get the following: We need to create two new columns in our spreadsheet – one for values of 1/x and another for the values of 1/y. That means we need to get it in a form that looks like the equation of a line:īy taking each side to the power of -1 and doing a little bit of rearranging, we get the linear form of the hyperbolic equation:įantastic! Now what? Hyperbolic Curve Fitting in Excel We can use the SLOPE and INTERCEPT functions to get the values of m and k that best fit the hyperbolic equation to the data, but first we need to “linearize” the equation. We’ll look at this data set, which shows a very hyperbolic characteristic when plotted: There’s no built-in tool for curve-fitting these functions in Excel, but we can get it done with a little bit of math and creativity. I’ve talked about the various procedures for fitting different types of curves on this blog before, but today I want to show you a technique for hyperbolic curve fitting in Excel.
0 kommentar(er)
