Box-Cox Transformation

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

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