DocHub is an all-in-one PDF editor that allows you to replace answer in xls, and much more. You can highlight, blackout, or remove paperwork elements, insert text and images where you want them, and collect data and signatures. And because it runs on any web browser, you won’t need to update your hardware to access its powerful features, saving you money. With DocHub, a web browser is all it takes to process your xls.
Sign in to our service and follow these steps:
It couldn't be simpler! Simplify your document management now with DocHub!
in this video Iamp;#39;m going to demonstrate how to convert an ordinal categorical variable to a numeric variable the variable I will focus on here is urban influence we have four categories here going from the most urban a county can be to the least urban in our data set I created a pivot table describing these categories and you can see here these are the categories Iamp;#39;m going to copy and paste these categories back into my original sheet copy Iamp;#39;ll paste it right here paste then Iamp;#39;ll assign each one of these a number letamp;#39;s call this one a 4 3 2 1 so as we are more urban we have a larger number here or at least urban is our smallest value Iamp;#39;m going to create a new variable Iamp;#39;m going to click on the column right next to urban influence select insert to make room for a new variable I will call this urban influence Namah for numeric I am going to use the Excel lookup function so Iamp;#39;m going to type equals lookup Iamp;#39;m going to