Recoding to cumulative frequency

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Recoding to cumulative frequency

rprimi
Dear list members

I have a table of cumulative frequencies for values calculated in one file (see bellow Var1 that range from from -4.73 to 4.83). Now, in a new file, I want to recode var2, that is in the same scale of Var1, applying the cumulative percent based on this table. For instance if a value of Var2 is -2.11 it would be recoded to 1.4 ; if -1.80 to 3.2 and so forth … Any idea of a easy way to do that ?


Var1            Cum Freq.
-4.736          .0
-3.519          .1
-2.744          .4
-2.259          1.4
-1.892          3.2
-1.588          6.2
-1.322          10.5
-1.081          16.2
-.857            23.0
-.644            31.1
-.438            39.8
-.235            49.1
-.034            58.6
.169             67.5
.376             76.0
.590             83.4
.814             89.4
1.052           94.0
1.309           97.0
1.594           98.8
1.919           99.6
2.308           99.9
2.816           100.0
3.613           100.0
4.853           100.0

Thanks
Ricardo Primi

http://lattes.cnpq.br/5114152079911903 
University of São Francisco, Brazil