Share via

Does excel have a function for calculation of Cp/Cpk i.e. process capability indices?

Anonymous
2011-04-17T15:39:33+00:00

I have datas of one process characteristic-output Y.

I would like to calculate Cp and Cpk for that process output but also to generate chart to see distribution of values.

Is that possible in excel?

Thanks in advance,

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-06-23T14:24:22+00:00

    There's an error on the page for download of the free template.

    I downloaded trial commercial template and I'll try that.

    Thanks a lot.

    Hello Slobodan,

    there is a free excel template for the machine capability on http://www.sixsigmablackbelt.de/prozessfaehigkeit-und-maschinenfaehigkeit/ . Maybe this is the rigtht solution for you.

    Best wishes

    roland

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-04-18T07:09:16+00:00

    There's an error on the page for download of the free template.

    I downloaded trial commercial template and I'll try that.

    Thanks a lot.

    0 comments
  3. Anonymous
    2011-04-17T16:23:11+00:00

    I think we need a somewhat tighter question - this is very broad. best wishes

    0 comments