Please give an answer and explanation

Problem 2 1. Show that Var(]1 BEst) 2 1. 2. We will now verify that Var(f01 BEst) = 1 using simulations. Use Excel to generate 100 sample paths of the Brownian motion in the time interval [0,1] by following the following steps: (a) Partition the interval [0,1] into 100 small intervals each of length 0.01: it.) = 0,151 = 0.0Lt2 = 0.01, ' ' - Jun 2 1. (b) For each ti, generate a random number B\". = Bis1 + t,- t,-_1 1: NH), 1) where NH], 1) is the standard normal random variable. {(3) Compute the sum 3(a)) = 2:3: B_1(w)(Bi(w} Ba;l (w)) ((1) Repeat the above process 100 times to get 100 sample paths of the Brownian motion. Compute 5:1 2 ZEN-51w) 5'2 2 21.1326\") 100 l 100 l (e) Use the approximation Var\": deBs) m E[S'2] lE[ 2 m 3;; (5'02. Is your answer close to 1? Please submit your code in the .xlsx together with your answers