Bivariate Power Coefficient Curve Fit in JMP

mikes1098

I am trying to do a very simple Power Coefficient Fit in JMP.  In excel it is very simple – therefore I know JMP has to be able to do it…but for the life of me I cannot figure it out.... any ideas would be greatly appreciated

Simple Data Set Example:

Attatched

Excel fit that I am trying replicate:

jmp forum.xls

ms

You can use the Fit Model platform or Fit Special in the Fit Y by X platform. Fit Special is found under the red triangle in the Fit Y by X report. Choose log transform for both Y and X variables.

A scripting example:

Bivariate(

  Y( :y axis ),

  X( :X axis ),

  Fit Special( xTran( "Log" ), yTran( "Log" ), {Line Color( {208, 64, 86} )} )

);

Results in the equation Log(y axis) = -2,178489 - 0,3877925*Log(X axis),

which is equivalent to  y axis=0.1132 x axis^-0.388