A bank must prepare for a discrimination suit filed on behalf of female employees that claim females are paid less than male employees. The bank manager sampled employee files to see if he could build a useful model for predicting salary as a function of gender and other characteristics. For each employee, the data includes salary (y, in thousands of dollars), years experience (YrsExp), years prior experience (YrsPrior), and Gender. The data is in the spreadsheet named Bank.

a. (6 points) Since Gender is a categorical variable, construct the appropriate dummy variable in column E to indicate gender as female = 1 and male = 0. You must use an IF statement in the appropriate cell(s) to indicate the correct dummy value based on gender.

b. (4 points) With cell H3 as the upper left corner of the output, Use Excel Data Analysis tool to generate the full regression model. (Do not generate the residual plot).

c. (6 points) Based on the regression output from part b, shade in yellow the name of any variable that appears significant and should remain in the model. Also shade the corresponding t stat and p-value.

Can you show me how to use "If statement in excel for E- Cell for male and female value?