Finding Asymptotes from a set of data in Excel

W

WAYNEL

Hi

Can anyone help me find asymptote from a set of data in two column x
and y that show the frequency responce of a say a freq. responce in
Excel?
Finding it from a function seem relatively easy but without a model for
the data is there a method of finding two lines that meet to produce
the turning point?


Cheers


WayneL
 
G

Guest

Hi WAYNEL
One way: Generate the functions a+b*x-y copied in a column parallel to x
and y, where a and b are linked to two cells. Their best values you can find
by means of Solver, minimizing the sum of quadrats of those function values
(in some third cell). Naturally, you have to eliminate the number of initial
pairs so that the a and b start to became approximately constant. Not too
mathematical algoritm but may work.
Regards
Petr Bezucha


WAYNEL píše:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get excel to recognise "infinity" for asymptotes in charts 2
how do I graph asymptotes in Excel 0
Outlook Code Run from Excel 3
Statistical summary of bucketed data 2
rotating an Isoceles Triangle in the shape of a Gauge needle 2
How to take a range input in a function and find the frequency of data in it. 3
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 2
How can I convolve 2 sets of data in Excel? 0

Top