Oct 07 2021 11:34 PM
This is probably pretty easy, but I can't make it work, been trying different formulas without success, and now I need help!
In one column I have values raging from -3,00 to 3,00. In the other coulmn I have the interpretation of this value, everything between -0,5 and 0,5 is for example average, 0,5 to 1 is above average and so on.
There has to be a way to automate this interpretation-process with a formula, right?
Thanks in advance for any help!
Oct 08 2021 12:47 AM
Perhaps you may provide small sample. It's not clear, at least for me, which average to take and what "so on" means.
Oct 08 2021 12:48 AM
@MATWS Perhaps the attached file will get you started. Use a lookup table where you set the lower boundary for each rating. In the example I've used LOOKUP, but you might as well try VLOOKUP or XLOOKUP (if your Excel version supports the latter).
Oct 08 2021 01:42 AM
Of course, I'm sure I've described it poorly ... Perhaps I can explain it better! I can upload a sample, but let me try do describe it better first!
My values can be anywhere between +3 and -3 (z-scores). For every value there is a description/interpretation. Instead of having to look up every value in a chart, for example this one: Psychometric_Conversion_Table.pdf (ritenour.k12.mo.us)
.. I would like Excel to do it for me!
Does it make sense? :)
Oct 08 2021 01:42 AM