Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Jun 26, 2017 10:08 AM
| Last Modified: Aug 8, 2017 6:52 AM
You want to create a new data table column that contains values that are based on the evaluation of a formula. The formula uses the value of another column to determine the value in the new column.
This solution uses the Big Class sample data table and creates a formula that uses the value of the Age column to determine a resulting category for a new column called Adolescent Phase. If the value of Age is less than or equal to 12, the formula returns "early"; if the value of Age is greater than 12 but less than or equal to 15, the formula returns "mid"; if the value of Age is greater than 15, the formula returns "late".
A formula column can use the values from other columns in the data table, but it does not have to use them. In fact, you can use random number generation JSL functions in formula columns to create random numbers in a data table. Creating formula columns like this is also sometimes known as feature creation.