Thread: Performing a second order polynomial linear regression in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanVM[_12_] RyanVM[_12_] is offline
external usenet poster
  
Posts: 1
Default Performing a second order polynomial linear regression in VBA
Hi, I'm attempting (as the title states) to perform a second orde
linear regression analysis on a set of data.

Where I'm running into trouble is with the {1,2} part of the formula
The VBA compiler complains about the curly brackets being invali
characters. What should I substitute to make it work
Code
-------------------
CurveFitA = Application.WorksheetFunction.Index(Application.Wo rksheetFunction.LinEst(Range("C" & MinRow & ":C" & MaxRow),(Range("B" & MinRow & ":B" & MaxRow))^{1,2}),1
-------------------


--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote