View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default Matrix Inversion by Gaussian Reduction

Hi. May I ask how you set this up? I'm a little lost.
I was expecting a n*n array. I guess I don't understand the setup thou.
I noticed that the Abs values of the Fourier coefficients are close to
what you have. Is the OP trying to do a 1-dimensional Cos Trig fit?
These are not phased together by the angles given, just the abs values.

0.88611111,
0.018898028,
0.13342994,
0.064291005,
0.015228924,
0.064608047,
0.018986675,
0.0075864187,
0.0035608633,
0.021666667

= = =
Dana DeLouis

Bernard Liengme wrote:
Hi Dave,
I used Solver and got these results
coeff0 0.872399
coeff1 0.01781
coeff2 0.006306
coeff3 -0.01764
coeff4 0.024949
coeff5 0.124181
coeff6 0.138704
coeff7 0.067487
coeff8 -0.03891
coeff9 -0.01647
coeff10 0.078441


The sum of deviations squared was 0.091386
Send me email (remove TRUENORTH.) and I will send you a file
best wishes