So how we can convert an ordinal variable to a numerical variable and vice versa? Well, we can work with these things called percentiles, which tell us where a value is within the range of a continuous variable! Yeah, I’ll explain it better – don’t worry.  Say we have 10 numbers (1.405906  2.506874  3.752974  4.818329  4.956841  5.978801  6.924259  7.711760  7.859507 10.218921).  Now, say the first level of our ordinal variable corresponds to any number less than the 30th percentile.  That would be the third smallest number in our list, or 3.752974.  So any number less than 3.752974 would correspond to the first level.  Or if the second level corresponds to numbers between the 30th and 50th percentile, we would assign any number between 3.752974 and 4.818329 to that level. And any number above 4.818329  or the 50th percentile would correspond to the third level.

Now, say MGM is more likely to do an Order movie than Universal which is more likely to do an Order movie than Warner Brothers.  So we group MGM in the first percentile, Universal in the second percentile, and Warner Brothers in the third percentile.  If I then come up a number of 3.665538, then we can say MGM is going to make my movie (YAY!! I get the lion!!).  But if my number is 5.965685 then Warner Brothers will make the movie. (Not bad … I like Bugs Bunny too).  And if our number is 4.308145, then Universal is most likely to make my movie (about time Universal made something with multiversal appeal!).  Of course, I’d be open to all three studios coming up with franchises for the trilogy and … yeah, okay, first I’ll focus on getting a few more sales this month.  But until next time …


MGM … Universal … Warner Brothers — just think about it 😉