Plotting a Hyperbolic trendline

[Meltonjrut]

I am trying to plot a hyperbolic trend line through a set of data. While that is not a standard option I have been researching but am still unclear on how to finish. I linearized my hyperbolic equation and found the k and m coefficient values. How do I proceed from there? How do I actually enter or use these values to plot the trend line on a graph?

 

[i_nth]

This blog post might help: Nonlinear Curve Fitting in Excel | EngineerExcel

 

[Meltonjrut]

This blog post might help: Nonlinear Curve Fitting in Excel | EngineerExcel

Yes, thank you. I have actually read this and followed its method but I am unclear what to do once I have solved for all of the variables. He gives no instructions on how to plug them in to graph the equation once we have found all the information. This is what I’m trying to figure out. Any help would be appreciated.

 

[i_nth]

Once you have the parameters for your fitted function, make a column of x values that you want to plot. In an adjacent column, calculate your function's value for each x value. Plot those x and function values.