I need help oncalculations on cell that are in pink color (Deviation from expected return). The numbers answers 256, 16 and -144 are the correctfrom the homework.I don't know how make the.Attached is the excel spread sheet with my calculations.I need help to complete that section. Excel calculations please!

Thanks!

Show correct answer A game of chance offers the following odds and payoffs. Each play of the game costs $125, so the net profit per play is the payoff less $125. Probability 0.20 0.40 0.40 Payoff $ 500 $ 200 $ - Net Profit $ 375 $ 75 $ (125) 125 a-1. What is the expected cash payoff? $ 180.00 Probability Payoff Net Profit 0.20 $ 500 $ 375 0.40 $ 200 $ 75 0.40 $ - $ (125) Expected cash payoff Expected cash payoff $ 100 $ 80 $ $ 180 a-2. What is the expected rate of return? Probability Payoff Net Profit 0.20 $ 500 $ 375 0.40 $ 200 $ 75 0.40 $ - $ (125) $ 0.44 Rate of return 7500% 3000% -5000% 5500% $ 0.44 Expected rate of return b-1. Calculate the variance of this rate of return.(Round your answer to the nearest whole number.) Probability 0.20 0.40 0.40 Payoff $ $ $ 500 $ 200 $ - $ Net Profit 375 75 (125) Return Deviation from expected Return 300% 60% -100% $ $ $ Squared Deviation 256 $ 16 $ (144) $ Incomplete calculations 65,536 256 20,736 s $125, so Probability x Squard Deviation $ $ $ 13,107.2 102 8,294 $ $ 21,504 146.64