Question

Logical FunctionsRecall that you had converted the response variable fromYes/No to 1/0 using find and replace. Which of the following functions can be used to convert Yes and No to 1and O respectively? Mark all that apply.A) IF(response = "Y", 1,0)B) IF(response = "Y", 0, 1)C) IF(response = "N", 1, 0)D) IF(response = "N'", 0, )which of the above is correct??​

Answer 1

Answer:

IF(response = "Y", 1,0)B)

Explanation:

is correct

Answer 2

Answer:

Is correct

Explanation:

If (response = "Y",1,0)B)