iSixSigma

Box-Cox Transformation

Six Sigma – iSixSigma Forums Old Forums General Box-Cox Transformation

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #40119

    miranax
    Participant

    Hello all.  I transformed a set of data using the Minitab Box Cox function, and came up with a “best value” of 0.00.  I understand that this means applying the log to the set of values, but when I do that using Excel, I come up with different values from the Minitab output.
    More info from the Box-Cox printout:
    Estimate: 0.14
    Lower CL: -0.09
    Upper CL: 0.35
    Rounded value: 0.00
    Any feedback is welcome.

    0
    #123595

    Ray The real deal
    Participant

    Miranax,Why do you need to use it in Excel? To simplify, while in the Control Charts>Box Cox>select options>in the Store space>select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.Box Cox>select options>in the Store space>select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.Box Cox>select options>in the Store space>select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.select options>in the Store space>select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.select options>in the Store space>select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.in the Store space>select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.in the Store space>select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.select a new column and Voila! you have created a Tranformed data in a new column in the worksheet.Ray

    0
    #123597

    Ray The real deal
    Participant

    Oooopppssss…the bud light starts to kick in.Ray

    0
    #123598

    miranax
    Participant

    because I am using an XmR chart, and I would like to compare the data to spec limits.  Therefore, I need to transform the spec limits with the same Box-Cox transformation that minitab is using.

    0
    #123599

    Jaybee
    Participant

    I am glad someone is joining me…..
    but your answer was correct, several times over in fact!!
     
    enjoy the bud
    Jaybee

    0
    #123600

    Ray The real deal
    Participant

    Miranax,
    To simplify your life, I’m assumint your data is not normal: Goto Stat>Quality Tools>Capability Analysis>Normal>Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Quality Tools>Capability Analysis>Normal>Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Quality Tools>Capability Analysis>Normal>Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Capability Analysis>Normal>Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Capability Analysis>Normal>Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Normal>Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Normal>Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Select Box Cox and Check for Optimal Lambda>Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…Add the Lower spec and Upper Spec with the current spec (don’t worry about spec transformation, Minitab will do it for you!)select OK and life goes on…For the subgroup thing…you decide.Ray

    0
    #123601

    Ray The real deal
    Participant

    Now the Bud light is really kicking it in…I’d better finish my 1st can of the day ASAP!JayBee, you too.

    0
    #123602

    miranax
    Participant

    beautiful!  thanks!

    0
Viewing 8 posts - 1 through 8 (of 8 total)

The forum ‘General’ is closed to new topics and replies.