Calculation of relevance of a product? [closed]

0

Let's say I have the following data:

Video A:
    Procurado: 12000 vezes
    Clicado:   7000 vezes

Video B:
    Procurado: 11000 vezes
    Clicado:   10000 vezes
  • How can I calculate the relevance of these two videos in my site?
  • Should I rely on other numbers besides these? If so, which ones?
  • asked by anonymous 17.07.2018 / 02:48

    1 answer

    1

    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.     

    17.07.2018 / 04:35