Ø @DFT(R) -
The Discrete Fourier Transform of the range R.
Ø @EIGEN(M) -
The eigenvalues of the matrix M.
Ø @FFT(R) -
The Discrete Fourier Transform of the range R using a fast Fourier Transform algorithm.
Ø @FREQUENCY(R, B) -
Returns a frequency distribution for values R with a set of intervals B.
Ø @INVDFT(R) -
The inverse of the Discrete Fourier Transform of the range R.
Ø @INVERT(M) -
The inverse of matrix M.
Ø @INVFFT(R) -
The inverse of the Discrete Fourier Transform of the range R using a fast Fourier Transform algorithm.
Ø @LINFIT(X, Y) -
The straight line least squares fit. This function is equivalent to @POLYFIT(X, Y, 1).
Ø @LLS(A, Y) -
The linear least squares solution X to the over-determined system of equations AX=Y.
Ø @MMUL(M1, M2) -
The product of multiplying matrix M2 by matrix M1.
Ø @PLS(X, Y, d) -
Analyzes the least squares polynomial model Y=P(X), where P is a polynomial of degree d.
Ø @POLYCOEF(X, Y, d) -
The least squares coefficients for the polynomial fit Y=P(X), where P is a polynomial of degree d.
Ø @TRANSPOSE(M) -
The transpose of matrix M.
Ø @TREND(NX, KX, KY) -
The y values for new x values given existing x and y values.
Note
Embedded tools should not be contained within other functions or arithmetic operations in a single formula. You may, however, copy, move and format embedded tools just as any other function.