I took a bucket, drilled 2 different sized holes on the side near the bottom and filled it with water. The stream of water the proceeded from the larger hole traveled further than the stream from the smaller one. How does the size of the hole affect the distance that the water travels?
See also: Torricelli's Law.
I believe the physically relevant parameters here are: 1. internal pressure P at the bottom of the bucket but not too close to the hole, units [$kg*m^{-1} s^{-2}$], the fluid density $\rho$ [$kg*m^{-3}$], hole area $A$ units $m^2$, and viscosity $\eta$ $kg m^{-1} s^{-1}$. First, let's ignore the viscosity, and find which combinations can give us a velocity, units [$m/s$]. The unique combination is $\sqrt(P/\rho)$, and so in the limit of vanishing viscosity the velocity will be independent of the hole size. Now if we add in viscosity, there is a dimensionless combination available, $\rho \eta^2 P^{-1} A^{-1}$. We could have any function of this dimensionless ratio, but common sense tells us that at least in the limit of small $\eta$ it should be a decreasing function, since viscosity should take kinetic energy away from the fluid. From this ratio we see that decreasing the size of the hole is equivalent to increasing the viscosity, and thus the smaller hole should have a smaller exit velocity than the bigger one. I guess this is a long-winded way of saying the big hole will have higher Reynolds number and be less effected by the viscosity.
If the only forms of energy were the potential energy of the water in the bucket and the kinetic energy of the escaping stream, then by conservation of energy the velocity of the stream would have to equal $\sqrt{2gh}$, where $h$ is the difference in height between the hole and the surface. Since you observe that $v$ (or at least the component of $v$ parallel to the axis of the flow) depends on other factors, it's possible that in your experiment, there were other forms of energy involved. Two possible candidates are: (a) frictional heat, and (b) the kinetic energy of the water flowing toward the hole. We expect effect b to be minimal or zero, both because the velocity of this flow is small and because this KE represents a reservoir of energy that is either constant or only very slowly changing as the water level drops.
Another issue is that kinetic energy is independent of the direction of motion, and the flow of the stream as it exits may not be entirely parallel, so the velocity of flow in the direction parallel to the axis of flow will in general be less than $\sqrt{2gh}$. The stream contracts significantly on its way out, so quite a bit of its KE is in the form of motion that's transverse to the axis. This leads to something called an efflux coefficient. There is a discussion of both the frictional effect and the non-parallel effect in the Feynman Lectures, section 40-3. The non-parallel effect can be quite large. Feynman gives some examples for different types of holes and discharge tubes, and the efflux coefficients are typically factor-of-two effects.
Another way to approach this is through conservation of mass. When you put your thumb over the end of a garden hose, the cross-sectional area $A_1$ of the aperture under your thumb is less than the cross-sectional area $A_2$ of the hose. Since water is being neither created nor destroyed, we must have $v_1/v_2=A_2/A_1$. This is the opposite of what you observed, and the two situations are not really analogous. They would be analogous if there was a piston pressing down on the surface of the water at the top of the bucket so that the level was constrained to go down at a fixed rate.
[Edited the above answer to improve it based on comments by Omega Centauri.]
user 1631 is correct in his/her thinking. It is based on Poiseuille's law.
Flow Q ~ (dP/dL)*r^4
where dP is the pressure differential across the small length L of the hole (imagine the hole had a small pipe of radius r. Now we know that dP/dL is same because it is the pressure difference in the (fluid - P_atm).
Therefore, Q is proportional to r^4 while velocity is Q/Area which is proportional to r^2, Therefore, higher velocity from a larger hole... Of course, I have left out the viscosity term in the proportionality equation. It should be always be there because it is viscosity that causes this effect as pointed out earlier by others. But it is a constant hence I just left it out as it goes away in ratioing.
I like the notation from Ben in his answer. So we will compare two situations with equal water column height but different areas of the hole, $A_1$ and $A_2$. We find that the distance the water squirts is different due to friction. I propose that the friction is from three different sources.
I would actually imagine that the 3rd one would be the most significant. Some meaningful relations for this could be deduced exclusively from the hole size. If we assume the first two sources of friction are small, then the initial velocity leaving the hole is the same for both cases, thus we have a certain flow rate and velocity for each. If we assume the holes to be circular and extend this assumption to the stream itself, we can find the perimeter interacting with air and the linear density of the stream of water (close to the hole).
Then the problem is similar, but not exactly the same, as that of a projectile with air resistance. The metric that matters is the ratio of the drag coefficient to the mass, but the linear mass density in the case here. I'll try to come back and put some equations up here later so we can maybe even get a general figure of merit for where deviation from a parabolic path of the water jet will be observed.
Local forms loss of the hole
I realized that the parts of 1&2 is really a pretty standard engineering problem.
$$\Delta H = \frac{v^2}{2 g} + K \frac{v^2}{2 g}$$ $$ v = \sqrt{ \frac{2 g h}{1+K} }$$
Now, we won't be able to avoid the inevitability of finding Reynolds number, so here we are.
$$Re = \frac{G D}{\mu} = 2 \frac{v \rho}{\mu} \sqrt{ \frac{A }{\pi} }$$
If we're talking about in the neighborhood of a hole $1 cm^2$ and a velocity $1 m/s$ then we find Reynolds number to be around 1,000. Now, I found no choice to use an actual academic paper to get the loss coefficient. See Accurate Evaluation of the Loss Coefficient and the Entrance Length of the Inlet Region of a Channel.
$$K = 4.183 \times 10^{-5} Re + 0.152$$
So K will be in the neighborhood of 0.2. This is the major difference for the two cases regarding 1&2 types of losses. I tried some numbers, like 1 m for the head, and found without the forms loss you get about 4.4 m/s exit velocity, with 1 cm^2 hole, you get 2.8 m/s. Increasing the size of the hole 10x I get 2.1 m/s and decreasing it 10x I get 3.4 m/s. This isn't what I expected. I thought that a small hole would make the fluid velocity smaller, but maybe I've messed something up with the signs although I can't find it right now. I know how I would approach #3 as well, but I don't have the time. I certainly don't think anyone has sufficient evidence to say one type of loss is greater until some more work is done.
