This topic doesn't really fit well in any of the subsections of the forum so I figured this is the most appropriate place to put it.
If I have two random data sets of equal size (same number of elements) such as set X = (4,7,2,6,...) and set Y = (5,9,3,5,...) is there a way to use excel to find a transfer function between Y and X such that H(x)X(x) = Y(x)? In this case H(x) would be the transfer function which when multiplied by X(x) always produces Y(x) (i.e. X(1)H(1) = Y(1) = 5).
I know I could probably do this with MATLAB or some equivalent software, but I would ultimately have to port the transfer function over to Excel for my application thus it would be nice if I could just do this in Excel.
If there is no way to do this with Excel, please let me know of any other software you can think of that might be able to generate a transfer function of this nature.
cross posts of this in other forums: