>>13639495y = y = a*x + b
{=LINEST(rawDataY.B1:B22,rawDataX.A1:A22,1,1)}
linest( dataY, dataX, noForcingThruOrigo, showStatistics ) gives values for a and b
-
--
y = a*x^($D$3) + b
{=LINEST(rawDataY.B1:B22,rawDataX.A1:A22^$D$3,1,1)}
linest( dataY, dataX^D3, noForcingThruOrigo, showStatistics ) gives values for a and b
--
--
y = a*x^2 + b*x + c
{=LINEST(rawDataY.B1:B22,rawDataX.A1:A22^{1,2},1,1)}
linest( dataY, dataX^{1,2}, noForcingThruOrigo, showStatistics ) gives values for a, b and c
--
-
y = a*x^3 + b*x^2 + c*x + d
{=LINEST(rawDataY.B1:B22,rawDataX.A1:A22^{1,2,3},1,1)}
linest( dataY, dataX^{1,2,3}, noForcingThruOrigo, showStatistics ) gives values for a, b, c and d
-
y = a*ln(x) + b
{=LINEST(rawDataY.B1:B22,LN(rawDataX.A1:A22),1,1)}
linest( dataY, LN(dataX), noForcingThruOrigo, showStatistics ) gives values for a and b
y = b * x^a
{=LINEST(LN(rawDataY.B1:B22),LN(rawDataX.A1:A22),1,1)}
linest( LN(dataY), LN(dataX), noForcingThruOrigo, showStatistics ) gives values for a and ln(b)
--
--
y = b * a^x
{=LINEST(LN(rawDataY.B1:B22),rawDataX.A1:A22,1,1)}
linest( LN(dataY), dataX, noForcingThruOrigo, showStatistics ) gives values for ln(a) and ln(b)
--
-
y = b * e^(a*x)
{=LINEST(LN(rawDataY.B1:B22),rawDataX.A1:A22,1,1)}
linest( LN(dataY), dataX, noForcingThruOrigo, showStatistics ) gives values for a and ln(b)