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

[MotM]

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.

 

[jeffreybrown]

Hello & Welcome to the Board,

Common courtesy is to post any and all cross posts.

http://www.excelforum.com/excel-gen...nsfer-functions-with-excel-2010-or-lower.html

 

[MotM]

Hello & Welcome to the Board,

Common courtesy is to post any and all cross posts.

http://www.excelforum.com/excel-gen...nsfer-functions-with-excel-2010-or-lower.html

Sorry about that. I thought cross posts only meant across subforums of a single domain.

Here is my only other cross post: http://www.mathhelpforum.com/math-h...ansfer-functions-excel-2010-lower-181360.html

 

[jeffreybrown]

No problem, but this is way above my knowledge level...sorry

 

[MotM]

No problem, but this is way above my knowledge level...sorry

That's why I cross posted. This topic isn't really a common knowledge area. I normally don't cross post.