Discrepancy in Weighted Value Result

A formula for a weighted average using cols K and AN is giving me a result of 23.30% but the answer should be 7.44%, right, according to the long hand version I've written out below?

Am I using the correct formula to weight the col K, IV values with Vega in col AN?

Cheers,

K4 (12.05%) × AN4 (11.7642) = 0.1205 × 11.7642 = 1.4179

K6 (22.27%) × AN6 (-46.5696) = 0.2227 × (-46.5696) = -10.3703

K8 (12.45%) × AN8 (-51.8875) = 0.1245 × (-51.8875) = -6.4600

K10 (21.53%) × AN10 (47.5218) = 0.2153 × 47.5218 = 10.2367

K12 (7.60%) × AN12 (14.6174) = 0.0760 × 14.6174 = 1.1109

K14 (9.01%) × AN14 (-5.1448) = 0.0901 × (-5.1448) = -0.4635

K16 (9.65%) × AN16 (-3.1896) = 0.0965 × (-3.1896) = -0.3078

K18 (13.46%) × AN18 (42.2842) = 0.1346 × 42.2842 = 5.6917

K20 (19.13%) × AN20 (-39.0638) = 0.1913 × (-39.0638) = -7.4735

K22 (24.08%) × AN22 (-36.5901) = 0.2408 × (-36.5901) = -8.8118

Sum of Products = -4.93069361

Sum of AN values:

AN4 (11.7642) +

AN6 (-46.5696) +

AN8 (-51.8875) +

AN10 (47.5218) +

AN12 (14.6174) +

AN14 (-5.1448) +

AN16 (-3.1896) +

AN18 (42.2842) +

AN20 (-39.0638) +

AN22 (-36.5901) 

Sum of AN = -66.2577

= -4.9306 ÷ -66.258 = 0.0744 or 7.44%

[Edited by Moderator]