In [1]:
import numpy as np
import pandas as pd
In [2]:
import matplotlib.pyplot as plt
%matplotlib inline
import seaborn as sns
In [3]:
capa=pd.read_excel("F:/2019 GB Python/ProcessCapa.xlsx")
In [4]:
capa.head()
Out[4]:
Parameter USL LSL
0 44.974 45.0 44.5
1 45.066 NaN NaN
2 44.944 NaN NaN
3 45.088 NaN NaN
4 44.951 NaN NaN
In [6]:
sns.distplot(capa.Parameter,hist=False)
plt.axvline(x=45.4)
plt.axvline(x=44.7)
Out[6]:
<matplotlib.lines.Line2D at 0x14ab530>
In [7]:
sns.distplot(capa.Parameter,hist=False)
plt.axvline(x=45.4)
plt.axvline(x=44.7)
Out[7]:
<matplotlib.lines.Line2D at 0x14de410>

Sigma Scores in EXCEL

=NORM.S.INV(1-DPMO/1000000)+1.5

In [ ]: