LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Matrix Inversion by Gaussian Reduction

Thanks -
A = {10,30,50,70,90,110,130,150,170,190,210,230,250,27 0,290,310,330,350} ;
angles in degrees.
f(A) =
{0.87,0.8,1,1,0.98,0.98,0.98,0.75,0.65,0.69,0.97,0 .98,1,0.98,0.95,0.73,0.77,0.87} ; observations.
model f(A) = a0 + a1.cos A + ... + an.cos n.A + ...
ie Cos matrix . F(a) matrix = f(A) matrix
F(a) = {a0, a1, ... an, ...}
find F(a)


"Dana DeLouis" wrote:


Hi. Using LU Decomposition can sometimes be a little more stable.
If also offers a few other benefits.

http://en.wikipedia.org/wiki/LU_decomposition

Feel free to send me your data
= = =
Dana DeLouis



David C wrote:
Thank you all - what I found was that Minverse was giving silly results, or
even ERROR messages, which could be changed by small changes in some of the
'A' matrix numbers; ie the fault may well lie in the source data not the
process. I wanted an alternative (and more compact) process to compare
results, to determine where the fault may lie.
Using Minverse to solve the Cosine matrix for a cyclic model, sometimes the
resulting coefficients were divergent too, adding to the instability. The
results, when reconstructed and compared with the data, did not even pass
through the data points.
f(A) = a0 + a1.cos A + ... + an.cos n.A + ...
F(a) = [ a0, a1, ... an, ... ]
Cos matrix . F(a) matrix = f(A) matrix

Still working the problem - grateful for comments.

"Dana DeLouis" wrote:

Could be just a high "Condition Number" that's associated with his matrix.

http://en.wikipedia.org/wiki/Matrix_condition_number

Dana DeLouis


Gary''s Student wrote:
No guarantee at all!

Clearly David is having problems with some of his matrices. The code in
wikipedia is small enough that it could be re-coded in a couple of hours.

David could compare the results from the Gaussian method to whatever
Microsoft uses.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gaussian Curve using Normdist? [email protected] Excel Worksheet Functions 3 May 7th 07 05:39 PM
Reduction Fractions to LCD chad Excel Discussion (Misc queries) 7 February 8th 07 05:14 PM
data inversion! via135 Excel Worksheet Functions 4 May 7th 06 10:12 AM
Gaussian Elimination cjrrussell Excel Worksheet Functions 11 December 23rd 05 08:59 AM
need help with a formula - % reduction andy New Users to Excel 3 July 19th 05 08:59 PM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"