English
GermanFunctions and Formulas
Quality
Quality
dpmo
returns the defects per million opportunities (DPMO) for the given specification limits and distribution or the given number of trials and number of failures. The 7parameters are USL, LSL, trials, failures, distribution (0=normal), and up to 3 parameters describing the distribution.
Collection dpmo(Collection LSL, Collection USL, Collection trials, Collection failures, Collection dist, Collection param1, Collection param2, Collection param3)
Parameters
| LSL : | is the lower specification limit. |
| USL : | is the upper specification limit |
| trials : | is the number of trials. May be empty if a distribution is provided. |
| failures : | is the number of failures. May be empty if a distribution is provided. Must be >4 if no distribution is provided. |
| dist : | Describes the distribution. May be empty if no distribution is provided. Normal distribution = 1. |
| param1 : | is the 1st parameter of the distribution (mean or shape) |
| param2 : | is the 2nd parameter of the distribution (standard deviation or scale) |
| param3 : | is the 3rd parameter of the distribution, if defined. |
isPoeFactor
Checks if a specific factor is used in the transfer function of a ctq.
Collection isPoeFactor(Collection ctqmean, Collection factors, Object selected=nothing, Object factor=nothing)
Parameters
| ctqmean : | A vector containing the mean values of CTQs |
| factors : | A vector containing the factors used in the transfer functions of the mean values. |
| selected : | Optional: a specific CTQ |
| factor : | Optional: a specific factor |
poe
Calculates the propagation of errors (POE) for given mean values resulting from transfer functions.
Collection poe(Collection ctqmean, Collection facmean, Collection facstdd)
Parameters
| ctqmean : | The mean values as results of transfer functions |
| facmean : | The factors used to calculate the mean values for the CTQs |
| facstdd : | The standard deviation of the factors |
poeSensitivity
Calculates the sensitivity of a propagation of errors (POE) for given mean values resulting from transfer functions.
Collection poeSensitivity(Collection ctqmean, Collection poe, Collection facmean, Collection facstdd)
Parameters
| ctqmean : | The mean values as results of transfer functions |
| poe : | The result of a POE calculation |
| facmean : | The factors used to calculate the mean values for the CTQs |
| facstdd : | The standard deviation of the factors |
ppk
Returns the long term process performance of normally distributed data described by mean, standard deviation, USL and LSL. Underlying data is characterized by 5th parameter as short term or long term.
Collection ppk(Collection mean, Collection stddev, Collection LSL, Collection USL, Collection st-lt, Collection st/lt, Collection st/lt=nothing, Collection st/lt=nothing, Collection st/lt=nothing, Collection st/lt=nothing, Collection st/lt=nothing, Collection st/lt=nothing)
Parameters
| mean : | is the mean of the normally distributed data. |
| stddev : | is the standard deviation of the normally distributed data. |
| LSL : | is the lower specification limit. |
| USL : | is the upper specification limit |
| st-lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
processSigma
Returns the short term Process Sigma for a given long term DPMO. Applies a Sigma shift of 1.5.
Collection processSigma(Collection DPMO, Collection SHIFT=nothing, Collection ZLSL=nothing, Collection ZUSL=nothing)
Parameters
| DPMO : | are the defects per million opportunities (DPMO). |
| SHIFT : | Is the optional sigma shift. Default is 1.5 |
| ZLSL : | is the z value for the lower specification limit |
| ZUSL : | is the z value for the upper specification limit |
rty
fills a vector by multiplying an input value by the value in the previous row of the vector. (f(i)=f(i-1)*x)
Collection rty(Object value, Object start, Object sort=nothing, boolean asc=false)
Parameters
| value : | is the scalar or vector with the input values |
| start : | is the initial value |
| sort : | defines a sort order |
| asc : | true: sort ascending, false: sort descending |
sdTarget
Calculates the target standard deviation
Collection sdTarget(Collection Target, Collection LSL, Collection USL, Collection ProcessSigma)
Parameters
| Target : | is the target value |
| LSL : | is the lower specification limit |
| USL : | is the upper specification limit |
| ProcessSigma : | is the target process sigma value |
sigmaGap
returns the delta between the targeted Process Sigma and the measured or estmated Process Sigma considering the predicition maturity level.
Collection sigmaGap(Collection ProcessSigma, Collection SigmaRisk, Collection TargetSigma)
Parameters
| ProcessSigma : | is the Process Sigma measured or estimated |
| SigmaRisk : | is the required safety margin on Process Sigma associated with the prediction maturity level. |
| TargetSigma : | is the Process Sigma target. |
transferFunction
Marks a column to be calculated by transfer functions that refer to a given vector of factors.
Collection transferFunction(Collection factors)
Parameters
| factors : | A vector of factors. |
zsl
Returns the Z value for a specification limit (upper or lower). The functions expects normally distributed data described by mean and standard deviation. The four arguments are: spec limit, mean, stddev, short/long term.
Collection zsl(Collection mean, Collection stddev, Collection limit, Collection st-lt, Collection st/lt, Collection st/lt, Collection st/lt, Collection st/lt, Collection st/lt, Collection st/lt, Collection st/lt)
Parameters
| mean : | is the mean of the normally distributed data. |
| stddev : | is the standard deviation of the normally distributed data. |
| limit : | is the specification limit the Z value is to be determined for (select the upper spec limit to determine Z-USL or lower spec limit for Z-LSL). |
| st-lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |
| st/lt : | indicates whether the data is long term (1.0) or short term (1.3). The value is the factor for the relationship of short term and long term standard deviation: s_lt = 1.3 * s_st. |