XLSTAT - Plot a Function
View a tutorial
This tool allows you to plot a function of the type y = f (x) on an existing or new chart.
Plot functions from Microsoft Excel
The syntax of the function must respect the conventions imposed by Microsoft Excel for functions used in spreadsheets. In addition, the abscissa must be identified by X1.
Examples:
| Function | XLSTAT Syntax |
| Y=x² Y=ln(x) Y=e(x) Y=|x| Y=x if x<0, Y=2x otherwise |
X1^2 LN(X1) EXP(X1) ABS(X1) IF(X1<0,X1,2*X1) |
Plot XLSTAT functions
In addition, you can use as well XLSTAT worksheet functions. For example, to plot the normal cumulative distribution function, enter XLSTAT_CDFNormal (X1)
Copyright © 2011 Kovach Computing Services, Anglesey, Wales. All Rights Reserved. Portions copyright Addinsoft, Provalis Research, and Data Description Inc.
Last modified 25 November, 2011