iSixSigma

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
    Posts
  • June 17, 2021 at 3:47 am #254463

    kittinadhazi
    Participant

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

    0
    June 17, 2021 at 10:32 am #254479

    Robert Butler
    ★ 20 Years ★
    Participant

    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?

    0
    June 21, 2021 at 3:20 pm #254554

    Daniel Alfano
    Participant

    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:
    1. capabilityhw-resuelto.xls
      You must be signed in to download files.
    1
  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.