EXAMPLE - RANDBETWEEN and PI Functions

This example illustrates how you can apply the following functions to generate new and random data in your dataset:

Source:

In the following example, a company produces 10 circular parts, the size of which is measured in each product's radius in inches.

Based on the above data, the company wants to generate some additional sizing information for these circular parts, including the generation of two points along each part's circumference where quality stress tests can be applied.

Transformation:

To begin, you can use the following steps to generate the area and circumference for each product, rounded to three decimal points:

Single row formula

ROUND(PI() * (POW(radius_in, 2)), 3)

'area_sqin'

Single row formula

ROUND(PI() * (2 * radius_in), 3)

'circumference_in'

For quality purposes, the company needs two tests points along the circumference, which are generated by calculating two separate random locations along the circumference. Since the RANDBETWEEN function only calculates using Integer values, you must first truncate the values from circumference_in:

Single row formula

TRUNC(circumference_in)

'trunc_circumference_in'

Then, you can calculate the random points using the following:

Single row formula

RANDBETWEEN(0, trunc_circumference_in)

'testPt01_in'

Single row formula

RANDBETWEEN(0, trunc_circumference_in)

'testPt02_in'

Results:

After the trunc_circumference_in column is dropped, the data should look similar to the following: