Plot a function

A quick and easy way to plot y = f(x) functions in Excel available with the XLSTAT add-on statistical software.

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:

FunctionSyntax in XLSTAT

Y=x²

X1^2

Y=ln(x)

LN(X1)

Y=e(x)

EXP(X1)

Y=|x|

ABS(X1)

Y=x if x < 0, Y=2x if not

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).