Hi,

How can I conduct z-test with QS calculated field? I am able to calculate standard error and t scores out but how can I get p value with the calculated field?

Thanks,

Tia

Hi,

How can I conduct z-test with QS calculated field? I am able to calculate standard error and t scores out but how can I get p value with the calculated field?

Thanks,

Tia

Hi @Tia_Song

I can try to test here - would you be looking to calculate p value using something like the normdistribution function or tdistribtion function in excel?

1 Like

Hi @Tia_Song

Create a table/dataset with precalculated p-values for all z-scores from -3.9 to 3.9. You can create the table in excel using the NORM.S.DIST formula, and upload into Quicksight. Use the table with an ifelse statement to get the P value for any value of Z.

You can do the same thing with the T distribution but the table is going to be longer as you have to take the degrees of freedom into consideration.

This is how the Standard Normal Distribution table would look like:

Hope it helps,

GL

1 Like