Hi everyone,
I have three variables each having a different scale
1) clubtime - indicating whether club activity started on time (1), started late (0.5) or if there was no club activity at all (0)
2) attendance - an integer value for the number of girls who attended the club on the day of the survey.
3) financial_literacy - a binary variable indicating whether the club as whole organized a financial literacy training or not.
I want to create a scorecard (1-100) by combining the above 3 variables such that clubtime and attendance each get 30% weight in the scorecard whereas financial_literacy gets 40% weight.
Any help in this regard will be highly appreciated.
Thanks
Danish
I have three variables each having a different scale
1) clubtime - indicating whether club activity started on time (1), started late (0.5) or if there was no club activity at all (0)
2) attendance - an integer value for the number of girls who attended the club on the day of the survey.
3) financial_literacy - a binary variable indicating whether the club as whole organized a financial literacy training or not.
I want to create a scorecard (1-100) by combining the above 3 variables such that clubtime and attendance each get 30% weight in the scorecard whereas financial_literacy gets 40% weight.
Any help in this regard will be highly appreciated.
Thanks
Danish
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input byte(survey_country ela_club) double clubtime byte(attendance financial_literacy) 1 2 0 20 0 2 11 1 11 1 1 1 0 20 0 2 9 .5 2 1 1 6 1 2 1 1 3 .5 3 0 1 5 1 6 1 1 4 0 20 0 2 7 1 8 1 2 10 .5 0 1 2 12 .5 4 1 2 8 1 11 1 3 15 .5 8 1 3 16 .5 8 1 3 14 1 4 1 3 13 1 16 1 end label values survey_country survey_country label def survey_country 1 "Uganda", modify label def survey_country 2 "Tanzania", modify label def survey_country 3 "Liberia", modify label values ela_club ela_club label def ela_club 1 "Masaanaa", modify label def ela_club 2 "Muzana 1", modify label def ela_club 3 "Bukejje", modify label def ela_club 4 "Kikajjo", modify label def ela_club 5 "Kampala Road", modify label def ela_club 6 "Kirombe A", modify label def ela_club 7 "Nsalaga", modify label def ela_club 8 "Chemchan", modify label def ela_club 9 "Chadurua", modify label def ela_club 10 "Ipagala A", modify label def ela_club 11 "Sandali", modify label def ela_club 12 "Mamboleo", modify label def ela_club 13 "Focus Girls", modify label def ela_club 14 "Faith Girls", modify label def ela_club 15 "Bright Future", modify label def ela_club 16 "Opportunity", modify label values financial_literacy financial_literacy label def financial_literacy 0 "No", modify label def financial_literacy 1 "Yes", modify
Comment