forms - Sign-up: Does the "confirm email" field work?

How many people sign up with a wrong (mistyped) email address when:

1. you have a "confirm email" field


2. you don't have a "confirm email" field

There is a very similar question on ux.se but it doesn't tackle the main question (namely if "confirm email" fields work or not)