Box-Cox Transformation
Six Sigma – iSixSigma › Forums › Old Forums › General › Box-Cox Transformation
- This topic has 7 replies, 3 voices, and was last updated 16 years, 11 months ago by
miranax.
-
AuthorPosts
-
July 25, 2005 at 4:25 pm #40119
miranaxParticipant@miranaxInclude @miranax in your post and this person will
be notified via email.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.0July 25, 2005 at 4:35 pm #123595
Ray The real dealParticipant@Ray---The-real-dealInclude @Ray---The-real-deal in your post and this person will
be notified via email.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
0July 25, 2005 at 4:41 pm #123597
Ray The real dealParticipant@Ray---The-real-dealInclude @Ray---The-real-deal in your post and this person will
be notified via email.Oooopppssss…the bud light starts to kick in.Ray
0July 25, 2005 at 4:43 pm #123598
miranaxParticipant@miranaxInclude @miranax in your post and this person will
be notified via email.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.
0July 25, 2005 at 4:43 pm #123599I am glad someone is joining me…..
but your answer was correct, several times over in fact!!
enjoy the bud
Jaybee0July 25, 2005 at 5:01 pm #123600
Ray The real dealParticipant@Ray---The-real-dealInclude @Ray---The-real-deal in your post and this person will
be notified via email.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.Ray0July 25, 2005 at 5:03 pm #123601
Ray The real dealParticipant@Ray---The-real-dealInclude @Ray---The-real-deal in your post and this person will
be notified via email.Now the Bud light is really kicking it in…I’d better finish my 1st can of the day ASAP!JayBee, you too.
0July 25, 2005 at 5:04 pm #123602
miranaxParticipant@miranaxInclude @miranax in your post and this person will
be notified via email.beautiful! thanks!
0 -
AuthorPosts
The forum ‘General’ is closed to new topics and replies.