a05558 发表于 2018-10-14 12:54:38

Minitab交叉方差分析的方差分量和标准差excel里怎么计算

本帖最后由 a05558 于 2018-10-15 21:42 编辑


excel里包含交互作用的双因子方差分析我会算,请教前辈指导后面方差分析量和标准差的算法



终于找到计算方法了
VarComp for ANOVA method Variance component contributed by each source.When Operator*Part interaction is included in the ANOVA model, the variance components are calculated as follows:
ComponentFormula
RepeatabilityMS Repeatability
Operator
MS Operator - MS Operator*Part
a*n
where a = number of parts and n = number of replicates
Operator*Part

MS Operator*Part - MS Repeatability
n
where n = number of replicates

Part-To-Part

MS Part - MS Operator*Part
b*n
where b = number of operators and n = number of replicates

Reproducibility
VarComp Operator + VarComp Operator*Part

Total Gage R&R
VarComp Repeatability + VarComp Reproducibility

Total Variation
VarComp Total Gage R&R + VarComp Part-to-Part


When Operator*Part interaction is not included in the ANOVA model, the variance components are calculated as follows:
ComponentFormula
RepeatabilityMS Repeatability
Operator
MS Operator - MS Repeatability
a*n
where a = number of parts and n = number of replicates
Part-To-Part

MS Part - MS Repeatability
b*n
where b = number of operators and n = number of replicates

Reproducibility
VarComp for Operator

Total Gage R&R
Sum of the VarComps for Repeatability and Reproducibility

Total Variation
Sum of the VarComps for Total Gage R&R and Part-to-Part


If a variance component is negative, then Gage R&R will report it as zero.


zhujun 发表于 2018-10-14 16:09:14

666

13387559107 发表于 2018-10-14 16:59:21

{:1_97:}

a05558 发表于 2018-10-14 17:06:28

:'(:'(:'(:'(:'(
用教材上的 均值-极差法方法 计算EVAV TV GRR,算的结果和minitab上对不上

kakalee 发表于 2018-10-14 21:13:12

:)

swxslzh 发表于 2018-10-15 08:19:03

:)

Tiger-1 发表于 2018-10-15 09:11:48

:Q:Q

叶太平 发表于 2018-10-15 09:16:00

谢谢分享。。。

billye 发表于 2018-10-15 09:20:28

谢谢分享。。。

willwang 发表于 2018-10-15 10:24:26

这是软件自动计算的。手工计算的话工作量大得很!
页: [1] 2
查看完整版本: Minitab交叉方差分析的方差分量和标准差excel里怎么计算