SigmaPlot comes with a simple,
easytouse scripting language for manipulating data in an
active worksheet. The scripting language can allocate memory to
variables; perform looping, Boolean logic, and evaluate
functions to transform a worksheet.
Worksheet transforms can
be entered into either the Quick Transform dialog, or the
UserDefined Transform dialog. New users will find the Quick
Transform dialog to be a gradual introduction to single line
transforms.
Experienced and more demanding users will find the
UserDefined Transform dialog to be a powerful way to transform
worksheet data. As of SigmaPlot 10, userdefined transforms can
be stored as an item in a notebook along with the data.
The following list groups transforms by function type. It is
followed by an alphabetical reference containing complete
descriptions of all transform functions and their syntax, with
examples. [top]

Worksheet
Functions
These worksheet functions are used to specify cells and columns
from the worksheet, either to read data from the worksheet for
transformation, or to specify a destination for transform
results. 
Function 
Description 
block 
The block function returns a specified block of
cells from the worksheet. 
block height & width 
The blockheight and blockwidth functions return
a specified block of cells or block dimension from the
worksheet. 
cell 
The cell function returns a specific cell from
the worksheet. 
col 
The col function returns a worksheet column or
portion of a column. 
put into 
The put into function places variable or
equation results in a worksheet column. 
subblock 
The subblock function returns a specified block
of cells from within another block. 
makeblock 
The makeblock function converts a single column
to a block of cells of defined dimensions. 
[top]

Data Manipulation Function
The data manipulation functions are used to generate
nonrandom data, and to sample, select, and sort data. 
Function 
Description 
data 
The data function generates serial data.

if 
The if function conditionally selects between
two data sets. 
nth 
The nth function returns an incremental
sampling of data. 
sort 
The sort function rearranges data in ascending
order. 
[top]

Trigonometrics Function
SigmaPlot and SigmaStat provide a complete set of
trigonometric functions. 
Function 
Description 
arccos 
This function returns the arccosine of the
specified argument.

arcsin 
This function returns the arcsine of the
specified argument. 
arctan 
This function returns the arctangent of the
specified argument.

cos 
This function returns the cosine of the
specified argument.

sin 
This function returns the sine of the specified
argument.

tan 
This function returns the tangent of the
specified argument.

cosh 
This function returns the hyperbolic cosine of
the specified argument. 
sinh 
This function returns the hyperbolic sine of
the specified argument. 
tanh 
This function returns the hyperbolic tangent of
the specified argument. 
[top]

Numeric Functions
The numeric functions perform a specific type of calculation
on a number or range of numbers and returns the appropriate
results. 
Function 
Description 
abs 
The abs function returns the absolute value. 
exp 
The exp function returns the values for e
raised to the specified numbers. 
factorial 
The factorial function returns the factorial
for each specified number. 
mod 
The mod function returns the modulus, or
remainder of division, for specified numerators and divisors. 
In 
The ln function returns the natural logarithm
for the specified numbers. 
log 
The log function returns the base 10 logarithm
for the specified numbers. 
sqrt 
The sqrt function returns the square root for
the specified numbers. 
root 
The root function finds the roots of a function
over a finite interval. 
implicit 
The implicit function is used to solve an
equation which is defined implicitly. 
[top]

Range Functions
The following functions give information on ranges. 
Function 
Description 
count 
The count function returns the number of
numeric values in a range. 
missing 
The missing function returns the number of
missing values and text strings in a range. 
size 
The size function returns the number of data
points in a range, including all numbers, missing values, and
text strings. 
[top]

Accumulation Function
The accumulation functions return values equal to the
accumulated operation of the function. 
Function 
Description 
diff 
The diff function returns the differences of
the numbers in a range. 
sum 
The sum function returns the cumulative sum of
a range of numbers. 
total 
The total function returns the value of the
total sum of a range. 
[top]

Random Generation Function
The two “random” number generating functions can be used to
create a series of normally or uniformly distributed numbers. 
Function 
Description 
gaussian 
The Gaussian function is used to generate a
series of normally (Gaussian or “bell” shaped) distributed
numbers with a specified mean and standard deviation. 
random 
The random function is used to generate a
series of uniformly distributed numbers within a specified
range. 
[top]

Precision Functions
The precision functions are used to convert numbers to whole
numbers or to round off numbers. 
Function 
Description 
int 
The int function converts numbers to integers. 
prec 
The prec function rounds numbers off to a
specified number of significant digits. 
round 
The round function rounds numbers off to a
specified number of decimal places. 
[top]

Statistical Functions
The statistical functions perform statistical calculations on
a range or ranges of numbers. 
Function 
Description 
avg 
The avg function calculates the averages of
corresponding numbers across ranges. It can be used to calculate
the average across rows for worksheet columns. 
max 
The max function returns the largest value in a
range. 
min 
The min function returns the smallest value in
a range. 
mean 
The mean function calculates the mean of a
range. 
runavg 
The runavg function produces a range of running
averages. 
stddev 
The stddev function returns the standard
deviation of a range. stderr The stderr function calculates the
standard error of a range. 
avg 
The avg function calculates the averages of
corresponding numbers across ranges. It can be used to calculate
the average across rows for worksheet columns. 
max 
The max function returns the largest value in a
range. 
min 
The min function returns the smallest value in
a range. 
median 
The median function calculates the median of a
range. 
[top]

Area and Distance Function
These functions can be used to calculate the areas and
distances specified by X,Y coordinates. Units are based on the
units used for X and Y. 
Function 
Description 
area 
The area function finds the area of a polygon
described in X,Y coordinates. 
distance 
The distance function calculates the distance
of a line whose segments are described in X,Y coordinates.

partdist 
The partdist function calculates the distances
from an initial X,Y coordinate to successive X,Y coordinates in
a cumulative fashion. 
[top]

Curve Fitting Function
These functions are designed to be used in conjunction with
SigmaPlot’s nonlinear curve fitter, to allow automatic
determination of initial equation parameter estimates from the
source data. You can use these functions to develop your own
parameter determination function by using the functions provided
with the Standard Regression Equations library provided with
SigmaPlot. 
Function 
Description 
ape 
This function is used for the polynomials,
rational polynomials and other functions which can be expressed
as linear functions of the parameters. A linear least squares
estimation procedure is used to obtain the parameter estimates. 
dsinp 
This function returns an estimate of the phase
in radians of damped sine functions. 
fwhm 
This function returns the x width of a peak at
half the peak’s maximum value for peak shaped functions. 
inv 
The inv function generates the inverse matrix
of an invertible square matrix provided as a block. 
lowess 
The lowess algorithm is used to smooth noisy
data. “Lowess” means locally weighted regression. Each point
along the smooth curve is obtained from a regression of data
points close to the curve point with the closest points more
heavily weighted. 
lowpass 
The lowpass function returns smoothed y values
from ranges of x and y variables, using an optional userdefined
smoothing factor that uses FFT and IFFT. 
sinp 
This function returns an estimate of the phase
in radians of sinusoidal functions. 
x25 
This function returns the x value for the y
value 25% of the distance from the minimum to the maximum of
smoothed data for sigmoidal shaped functions. 
x50 
This function returns the x value for the y
value 50% of the distance from the minimum to the maximum of
smoothed data for sigmoidal shaped functions. 
x75 
This function returns the x value for the y
value 75% of the distance from the minimum to the maximum of
smoothed data for sigmoidal shaped functions. 
xatxmax 
This function returns the x value for the
maximum y in the range of y coordinates for peak shaped
functions. 
xwtr 
This function returns x75x25 for sigmoidal
shaped functions. 
[top]

Miscellaneous Functions
These functions are specialized functions which perform a
variety of operations. 
Function 
Description 
choose 
The choose function is the mathematical “n
choose r” function. 
histogram 
The histogram function generates a histogram
from a range or column of data. 
interpolate 
The interpolate function performs linear
interpolation between X,Y coordinates. 
polynomial 
The polynomial function returns results for
specified independent variables for a specified polynomial
equation. 
rgbcolor 
The rgbcolor(r,g,b) color function takes
arguments r,g, and b between 0 and 255 and returns color to
cells in the worksheet. 
lookup 
The lookup function returns results from a
table given input values  an index from a 1D table or a value
from a 2D table. 
[top] 
Special Constructs
Transform constructs are special structures that allow more
complex procedures than functions. 
Function 
Description 
for 
The for statement is a looping construct used
for iterative processing. 
if... then... else 
The if...then...else construct proceeds along
one of two possible series of procedures based on the results of
a specified condition. 
[top]

Fast Fourier Transform Functions
These functions are used to remove noise from and smooth data
using frequencybased filtering. 
Function 
Description 
fft 
The fft function finds the frequency domain
representation of your data. 
invfft 
The invfft function takes the inverse fft of
the data produced by the fft to restore the data to its new
filtered form. 
real 
The real function strips the real numbers out
of a range of complex numbers. 
img 
The img function strips the imaginary numbers
out of a range of complex numbers. 
complex 
The complex function converts a block of real
and/or imaginary numbers into a range of complex numbers. 
mulcpx 
The mulcpx function multiplies two ranges of
complex numbers together. 
invcpx 
The invcpx takes the reciprocal of a range of
complex numbers. 
[top]

Probability Functions 
Use these functions to compute and verify
statistical measures such as significant probabilities, critical
values of statistics, confidence intervals and histogram
comparisons. 
Function 
Description 
normdist 
The cumulative normal (or Gaussian) distribution function.
It returns the probability that a normal random variable is less
than a specified independent variable value. 
norminv 
The inverse cumulative normal (or Gaussian) distribution
function. The probability that a normally distributed random
variable is less than the return value is equal to the argument
you specify. 
normden 
The normal (or Gaussian) probability density function. The
graph of this function is the familiar “bell curve”. It returns
the value of the slope of the cumulative distribution function
at the specified argument value. 
chisquaredist 
The cumulative chisquare distribution function. It returns
the probability that a chisquare distributed random variable is
less than a specified independent variable value. 
chisquareinv 
The inverse cumulative chisquare distribution function. The
probability that a chisquare distributed random variable is
less than the return value is equal to the argument you specify. 
chisquareden 
The chisquare probability density function. It returns the
value of the slope of the cumulative distribution function at
the specified argument value. 
fdist 
The Fdistribution function. It returns the probability that
an F distributed random variable is less than a specified
independent variable value. 
finv 
The inverse Fdistribution function. The probability that an
Fdistributed random variable is less than the return value is
equal to the argument you specify. 
fden 
The Fdistribution’s probability density function. It
returns the value of the slope of the cumulative distribution
function at the specified argument value. 
tdist 
The Student’s Tdistribution function. It returns the
probability that a Tdistributed random variable is less than a
specified independent variable value. 
tinv 
The inverse of Student’s Tdistribution function. The
probability that a Tdistributed random variable is less than
the return value is equal to the argument you specify. 
tden 
The Tdistribution’s probability density function. It
returns the value of the slope of the cumulative distribution
function at the specified argument value. 
gammadist 
The cumulative gamma distribution function. It returns the
probability that a gamma distributed random variable is less
than a specified independent variable value. 
gammainv 
The inverse cumulative gamma distribution function. The
probability that a gamma distributed random variable is less
than the return value is equal to the argument you specify. 
gammaden 
The gamma distribution’s probability density function. It
returns the value of the slope of the cumulative distribution
function at the specified argument value. 
weibulldist 
The cumulative Weibull distribution function. It returns the
probability that a Weibull distributed random variable is less
than a specified independent variable value. 
weibullinv 
The inverse cumulative Weibull distribution function. The
probability that a Weibull distributed random variable is less
than the return value is equal to the argument you specify. 
weibullden 
The Weibull distribution’s probability density function. It
returns the value of the slope of the cumulative distribution
function at the specified argument value. 
cauchydist 
The cumulative Cauchy distribution function. It returns the
probability that a Cauchy distributed random variable is less
than a specified independent variable value. 
cauchyinv 
The inverse cumulative Cauchy distribution function. The
probability that a Cauchy distributed random variable is less
than the return value is equal to the argument you specify. 
cauchyden 
The Cauchy distribution’s probability density function. It
returns the value of the slope of the cumulative distribution
function at the specified argument value. 
erf 
The error function. It is related to the cumulative normal
distribution function by scaling and translation. 
erfc 
The complementary error function. It returns one minus the
return value of the error function. 
lognormaldist 
The cumulative lognormal distribution function. It returns
the probability that a lognormal random variable is less than a
specified independent variable value. 
lognormalinv 
The inverse cumulative lognormal distribution function. The
probability that a lognormal random variable is less than the
return value is equal to the argument you specify. 
lognormalden 
The lognormal distribution’s probability density function.
It returns the value of the slope of the cumulative distribution
function at the specified argument value. 
expdist 
The cumulative exponential distribution function. It returns
the probability that an exponential random variable is less than
a specified independent variable value. 
expinv 
The inverse cumulative exponential distribution function.
The probability that an exponential random variable is less than
the return value is equal to the argument you specify. 
expden 
The exponential distribution’s probability density function.
It returns the value of the slope of the cumulative distribution
function at the specified argument value. 
logisdist 
The cumulative logistic distribution function. It returns
the probability that a logistic random variable is less than a
specified independent variable value. 
logisinv 
The inverse cumulative logistic distribution function. The
probability that a logistic random variable is less than the
return value is equal to the argument you specify. 
logisden 
The logistic distribution’s probability density function. It
returns the value of the slope of the cumulative distribution
function at the specified argument value. 
loglogisdist 
The cumulative loglogistic distribution function. It
returns the probability that a loglogistic random variable is
less than a specified independent variable value. 
loglogisinv 
The inverse cumulative loglogistic distribution function.
The probability that a loglogistic random variable is less than
the return value is equal to the argument you specify. 
loglogisden 
The loglogistic distribution’s probability density
function. It returns the value of the slope of the cumulative
distribution function at the specified argument value. 
[top] 