Hello,
I have a dataset where my dependent variable is student_score (from a math standardized test) and a series of independent variables, e.g. class size, household characteristics, age, gender, etc. Students can get a maximum of 30 points in the standardized exam. I converted raw scores into z-scores at the classroom level. Because Stata does not allow to combine -egen- with -by()-, I did this conversion manually as shown below:
egen mean_score=mean(student_score), by(classroom)
egen sd_score=sd(student_score), by(classroom)
gen z_score=(student_score-mean_score)/sd_score
Though the commands above worked fine, the interpretation of findings (i.e. in terms of standard deviations) is difficult to understand for the organization we are producing the study for, as their staff does not have a statistical background. I then decided to convert the z-scores into normal curve equivalents (NCEs) -- i.e. 1-99 scale. I did this by computing the following in Stata:
z_score*21.06+50.
However, I ended up with scores under 0 (negative) and scores over 99. I believe this is because I calculated the z-scores by classroom. How could I standardize scores by classroom and convert them into a different, more user-friendly scale? Is there any command or set of commands in Stata to make this score standardization more accurately?
Many thanks!
Patricia
I have a dataset where my dependent variable is student_score (from a math standardized test) and a series of independent variables, e.g. class size, household characteristics, age, gender, etc. Students can get a maximum of 30 points in the standardized exam. I converted raw scores into z-scores at the classroom level. Because Stata does not allow to combine -egen- with -by()-, I did this conversion manually as shown below:
egen mean_score=mean(student_score), by(classroom)
egen sd_score=sd(student_score), by(classroom)
gen z_score=(student_score-mean_score)/sd_score
Though the commands above worked fine, the interpretation of findings (i.e. in terms of standard deviations) is difficult to understand for the organization we are producing the study for, as their staff does not have a statistical background. I then decided to convert the z-scores into normal curve equivalents (NCEs) -- i.e. 1-99 scale. I did this by computing the following in Stata:
z_score*21.06+50.
However, I ended up with scores under 0 (negative) and scores over 99. I believe this is because I calculated the z-scores by classroom. How could I standardize scores by classroom and convert them into a different, more user-friendly scale? Is there any command or set of commands in Stata to make this score standardization more accurately?
Many thanks!
Patricia
Comment