How to Calculate Standard Deviation Within Value Using Excel
Six Sigma – iSixSigma › Forums › General Forums › Tools & Templates › How to Calculate Standard Deviation Within Value Using Excel
- This topic has 2 replies, 3 voices, and was last updated 1 year, 1 month ago by
Daniel Alfano.
-
AuthorPosts
-
June 17, 2021 at 3:47 am #254463
kittinadhaziParticipant@kittinadhaziInclude @kittinadhazi in your post and this person will
be notified via email.Hi guys,
I write my thesis sixsigma, and I need some help.
I would like to calculate standard deviation WITHIN value in excel ( without any program e.g. SPC or sometthing like that), I have 60 datapoints and I havent got subgroups. I know I shouldn’t calculate within value, if I havent got subgroups, but ( my friend has got Minitab) and I put my values in there and minitab gave standard deviation within value. And it’s really important, because minitab uses this results for calculate CPK value.So my question is, how can I do it in Excel? what is the method of Minitab? I found an article in their page, but isnt help me. Really important, that I know how it works. ( because I will write my thesis)
I will be grateful, thank you so much :)
0June 17, 2021 at 10:32 am #254479
Robert ButlerParticipant@rbutlerInclude @rbutler in your post and this person will
be notified via email.My guess would be your friend did something wrong in Minitab. If you don’t have subgroups then there is no within to use for calculations. Is there any chance the standard deviation it did compute was either just the sample standard deviation of all 60 points or the standard deviation of the mean of the 60 data points?
0June 21, 2021 at 3:20 pm #254554
Daniel AlfanoParticipant@dalfanoInclude @dalfano in your post and this person will
be notified via email.I had the same question some years ago and found the answer in one Minitab post. Please look at the attached file with the Excel formulas to calculate the “with in” stdev, same as Minitab.
Attachments:
- capabilityhw-resuelto.xls
You must be signed in to download files.
1 - capabilityhw-resuelto.xls
-
AuthorPosts
You must be logged in to reply to this topic.