Project Summary: Pay Equity Assigment he excel file "Fall 2017" template INCLUDES the VLOOKUP formula already included for the GENDER column. You can use it to help you determine what the formula should look like for the other columns. The 5 positions that you are asked to analyze are different from tutorial video. The 5 positions you should look at are: CAD TECHNICIAN I ASSOCIATE CONSTRUCTION MANAGER ENGINEER I Sr. FIELD REP I PLANNER I For the T.TEST you should compare your results to a value of .05. Meaning if the value that comes back is LESS than .05, there is a significant difference between male and female pay for that specific position. If it comes back as MORE than .05, there is not statistically significant difference.