π Need parentheses when squaring Ο
Donβt forget to use parentheses when squaring things!
E | F | G | H | I | J | K |
---|---|---|---|---|---|---|
Expected Return | Wrong Variance | Formula | Variance | Formula | ||
=F6*$B$6^2 | =(F6*$B$6)^2 | |||||
=F7*$B$6^2 | =(F7*$B$6)^2 | |||||
=F8*$B$6^2 | =(F8*$B$6)^2 | |||||
=F9*$B$6^2 | =(F9*$B$6)^2 | |||||
=F10*$B$6^2 | =(F10*$B$6)^2 | |||||
=F11*$B$6^2 | =(F11*$B$6)^2 |
Exponentiation (ie ^) has a high precedence, above multiplication, in βorder of operations,β so this is required.