I have a huge problem with transforming raw data into standardised one. I would be grateful for your help. Below is a description of the case.
The blue picture shows norm table that transforms the raw results of a given questionnaire into standardised results (by age and gender of the respondent). The first column (Sten) presents a standardised values. The other columns (neo, eks, otw, etc.) present raw values for each scale of the questionnaire. The table on the left is for women and the table on the right is for men in the 20-29 age group.
I have a big problem with changing the raw value to a standardized one. I have raw results from many subjects and I would like to assign standardised value to them. For example, a woman aged 25 years who completed the questionnaire and obtained a raw value of 8 on the NEU scale should receive a standardized value of 1.
Does anyone have an idea how to do it? Thank you very much for any suggestions.