Lie Detection will let a player know when an NPC isn't telling the truth, or even trying to hide information. The higher the skill level, the more difficult the lies can be detected. More intelligent lifeforms are better at lying, so having a higher skill level helps from that perspective as well.