What formula do I use to complete this task?

Iransform the non-numeric data into numeric data. Unless the analysis is done exclusively using categorical data, transtorm the data into a numeric variable. Following are examples of how to transform four of the variables: Loan Status: This is the variable we're using as our dependent variable, but currently it is non-numeric data. Let's make a new variable titled "Loan Paid" with the value of 1 if the "loan_status" (in Column Q ) is "Fully Paid" and a value of 0 if the "loan_status" is "Charged Off." After this point in the analysis, only this variable will be used as the dependent variable, instead "loan_status." loan_status Fully Paid Charged Off Fully Paid Fully Paid Fully Paid Fully Paid Fully Paid Fully Paid Charged Off Charged Off Fully Paid Fully Paid Charged Off Fully Paid Charged Off Fully Paid Fully Paid Fully Paid Fully Paid Fully Paid Fully Paid Charged Off Fully Paid Fully Paid Charged Off Fullv Paid