Hello,
the candle is paraffin wax, the "formula" is (neglecting end groups) CH² .
So, total combustion would result in one molecule of carbon dioxide
per one molecule of water. Given enough time, the cabon dioxide
would dissolve in the water entirely.
But
problem is, that the combustion will not be total!
When oxygen becomes rare, some carbon monoxide will be
formed, along with a lot of cracked products from the wax.
The carbon monoxide will not easily dissolve in water.
This is reason for the "inconsistent" results.
For that reasons this experiment is better done with
iron wool or white phospor.
Georg