USA/Canada - Online Store | Others - Click Here

SigmaPlot Data Transforms

SigmaPlot comes with a simple, easy-to-use 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 User-Defined 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 User-Defined Transform dialog to be a powerful way to transform worksheet data. As of SigmaPlot Version 10, the user-defined transforms can be stored as an item in a notebook along with the data.

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.

FunctionDescription
blockThe block function returns a specified block of cells from the worksheet.
block height & widthThe blockheight and blockwidth functions return a specified block of cells or block dimension from the worksheet.
cellThe cell function returns a specific cell from the worksheet.
colThe col function returns a worksheet column or portion of a column.
put intoThe put into function places variable or equation results in a worksheet column.
subblockThe subblock function returns a specified block of cells from within another block.
makeblockThe makeblock function converts a single column to a block of cells of defined dimensions.
Data Manipulation Function

Data Manipulation Function

The data manipulation functions are used to generate non-random data, and to sample, select, and sort data.

FunctionDescription
dataThe data function generates serial data.
ifThe if function conditionally selects between two data sets.
nthThe nth function returns an incremental sampling of data.
sortThe sort function rearranges data in ascending order.

Trigonometrics Function

SigmaPlot and SigmaStat provide a complete set of trigonometric functions.

FunctionDescription
arccosThis function returns the arccosine of the specified argument.
arcsinThis function returns the arcsine of the specified argument.
arctanThis function returns the arctangent of the specified argument.
cosThis function returns the cosine of the specified argument.
sinThis function returns the sine of the specified argument.
tanThis function returns the tangent of the specified argument.
coshThis function returns the hyperbolic cosine of the specified argument.
sinhThis function returns the hyperbolic sine of the specified argument.
tanhThis function returns the hyperbolic tangent of the specified argument.
Numeric Functions

Numeric Functions

The numeric functions perform a specific type of calculation on a number or range of numbers and returns the appropriate results.

FunctionDescription
absThe abs function returns the absolute value.
expThe exp function returns the values for e raised to the specified numbers.
factorialThe factorial function returns the factorial for each specified number.
modThe mod function returns the modulus, or remainder of division, for specified numerators and divisors.
InThe ln function returns the natural logarithm for the specified numbers.
logThe log function returns the base 10 logarithm for the specified numbers.
sqrtThe sqrt function returns the square root for the specified numbers.
rootThe root function finds the roots of a function over a finite interval.
implicitThe implicit function is used to solve an equation which is defined implicitly.
Range Functions

Range Functions

The following functions give information on ranges.

FunctionDescription
countThe count function returns the number of numeric values in a range.
missingThe missing function returns the number of missing values and text strings in a range.
sizeThe size function returns the number of data points in a range, including all numbers, missing values, and text strings.
Accumulation Functions

Accumulation Functions

The accumulation functions return values equal to the accumulated operation of the function.

FunctionDescription
diffThe diff function returns the differences of the numbers in a range.
sumThe sum function returns the cumulative sum of a range of numbers.
totalThe total function returns the value of the total sum of a range.
Random Generation Function

Random Generation Function

The two “random” number generating functions can be used to create a series of normally or uniformly distributed numbers.

FunctionDescription
gaussianThe Gaussian function is used to generate a series of normally (Gaussian or “bell” shaped) distributed numbers with a specified mean and standard deviation.
randomThe random function is used to generate a series of uniformly distributed numbers within a specified range.
Precision Functions

Precision Functions

The precision functions are used to convert numbers to whole numbers or to round off numbers.

FunctionDescription
intThe int function converts numbers to integers.
precThe prec function rounds numbers off to a specified number of significant digits.
roundThe round function rounds numbers off to a specified number of decimal places.
Statistical Functions

Statistical Functions

The statistical functions perform statistical calculations on a range or ranges of numbers.

FunctionDescription
avgThe avg function calculates the averages of corresponding numbers across ranges. It can be used to calculate the average across rows for worksheet columns.
maxThe max function returns the largest value in a range.
minThe min function returns the smallest value in a range.
meanThe mean function calculates the mean of a range.
runavgThe runavg function produces a range of running averages.
stddevThe stddev function returns the standard deviation of a range. stderr The stderr function calculates the standard error of a range.
avgThe avg function calculates the averages of corresponding numbers across ranges. It can be used to calculate the average across rows for worksheet columns.
maxThe max function returns the largest value in a range.
minThe min function returns the smallest value in a range.
medianThe median function calculates the median of a range.
Area and Distance Function

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.

FunctionDescription
areaThe area function finds the area of a polygon described in X,Y coordinates.
distanceThe distance function calculates the distance of a line whose segments are described in X,Y coordinates.
partdistThe partdist function calculates the distances from an initial X,Y coordinate to successive X,Y coordinates in a cumulative fashion.
Curve Fitting Function

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.

FunctionDescription
apeThis 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.
dsinpThis function returns an estimate of the phase in radians of damped sine functions.
fwhmThis function returns the x width of a peak at half the peak’s maximum value for peak shaped functions.
invThe inv function generates the inverse matrix of an invertible square matrix provided as a block.
lowessThe 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.
lowpassThe lowpass function returns smoothed y values from ranges of x and y variables, using an optional user-defined smoothing factor that uses FFT and IFFT.
sinpThis function returns an estimate of the phase in radians of sinusoidal functions.
x25This 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.
x50This 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.
x75This 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.
xatxmaxThis function returns the x value for the maximum y in the range of y coordinates for peak shaped functions.
xwtrThis function returns x75-x25 for sigmoidal shaped functions.
Miscellaneous Functions

Miscellaneous Functions

These functions are specialized functions which perform a variety of operations.

FunctionDescription
chooseThe choose function is the mathematical “n choose r” function.
histogramThe histogram function generates a histogram from a range or column of data.
interpolateThe interpolate function performs linear interpolation between X,Y coordinates.
polynomialThe polynomial function returns results for specified independent variables for a specified polynomial equation.
rgbcolorThe rgbcolor(r,g,b) color function takes arguments r,g, and b between 0 and 255 and returns color to cells in the worksheet.
lookupThe 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

Special Constructs

Transform constructs are special structures that allow more complex procedures than functions.

FunctionDescription
forThe for statement is a looping construct used for iterative processing.
if... then... elseThe 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

Fast Fourier Transform Functions

These functions are used to remove noise from and smooth data using frequency-based filtering.

FunctionDescription
fftThe fft function finds the frequency domain representation of your data.
invfftThe invfft function takes the inverse fft of the data produced by the fft to restore the data to its new filtered form.
realThe real function strips the real numbers out of a range of complex numbers.
imgThe img function strips the imaginary numbers out of a range of complex numbers.
complexThe complex function converts a block of real and/or imaginary numbers into a range of complex numbers.
mulcpxThe mulcpx function multiplies two ranges of complex numbers together.
invcpxThe invcpx takes the reciprocal of a range of complex numbers.
Probability Functions

Probability Functions

Use these functions to compute and verify statistical measures such as significant probabilities, critical values of statistics, confidence intervals and histogram comparisons.
FunctionDescription
normdistThe cumulative normal (or Gaussian) distribution function. It returns the probability that a normal random variable is less than a specified independent variable value.
norminvThe 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.
normdenThe 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.
chisquaredistThe cumulative chi-square distribution function. It returns the probability that a chi-square distributed random variable is less than a specified independent variable value.
chisquareinvThe inverse cumulative chi-square distribution function. The probability that a chi-square distributed random variable is less than the return value is equal to the argument you specify.
chisquaredenThe chi-square probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
fdistThe F-distribution function. It returns the probability that an F distributed random variable is less than a specified independent variable value.
finvThe inverse F-distribution function. The probability that an F-distributed random variable is less than the return value is equal to the argument you specify.
fdenThe F-distribution?s probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
tdistThe Student?s T-distribution function. It returns the probability that a T-distributed random variable is less than a specified independent variable value.
tinvThe inverse of Student?s T-distribution function. The probability that a T-distributed random variable is less than the return value is equal to the argument you specify.
tdenThe T-distribution?s probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
gammadistThe cumulative gamma distribution function. It returns the probability that a gamma distributed random variable is less than a specified independent variable value.
gammainvThe 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.
gammadenThe gamma distribution?s probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
weibulldistThe cumulative Weibull distribution function. It returns the probability that a Weibull distributed random variable is less than a specified independent variable value.
weibullinvThe 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.
weibulldenThe Weibull distribution?s probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
cauchydistThe cumulative Cauchy distribution function. It returns the probability that a Cauchy distributed random variable is less than a specified independent variable value.
cauchyinvThe 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.
cauchydenThe Cauchy distribution?s probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
erfThe error function. It is related to the cumulative normal distribution function by scaling and translation.
erfcThe complementary error function. It returns one minus the return value of the error function.
lognormaldistThe cumulative log-normal distribution function. It returns the probability that a log-normal random variable is less than a specified independent variable value.
lognormalinvThe inverse cumulative log-normal distribution function. The probability that a log-normal random variable is less than the return value is equal to the argument you specify.
lognormaldenThe log-normal distribution's probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
expdistThe cumulative exponential distribution function. It returns the probability that an exponential random variable is less than a specified independent variable value.
expinvThe 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.
expdenThe exponential distribution?s probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
logisdistThe cumulative logistic distribution function. It returns the probability that a logistic random variable is less than a specified independent variable value.
logisinvThe 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.
logisdenThe logistic distribution?s probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.
loglogisdistThe cumulative log-logistic distribution function. It returns the probability that a log-logistic random variable is less than a specified independent variable value.
loglogisinvThe inverse cumulative log-logistic distribution function. The probability that a log-logistic random variable is less than the return value is equal to the argument you specify.
loglogisdenThe log-logistic distribution's probability density function. It returns the value of the slope of the cumulative distribution function at the specified argument value.


SigmaPlot Resources
 
»
»
»
Copyright © 2014 Systat Software Inc. - All Rights Reserved.e-mail: webmaster1@cranessoftware.com
Home | Products | Terms of Use | Privacy Policy | Email OptOut | Sitemap