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

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #254463


    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 :)


    Robert Butler

    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?


    Daniel Alfano

    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.

    1. capabilityhw-resuelto.xls
      You must be signed in to download files.
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.