Need to put this formulas into VBA and create this in excel.

i need to put this formulas into VBA and then answer the questions.

PSTDEV Probability 10% 20% 40% 20% 10% Value -30.00% PStdevo) = -10.00% 5.00% -1 (1-P)2 x Pi 12.00% 35.00% where f = 1 Pri 2.90% =@ExpValue(B18:B22.C18:C22) 16.21% =SQRT (B18*(C24-C18)^2)+(B19*(C24-C19)^2)+(B20*(C24-C20)^2)+(B21*(C24-C21)^2)+(B22*(C24-C22)^2)) 16.21% =PStdev(B18:B22.C18:022) Expected Value (r hat), Formula Portfolio Standard Deviation, Formula Portfolio Standard Deviation, Student VBA Function 52 Week Range Previous Close 53.15 - 145.09 133.19 (Previous Close - 52 Week Low) STOCKLOW = 52 Week Low Stock price from 52-week low Stock price from 52-week high 150.6% -8.20% (Previous Close - 52 Week High) STOCKHIGH = 52 Week High STOCKLOW Stock price from 52-week low, Student VBA Function STOCKHIGH Stock price from 52-week High, Student VBA Function 150.6% =STOCKLOW(C28,C29) -8.20% ESTOCKHIGH(C28,C29) SIN 20 4.07 - )** ZON 105 We 30 N loputt Psadeve) -1002 5.00 put1 w.bonita Nuts where 2.N11C180 C2011021322022 - 16:31 1830524 CHESS241921-20150824-C207221$$2101 102PSCS24-022 77. Some AVA 22 53.15-145.00 Pt. This 2 price it can be front 001 999 9. Vower 12115 2. Previous Stock Price can be from 10.00 to $399.95 VBA should work for the 150N-233.1981153 Swipe VBA worlange 319-1450NV145.0 for photo STOCKLOW (Previous Close-52 Week Low) 52 Week Low CRE ve m Y? STOCKHIGH- Preous Close-52 Weed NEON) 52 Week High MWAMVAA VAN Sheet1 + Road V Stolewo) - Desde MOTORY wa 33 Manga where CHIC IS-SCHMURCIA 10. VM 535 Sprong OUVIR 1331 VISA FROCKLOW Prem Cleesweek Low 10 RUEVAS WE UN NOVAS VIA Chi SOLO SOCIO- 31 STOSOW 10000 Homework assignment (Build 5 VBA functions) 4. STOCKLOW (Current stock price from 52-week low as a percentage, Inputs: Previous Close, 52-week stock price range) Current stock price (1.e., Previous Close) as well as 52-week stock price range can be from $0.00 to $9.999.99 5. STOCKHIGH (Current stock price from 52-week high as a percentage, Inputs: Previous Close, 52-week stock price range) STOCKLOW (Previous Close - 52 Week Low) 52 Week Low STOCKHIGH = (Previous Close - 52 Week High) 52 Week High PSTDEV Probability 10% 20% 40% 20% 10% Value -30.00% PStdevo) = -10.00% 5.00% -1 (1-P)2 x Pi 12.00% 35.00% where f = 1 Pri 2.90% =@ExpValue(B18:B22.C18:C22) 16.21% =SQRT (B18*(C24-C18)^2)+(B19*(C24-C19)^2)+(B20*(C24-C20)^2)+(B21*(C24-C21)^2)+(B22*(C24-C22)^2)) 16.21% =PStdev(B18:B22.C18:022) Expected Value (r hat), Formula Portfolio Standard Deviation, Formula Portfolio Standard Deviation, Student VBA Function 52 Week Range Previous Close 53.15 - 145.09 133.19 (Previous Close - 52 Week Low) STOCKLOW = 52 Week Low Stock price from 52-week low Stock price from 52-week high 150.6% -8.20% (Previous Close - 52 Week High) STOCKHIGH = 52 Week High STOCKLOW Stock price from 52-week low, Student VBA Function STOCKHIGH Stock price from 52-week High, Student VBA Function 150.6% =STOCKLOW(C28,C29) -8.20% ESTOCKHIGH(C28,C29) SIN 20 4.07 - )** ZON 105 We 30 N loputt Psadeve) -1002 5.00 put1 w.bonita Nuts where 2.N11C180 C2011021322022 - 16:31 1830524 CHESS241921-20150824-C207221$$2101 102PSCS24-022 77. Some AVA 22 53.15-145.00 Pt. This 2 price it can be front 001 999 9. Vower 12115 2. Previous Stock Price can be from 10.00 to $399.95 VBA should work for the 150N-233.1981153 Swipe VBA worlange 319-1450NV145.0 for photo STOCKLOW (Previous Close-52 Week Low) 52 Week Low CRE ve m Y? STOCKHIGH- Preous Close-52 Weed NEON) 52 Week High MWAMVAA VAN Sheet1 + Road V Stolewo) - Desde MOTORY wa 33 Manga where CHIC IS-SCHMURCIA 10. VM 535 Sprong OUVIR 1331 VISA FROCKLOW Prem Cleesweek Low 10 RUEVAS WE UN NOVAS VIA Chi SOLO SOCIO- 31 STOSOW 10000 Homework assignment (Build 5 VBA functions) 4. STOCKLOW (Current stock price from 52-week low as a percentage, Inputs: Previous Close, 52-week stock price range) Current stock price (1.e., Previous Close) as well as 52-week stock price range can be from $0.00 to $9.999.99 5. STOCKHIGH (Current stock price from 52-week high as a percentage, Inputs: Previous Close, 52-week stock price range) STOCKLOW (Previous Close - 52 Week Low) 52 Week Low STOCKHIGH = (Previous Close - 52 Week High) 52 Week High