Diff for "FAQ/mse" - CBU statistics Wiki
location: Diff for "FAQ/mse"
Differences between revisions 4 and 14 (spanning 10 versions)
Revision 4 as of 2011-03-21 12:25:10
Size: 885
Editor: PeterWatson
Comment:
Revision 14 as of 2018-03-12 11:11:06
Size: 1320
Editor: PeterWatson
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
= How do I compute Mean Square Error (MSE)? = = How do I compute Mean Square Error (MSE) in EXCEL or SPSS? =
Line 3: Line 3:
Mean square error or MSE is frequently requested by journals as a companion statistic for ANOVA and, especially, t-tests. It is the average intra-group variance. MSE is outputted in ANOVA tables but can be computed using a weighted average of the group variances. Mean square error or MSE is frequently requested by journals as a companion statistic for ANOVA and, especially, t-tests. MSE is the average intra-group variance. MSE is outputted in ANOVA tables but can be computed using a weighted average of the group variances.
Line 7: Line 7:
MSE = $$\frac{\sum_text{i} (N_text{i}-1) SD_text{i}^text{2}}{\sum_text{i} (N_text{i}-G) } $$ MSE = $$\sum$$ over i [$$(N(i)-1) SD(i)^2 ^]/
[($$\sum$$ over i)N(i)) - G ] $$
Line 9: Line 10:
which equals $$\frac{\sum_text{i} SD_text{i}^text{2}}{G} $$ in the special case of equal group sizes. which equals ($$\sum$$ over i $$SD(i)^2 ^ )/G $$
in the special case of equal group sizes.
Line 11: Line 13:
In EXCEL, for two groups (A and B ) in cells A1:A100 and B1:B100 respectively this corresponds to MSE is also useful for computing Cohen's d effect size, the number of standard deviations between a pair of group means, because
Line 13: Line 15:
MSE =(SQRT(((COUNT(A1:A100)-1)+(COUNT(B1:B100)-1)))*(AVERAGE(A1:A100)-AVERAGE(B1:B100)))/(SQRT((COUNT(A1:A100)-1)*POWER(STDEV(A1:A100),2)+(COUNT(B1:B100)-1)*POWER(STDEV(B1:B100),2))) d = (difference in a pair of group means) divided by the square root of the MSE

In EXCEL, suppose we have two groups (A and B ) in cells A1:A100 and B1:B100 respectively, Cohen's d can then be computed using

COHENSD =(SQRT(((COUNT(A1:A100)-1)+(COUNT(B1:B100)-1)))*(AVERAGE(A1:A100)-AVERAGE(B1:B100)))/(SQRT((COUNT(A1:A100)-1)*POWER(STDEV(A1:A100),2)+(COUNT(B1:B100)-1)*POWER(STDEV(B1:B100),2)))

and the mean square error in EXCEL is computed by

MSE = ((COUNT(A1:A100)-1)*POWER(STDEV(A1:A100),2)+(COUNT(B1:B100)-1)*POWER(STDEV(B1:B100),2))/((COUNT(A1:A100)-1)+(COUNT(B1:B100)-1))

How do I compute Mean Square Error (MSE) in EXCEL or SPSS?

Mean square error or MSE is frequently requested by journals as a companion statistic for ANOVA and, especially, t-tests. MSE is the average intra-group variance. MSE is outputted in ANOVA tables but can be computed using a weighted average of the group variances.

Fo G groups with the i-th an SD, $$SD_text{i}$$ and sample size $$N_text{i}$$,

MSE = $$\sum$$ over i [$$(N(i)-1) SD(i)2 ]/ [($$\sum$$ over i)N(i)) - G ] $$

which equals ($$\sum$$ over i $$SD(i)2 )/G $$ in the special case of equal group sizes.

MSE is also useful for computing Cohen's d effect size, the number of standard deviations between a pair of group means, because

d = (difference in a pair of group means) divided by the square root of the MSE

In EXCEL, suppose we have two groups (A and B ) in cells A1:A100 and B1:B100 respectively, Cohen's d can then be computed using

COHENSD =(SQRT(((COUNT(A1:A100)-1)+(COUNT(B1:B100)-1)))*(AVERAGE(A1:A100)-AVERAGE(B1:B100)))/(SQRT((COUNT(A1:A100)-1)*POWER(STDEV(A1:A100),2)+(COUNT(B1:B100)-1)*POWER(STDEV(B1:B100),2)))

and the mean square error in EXCEL is computed by

MSE = ((COUNT(A1:A100)-1)*POWER(STDEV(A1:A100),2)+(COUNT(B1:B100)-1)*POWER(STDEV(B1:B100),2))/((COUNT(A1:A100)-1)+(COUNT(B1:B100)-1))

None: FAQ/mse (last edited 2018-03-12 11:11:06 by PeterWatson)