Hello Again,
After Johnson curve fitting, I transformed the scores to a scale (m=15, sd=3), which is a bench mark for these kinds of tests. I have sent a section of my data here. The first col -raw score (0-27), the second col-scale score (1-24) and the third is, I fitted the second to kernel density estimation in excel, and got the third col, which is adjusted scaled score. The problem is, this adjusted scaled score should have mean 15, SD 3. I do not know how to use kernel smoother in JMP. I have got five subscales with three age group norms, and am progressing halfway through. So far none of them fitted to mean-15, SD-3. it ranges from 15-19 but SD is ranging between 3 or 5. I am time pressed and have to figure out a way. I do not know if am right, I tried to use the third col.. into random number generation in excel with maximum value 24.. calculated m and sd of them to spot the right one. But its exhaustive to do that. I am not confident to explore non parametric statistics here but there has been evidence for kernel smoother to fit post norms smoothing. Would really appreciate any advice. Thanks.