SigmaPlot Data Transforms
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 Version 10, the userdefined transforms can be stored as an item in a notebook along with the data.
[toggle border=’2′ title=’Transforms by Function Type’]
Worksheet Functions
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. 
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. 
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. 
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. 
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. 
Accumulation Functions 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. 
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. 
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. 
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. 
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. 
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. 
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. 
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. 
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. 
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. 