A binary variable is one that can only have two possible values. They generally fulfill two essential characteristics:
1. They are made up of two exhausting values, which indicates that there is no other possibility of response. For example, a person is female or male.
2. Both values of the variable are exclusive, that is, it is not possible that both responses can be given, only one. In the same example above, a customer cannot be a woman and a man at the same time.
The answer and procedures of the exercise are attached in the following archives.
Explanation
You will find the procedures, formulas or necessary explanations in the archive attached below. If you have any question ask and I will aclare your doubts kindly.
Array functions in excel are powerful tools sometimes refereed to as "CSE" functions because you have to press Control+Shift+Enter in order to enter them in your worksheet.