# Show all p-value data

**URL:** <https://forum.xltoolbox.net/t/show-all-p-value-data/856>\
**Category:** analysis\
**Created:** [December 9, 2020, 5:55am UTC](https://forum.xltoolbox.net/t/show-all-p-value-data/856 "2020-12-09T05:55:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dwb5555](https://forum.xltoolbox.net/letter_avatar_proxy/v4/letter/d/f08c70/32.png) [@dwb5555](https://forum.xltoolbox.net/u/dwb5555)\
**Post date:** [December 9, 2020, 5:55am UTC](https://forum.xltoolbox.net/t/show-all-p-value-data/856/1 "2020-12-09T05:55:45Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Daniel](https://forum.xltoolbox.net/user_avatar/forum.xltoolbox.net/daniel/32/6_2.png) [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Post date:** [December 10, 2020, 6:23am UTC](https://forum.xltoolbox.net/t/show-all-p-value-data/856/3 "2020-12-10T06:23:29Z")

</div>

> [@dwb5555](#):
>
> Private Const mAlphaLevel = 0.1  
> would that accomplish my goal?

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.

---

<div class="post-metadata">

**Author:** ![dwb5555](https://forum.xltoolbox.net/letter_avatar_proxy/v4/letter/d/f08c70/32.png) [@dwb5555](https://forum.xltoolbox.net/u/dwb5555)\
**Post date:** [December 11, 2020, 12:52am UTC](https://forum.xltoolbox.net/t/show-all-p-value-data/856/4 "2020-12-11T00:52:49Z")

</div>

Thank you this work great for me.
