Today, while drinking some water from a \$500mL\$ bottle, I started reading the info about the water and found out that the conductivity (\$\sigma\$) at \$25°\$C is \$147.9\mu S/cm\$. So it came to my attention that maybe I could calculate the resistance of the water bottle, from top to bottom. After some measuring, I found out that the bottle can be approximated as a cylinder with \$18cm\$ height and \$3cm\$ base radius.
So we can do the following: \$R_{eq} = \frac{\rho L}{A}\$, where \$\rho = \frac{1}{\sigma}\$ is the resistivity, \$L\$ is the bottle's height and \$A\$ is the base area. By doing this, I got \$R_{eq} \simeq 4.3k\Omega\$.
Then, I bought a new full bottle, made a hole on it's bottom (of course avoiding leakages) and measured the resistance (with a digital multimeter) from this hole to the "mouth", at first making it so that only the tip of the probes touches water. The measured resistance was really high, ranging from \$180k\Omega\$ to even \$1M\Omega\$ depending on how deep in water I positioned the probes.
Why is the measured resistance so different from what I calculated? Am I missing something? Is it possible at all to use a bottle of water as a resistor?
Edit #1: Jippie pointed out that I should use electrodes with the same shape as the bottle. I used some aluminum foil and it actually worked! Except this time I measured ~\$10k\Omega\$ and not the \$4.3k\Omega\$ I calculated. One thing I was able to notice while lighting a LED with water as a resistor was that the resistance was slowly growing over time. May this phenomenon be explained by the electrolysis that happens while DC current travels through water (the electrodes slowly get worse because of ion accumulation at their surfaces)? This would not happen for AC current, right?