Standard Life, Scotland’s largest insurer, agreed to acquire Aberdeen Asset Management for about £3.8bn (€4.4bn), a deal that would create the UK’s largest active manager.