Bonferroni correction in Excel

[jeffwang0925]

Dear all,

I am a graduate student.

I got a comment that should perform Bonferroni correction for my multiple comparison of the T-test.

I am wondering if I can perform the Bonferroni correction in Excel?

I tried to search for related posts….but I still don't know a clear steps in performing this…

Is there anyone that could help me with this please?

I would deeply appreciate your time and help.

Thank you so much.

Sincerely,
Jeff

[MrShorty]

According to wolfram's mathworld (http://mathworld.wolfram.com/BonferroniCorrection.html ), the simplest implementation of the Bonferroni correction is to divide each alpha value for each comparison by n -- the number of different comparisons you are making.

Another explanation of the Bonferroni correction: http://generallythinking.com/datablo...ni-correction/

You're probably more of a statistician than I am -- does that make sense to you?

[jeffwang0925]

Thank you so much MrShorty!!

Which means within a data set I did five comparison,
If I do the correction, then my p needs to be p< 0.05/5=0.01 to be significant?

That's it? Thank you so much!

Sincerely,
Jeff