Skip to content

πŸ”Ž Need parentheses when squaring Οƒ

Don’t forget to use parentheses when squaring things!

EFGHIJK
WBillsW_{Bills}WIndexW_{Index}Expected ReturnWrong VarianceFormulaVarianceFormula
00110.110.110.10890.1089=F6*$B$6^20.10890.1089=(F6*$B$6)^2
0.20.20.80.80.09400.09400.08710.0871=F7*$B$6^20.06970.0697=(F7*$B$6)^2
0.40.40.60.60.07800.07800.06530.0653=F8*$B$6^20.03920.0392=(F8*$B$6)^2
0.60.60.40.40.06200.06200.04360.0436=F9*$B$6^20.01740.0174=(F9*$B$6)^2
0.80.80.20.20.04600.04600.02180.0218=F10*$B$6^20.00440.0044=(F10*$B$6)^2
11000.03000.03000.00000.0000=F11*$B$6^20.00000.0000=(F11*$B$6)^2

Exponentiation (ie ^) has a high precedence, above multiplication, in β€œorder of operations,” so this is required.