Is it possible to generate transfer functions with Excel 2010 (or lower)?

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.

cross posts of this in other forums:
http://www.mrexcel.com/forum/showthr...=1#post2725426
http://www.mathhelpforum.com/math-he...er-181360.html

Hello & Welcome to the Board,

Please take a few minutes and read the Forum Rules about cross posts.

Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.

It is preferred that you not cross-post at all, but if you do, please provide a link to the cross-post