# When will Box-Cox Transformation be available

Six Sigma – iSixSigma Forums Old Forums General When will Box-Cox Transformation be available

Viewing 7 posts - 1 through 7 (of 7 total)
• Author
Posts
• #37402

ROSS
Member

Hi:
We can use Box-Cox Transformation in Minitab to transfer some nonnormal distribution date to normal distribution,  but it is not available in any case, can somebody tell me in what case it will avaliable and in what case it will unavailable?
Tks!

0
#110107

ROSS
Member

Hi:
Pls somebody who has experiments on it help me.
Tks!

0
#110112

John Noguera
Participant

Tony,
Your question is a bit unclear. If you are asking about the availability of columns for Box-Cox Transformation, Minitab hides any columns that have text, or cells with  negative or zero values.

0
#110131

Ray M.
Participant

Your data has to be positive to use Box-Cox, if that’s what you are asking.

0
#110162

ROSS
Member

John , Ray:
Yes, column with text or cells with  negative or zero values will be hided and can not do box-cox transformation. But also we may not successs even we meet the erquirements of Mnitab, do you know what kind of data(meet Minitab box-cox requierment) we can success?
Tks!

0
#110232

ROSS
Member

Ray:
Yes! The data should be positive, but even the positive data, we will fail at box-cox transformation, my question is waht kind of positive data can be available at box-cox, and what kind of can not?
Tks!

0
#110233

Nanni
Participant

Could you be more specific, please.

The box cox transformation need  “non-negative” data. If you have negative data or with zero’s, you have to add a unit until you have all the data non-negative.

And, Why the B-C transformation cannot use non-negative data? Because one of the transforamation uses the function “logarithm”, and you can easy proof in excel that —>
ln(0) or ln(any negative number) = #NUM!
It means that don’t exist.