Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I Would like to find the formula to obtain the relative frequency for a weight, for example:
I have one variable Chequeo with valors (1 or 2) and for each valor there is one Peso :
Valor Peso Chequeo
1 0.87 Calidad
1 0.999 Calidad
2 1.335 Servicios
2 0.85 Automóviles
and I would like to find:
(count(if ((Valor='1'),Chequeo))/count(Chequeo))*100
but I have to bear the weight in mind .
THANKS!!!!!!!!!
I'm not entirely following. What do you want to see in your chart for the example data?
For example: the frecuency from variable=Chequeo....of Calidad is 2/4 but, I want to obtain:
Count( Chequeo*Peso) / Count(Chequeo): is the same: (1*0.87)+(0.999*1)/4, if only where Valor=1
(count(if ((Valor='1'),Chequeo*Peso))/count(Chequeo))*100.......... it`s wrong!!!!!!!
Thanks