Here is how to use Box-Cox transform on Exploratory.

For this, I found this answer on stackoverflow useful. Here I’m basically reproducing this on Exploratory.

Here is how the data we want to apply Box-Cox transform look like.

On Table View:

On Summary View:

Here is the script I borrowed from the stackoverflow answer. Define this function in a Script.

```
powerTransform <- function(y, lambda1, lambda2 = NULL, method = "boxcox") {
boxcoxTrans <- function(x, lam1, lam2 = NULL) {
# if we set lambda2 to zero, it becomes the one parameter transformation
lam2 <- ifelse(is.null(lam2), 0, lam2)
if (lam1 == 0L) {
log(y + lam2)
} else {
(((y + lam2)^lam1) - 1) / lam1
}
}
switch(method
, boxcox = boxcoxTrans(y, lambda1, lambda2)
, tukey = y^lambda1
)
}
```

Here is detail on how to create a Script.

I’m skipping on how to figure out the right value on lambda, but for this data, it’s 0.4242424.

In this case, we can add a mutate step that looks like this to apply Box-Cox transformation on y.

y_transformed column is added.

Here is how it looks on Summary View, where we can see it is distributed more normally.