View Single Post
  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Assuming that yData and xData are columnar data with no empty or
non-numeric cells, then select 3 contiguous cells in a row and array
enter (Ctrl-Shift-Enter)

=LINEST(yData,xData^{1,3})

As documented by Help, the reculting coeffients will be

(cubic, linear, intercept)

which is the opposite order to what you might expect.

Jerry

Cyanlce wrote:

how do i do cubic regression without the quadratic term? how do i tell excel
there is no x^2? i just want it to be ax^3+bx+c