cp-cpk-Sigma-Prozessfähigkeit, Genauigkeit,Wiederholung etc.



Hallo,

ich habe eine Achse, die ich positioniern will.

X-SOLL = 100mm
IST SOLL
1 9,99 10
2 9,55 10
3 10,1 10
4 9,99 10
5 10,045 10
6 10,1 10
7 10,155 10
8 10,21 10
9 10,265 10
10 10,32 10
11 10,375 10
12 10,43 10
13 10,485 10
14 10,54 10
15 10,595 10
16 10,65 10
17 10,705 10
18 10,76 10
19 10,815 10
20 10,87 10
21 10,925 10
22 10,98 10
23 10 10
24 10,08 10
25 10,2 10
26 10 10
27 9,9 10
28 9,5 10
29 9,2 10
30 9,7 10

Was ist jetzt der cP Wert?
Was ist jetzt der CPK Wert?
Was ist Sigma?

Glockenform,kann ich hier nicht zeichnen
|
|0,2 = 20%
|
|
|
|
|
|0,1 = 10%
|
|
--------------------------------------
0...1...2...3...4...5...6...7...8...9 Sigma

Wie komme ich jetzt auf meine Sigma?
Wie komme ich auf die Glockenform?
Wie lauten die theo. Formel?
Wie mache ich es in Excel?

Grüße Andrea



Excel Sheet als XML


<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40";>
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>AM</Author>
<LastAuthor>AM</LastAuthor>
<Created>2008-06-10T15:52:46Z</Created>
<Company>M</Company>
<Version>11.9999</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>12270</WindowHeight>
<WindowWidth>16395</WindowWidth>
<WindowTopX>600</WindowTopX>
<WindowTopY>45</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
</Styles>
<Worksheet ss:Name="Tabelle1">
<Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="35"
x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60">
<Row ss:Index="5">
<Cell ss:Index="3"><Data ss:Type="String">IST</Data></Cell>
<Cell><Data ss:Type="String">SOLL</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">1</Data></Cell>
<Cell><Data ss:Type="Number">9.99</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">2</Data></Cell>
<Cell><Data ss:Type="Number">9.55</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">3</Data></Cell>
<Cell><Data ss:Type="Number">10.1</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">4</Data></Cell>
<Cell><Data ss:Type="Number">9.99</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">5</Data></Cell>
<Cell><Data ss:Type="Number">10.045</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">6</Data></Cell>
<Cell><Data ss:Type="Number">10.1</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">7</Data></Cell>
<Cell><Data ss:Type="Number">10.154999999999999</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">8</Data></Cell>
<Cell><Data ss:Type="Number">10.21</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">9</Data></Cell>
<Cell><Data ss:Type="Number">10.265000000000001</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">10</Data></Cell>
<Cell><Data ss:Type="Number">10.32</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">11</Data></Cell>
<Cell><Data ss:Type="Number">10.375</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">12</Data></Cell>
<Cell><Data ss:Type="Number">10.43</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">13</Data></Cell>
<Cell><Data ss:Type="Number">10.484999999999999</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">14</Data></Cell>
<Cell><Data ss:Type="Number">10.54</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">15</Data></Cell>
<Cell><Data ss:Type="Number">10.595000000000001</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">16</Data></Cell>
<Cell><Data ss:Type="Number">10.65</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">17</Data></Cell>
<Cell><Data ss:Type="Number">10.705</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">18</Data></Cell>
<Cell><Data ss:Type="Number">10.76</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">19</Data></Cell>
<Cell><Data ss:Type="Number">10.815</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">20</Data></Cell>
<Cell><Data ss:Type="Number">10.87</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">21</Data></Cell>
<Cell><Data ss:Type="Number">10.925000000000001</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">22</Data></Cell>
<Cell><Data ss:Type="Number">10.98</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">23</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">24</Data></Cell>
<Cell><Data ss:Type="Number">10.08</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">25</Data></Cell>
<Cell><Data ss:Type="Number">10.2</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">26</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">27</Data></Cell>
<Cell><Data ss:Type="Number">9.9</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">28</Data></Cell>
<Cell><Data ss:Type="Number">9.5</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">29</Data></Cell>
<Cell><Data ss:Type="Number">9.2</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell ss:Index="2"><Data ss:Type="Number">30</Data></Cell>
<Cell><Data ss:Type="Number">9.7</Data></Cell>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.4921259845"/>
<Footer x:Margin="0.4921259845"/>
<PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/>
</PageSetup>
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>4</ActiveRow>
<ActiveCol>1</ActiveCol>
<RangeSelection>R5C2:R35C4</RangeSelection>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Tabelle2">
<Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0"
x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60"/>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.4921259845"/>
<Footer x:Margin="0.4921259845"/>
<PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/>
</PageSetup>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Tabelle3">
<Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0"
x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60"/>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.4921259845"/>
<Footer x:Margin="0.4921259845"/>
<PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/>
</PageSetup>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
.



Relevant Pages