Scl 90 R Scoring Excel · Complete & Extended

Better: use named ranges or an item lookup table. Create a table in Scoring sheet:

=ROUND(((SOM_sum / num_items_SOM) - mean) / SD * 10 + 50, 1) Example: scl 90 r scoring excel

Then for SOM (items 1,4,12…):

=TotalScore / PST You need gender-specific norms. Example formula for SOM T-score (female, general population, mean=0.36, SD=0.42): Better: use named ranges or an item lookup table

=SUM(B2,E2,M2,AB2,AN2,AP2,AV2,AW2,AZ2,BA2,BD2,BF2) scl 90 r scoring excel