Frequently Used Funcitons in NExS


Please send feedback to: bill_switzer@ncsu.edu

There is a help menu on the upper right of the menu bar. One of the topics is "Functions (alphabetical)" which gives all of the functions available. Some of the more useful one include:

@ABS(X)

Returns the absolute value of X.

X - a numeric value

@AVG(...)

Returns the average (mean) of its arguments.

argumentlist - any combination of numbers, cells or ranges

@COS(X)

Returns the cosine of X.

X - a numeric value

@COUNT(...)

Returns a count of its non-blank arguments.

argumentlist - any combination of numbers, cells or ranges

@EXP(X)

Returns e raised to the X power.

X - a numeric value representing exponentiation.

@INT(X)

Returns the integer portion of X.

X - a numeric value

@LINFIT(X,Y)

Returns the straight line least squares fit.

X - a column vector of values for the independent variable.

Y - a column vector of values for the dependent variable.

This function is equivalent to @POLYFIT(X,Y,1).

@LLS(A,Y)

The linear least squares solution X to the overdetermined

system of equations AX=Y.

A - a range representing the coefficient matrix

Y - a column vector of values for the dependent variable

@LN(X)

Returns the log base e of X.

@LOG(X)

Returns the log of X.

X - a numeric value greater than 0

@LOG10(X)

Returns the log base 10 of X.

X - a numeric value greater than 0

@MAX(...)

Returns the maximum of its arguments.

argumentlist - any combination of numbers, cells, or ranges.

@MIN(...)

Returns the minimum of its arguments.

argumentlist - any combination of numbers, cells, or ranges.

@ROUND(X,N)

Returns the number X rounded to the number of decimal

places specified by the integer N, for N between 15

and -15, inclusive.

@ROUND(@PI,2) = 3.14

@ROUND(1234.5678,-2) = 1200

@SQRT(X)

Returns the positive square root of X.

X - a positive numeric value

@SIN(X)

Returns the sine of X.

X - a numeric value

@STDS(...)

Returns the population standard deviation (N-1 weighting) of

its arguments.

argumentlist - any combination of numbers, cells, or ranges

@SUM(...)

Returns the sum of its arguments.

argumentlist - any combination of numbers, cells, or ranges

@TAN(X)

Returns the tangent of X.

X - a numeric value

@TODAY

Returns the date value corresponding to the current

system date.