Thread: trendline equation doesn't fit data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default trendline equation doesn't fit data
How did you get the fit ?? Using Solver I get:

y=0x^2 - 0.003024729x + 4136.60627

with fitted data:

809920.89 1686.815012
811026.35 1683.471295
812370.5 1679.405605
813553.47 1675.827441
814357.32 1673.396013

--
Gary''s Student - gsnu200735
Reply With QuoteReply With Quote