Difference between weight of water and pressure of water (I didn't even have a basic formal education in physics. I'm learning through the internet out of my own interest, so if there are any silly mistakes, kindly bear with and guide me through.)
Everywhere, everyone is saying that pressure will same be for a given height. How is it possible? When volume changes, doesn't pressure change in calculations?
[Pressure will be 2.5 bars approximately (including atmospheric pressure) for a height of 15 metres from ground level. I checked on many sites that 2.5 bars equals 2.5 kg/cm².]
Now let's take base area as 2000 cm² and height of 15 m as constant in three scenarios:
EACH SCENARIO IS INDEPENDENT AND TUBES ARE SEPARATE, I.E NOT CONNECTED WITH EACH OTHER
In scenario 1 a straight vertical tube from ground level will have capacity of 3000 litres with a weight of 2.5 kg per cm² [3000 litres / 2000 cm² = 1.5 kg/cm² + 1 kg/cm² atmospheric pressure].
In scenario 2 the tube becomes narrow from the base area, resulting in a volume of 2000 litres.
In scenario 3 the tube becomes wide from the base area, resulting in a volume of 4000 litres
Question:
When they say pressure remains the same at a given height, does it mean that weight will be 2.5 kg/cm² in all 3 scenarios, where volume is 3000, 2000, or 4000 litres (base area 2000 cm², height 15 m constant)? How is it possible? Where am I wrong?
 A: Consider this diagram showing the three columns you describe all connected to the same body of water:

Your question asks whether the three pressures $P_1$, $P_2$ and $P_3$ will be the same. The answer is obviously yes, because the columns are all connected to the same body of water. For example if $P_1 > P_2$ then water would flow from the base of column 1 to the base of column 2 until the pressures became equal.
OK, but the next question is whether the heights of all the columns are the same. Again the answer is yes because if they weren't we could connect the tops of the columns, let water flow between them and we would have a perpetual motion machine.
So we conclude that the pressure is only related to the height $h$ and does not depend on the shape of the column. Specifically, the relationship between pressure and height is:
$$ P = \rho g h $$
where $\rho$ is the density of the fluid and $g$ is the gravitational acceleration (9.81 m/sec$^2$).
A: If you replace the fluid scenarios with solids with matching have the same shapes, then indeed the pressure at bottom would be the weight of each solid divided by base area, i.e., they would be different!  Then what's different about the fluid case?
I presume in scenario 1 you have a prism, in scenario 2 you have a bottom-heavy frustum, and in scenario 3 you have a top-heavy frustum.
What's special for the fluids is that pressure acts in all direction.  It is important to note that the fluid is in a container.  At each point of the fluid-container interface, the fluid pushes against the container (normal to surface).  But since there is no net acceleration on the fluid, so the container must push back with an equal and opposing force.
In scenario 3, the container side wall pushes diagonally-up, thus supporting the extra weight, and making the pressure at the bottom less than that of the solid case.  In scenario 2, the container wall pushes diagonally-down, thus supplying the downward force in addition to the weight of the fluid itself.  In the end the force contribution of the container walls make the pressure at the bottom equal for all 3 scenarios.
Now, for an arbitrary container filled with fluid that are connected, a useful intuition is to think of the fluid as being "carved out" from a large pool of fluid.  The fluid-container interface acts identically as the fluid-fluid interface in the pool, so that at each internal point, the pressure depends only on depth, and not the container's geometry.
Of course, the effect of gravity means that each small "unit" of fluid presses its own weight downward, thereby increasing pressure as you move downward.
