Let's say I have the following data:
Video A:
Procurado: 12000 vezes
Clicado: 7000 vezes
Video B:
Procurado: 11000 vezes
Clicado: 10000 vezes
Let's say I have the following data:
Video A:
Procurado: 12000 vezes
Clicado: 7000 vezes
Video B:
Procurado: 11000 vezes
Clicado: 10000 vezes
Video A Wanted 12000 Clicked 7000 - percentage A = 58.33% = 0.58
Video B Wanted 11000 Clicked 10000 - percentage B = 90.9% = 0.90
Calculation of relevance between Video B and video A
Proportion of the pooled sample (p) - Combination of proportions of the two groups.
7000 + 10000
p = _________________ = 0,739
12000 + 11000
Standard error - Measure the difference between your ratio and the true ratio. A smaller number means that the ratio is closer to the true ratio. A larger number means that the ratio is far from true
SE = ((0.739 * (1-0.739)) * (1/12000 + 1/11000)) 1/2
SE= 0,00578
Test statistic (t) - A t-statistic. The number of standard deviations between the distance of a number and the mean. t= (percentagem B - percentagem A)/SE
t= (0.9 - 0.58)/0.00578 = 55,36
Statistical Relevance - If the absolute value of the test statistic is greater than 1,96
* times the standard deviation of the mean, it is considered a statistically relevant difference.
* 1.96 is the number used for the 95% confidence level. See page 10 of this link Applied Statistics
Conclusion Since the absolute value of the test statistic 55,36
is much greater than 1.96, it means that the difference between Video B and Video A is highly relevant.