This example illustrates how you can apply statistical functions to your dataset. Calculations include average (mean), max, min, standard deviation, and variance.

Source:

Students took a test and recorded the following scores. You want to perform some statistical analysis on them:

Transformation:

You can use the following transformations to calculate the average (mean), minimum, and maximum scores:

To apply statistical functions to your data, you can use the VAR and STDEV functions, which can be used as the basis for other statistical calculations.

For each score, you can now calculate the variation of each one from the average, using the following:

Now, you want to apply grades based on a formula:

You can build the following transformation using the IF function to calculate grades.

For more information, see IF Function.

To clean up the content, you might want to apply some formatting to the score columns. The following reformats the stdev_Score and stDevs columns to display two decimal places:

Results: