Show all p-value data

analysis
1

Is there a simple way to change the code so I can see all the p-values? The field work we due it is acceptable to use p-value of 0.1 instead of the standard 0.05.

If I were to change the following code in the cls1WayANOVA

Option Explicit

Private Const mAlphaLevel = 0.05

to

Option Explicit

Private Const mAlphaLevel = 0.1
would that accomplish my goal?

3

Yes, that would indeed set the alpha level to 0.1.

However, you should also see a new sheet in your workbook with a detailed report and exact p values when you execute the ANOVA function.

4

Thank you this work great for me.