Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Z Score and Z Test Guidance

Avatar

Level 3

Hi guys,

I'm trying to create an in-workspace view of statistical significance, using a Z-Score to compare the conversion rates of two dimensions.

Unfortunately, I can't think of how to format a freeform table to provide a single Z-Score to then check for significance, can anyone help or do they have any examples?

Cheers in advance!

1 Accepted Solution

Avatar

Correct answer by
Level 2

You should be able to find the z-score:

 

(treatment rate - control rate) / standard deviation of population

 

There is an SD function there.

 

Then you create a calculated metric with the Cdf-z function: 1 - Cdf-z(z-score) that should give you the cumulative probability (i.e. Confidence value) that you're looking for.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

You should be able to find the z-score:

 

(treatment rate - control rate) / standard deviation of population

 

There is an SD function there.

 

Then you create a calculated metric with the Cdf-z function: 1 - Cdf-z(z-score) that should give you the cumulative probability (i.e. Confidence value) that you're looking for.