breaking numeric data into groups or categories

[dataclubs2018@gmail.com]

Is there an easy way to take a numeric attribute, like “percent of forest cover” for states, break it into 2 or more categories based on threshold value(s) (like over or under 43% forestation), and make a new attribute that is categorical–such as “over or under threshold value for forest cover”.  So the new variable in this case would have two values, “over” and “under”.

 

 

[Bill Finzer]

Suppose we have numeric values ranging from 1 to 100 that we wish to break into three groups: “low,” “medium,” and “high.”

We use the formula:

if(Number<33,”low”,
if(Number<66,”medium”,”high”))

The screenshot shows the formula for this as it appears in the formula editor.

Hope that helps.

Bill

• This reply was modified 5 years, 9 months ago by Bill Finzer.

Attachments:

1. 

   formula.png
   

[Author]

Posts