A cake is specified by a 3-vector $x=(x_1,x_2,x_3)$, where $x_i$ is the percentage of the $i$-th ingredient, and therefore $\sum_ix_i=1$. I have a price list $y$ for different $x$'s:
> y x
> 71 (0.1, 0.2, 0.7)
> 73 (0.0, 0.3, 0.7)
> 76 (0.0, 0.4, 0.6)
> 79 (0.1, 0.6, 0.3)
> ...
I computed the weighted mean and standard deviation for each ingredient $x_i$ with these formulae. $$\bar y_1=76\quad \sigma_1=6.9\\ \bar y_2=76\quad \sigma_2=7.1\\ \bar y_3=74\quad \sigma_3=7.8$$
To me, these ingredients do not affect the cake price too differently, because $\bar y_1-\bar y_3=2$, which is relatively small given that both $\sigma_1$ and $\sigma_3$ are around $7$! Ditto for $x_2$ and $x_3$.
However, when I fit a simply GLM $y=\beta_0+\beta_1x_1+\beta_2x_2$ and test if $\beta_1=\beta_2=\beta_3$, $p=8\times10^{-7}$ telling me these ingredients affect the cake price very differently! This is a bit counter-intuitive to me.
How may I reconcile my intuitions with the test results?