Thread: Lookings for optimal coefficient
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Surfer
 
Posts: n/a
Default Lookings for optimal coefficient
I have a set of numbers A1:A10.

I have a formula A1:A10 ~ x*B1:B10 + y*C1:C10 + z*D1:D10

How do I find the optimal set of x,y,z to give the result closest to A1:A10
for every B1:B10,C1:C10,D1:D10




Reply With QuoteReply With Quote