View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default polynomial regression

Follow:

http://spreadsheetpage.com/index.php...line_formulas/

Consider using VBA to place the formulas in worksheet cells or use
EVALUATE() to evaluate then directly.
--
Gary''s Student - gsnu200825


"Lucile" wrote:

Hello,
I need to do a polynomial regression, 5th order.
I think I am using the right formula: application.linest(x,y^{1,2,3,4,5})
My problem is that {} is not accepted! Invalid character.
I am using excel 2000.

What can I do to fix this problem?
Thanks