Please help me with assignment in Excel

Normal from Uniform

ChiSq from Normal

F from ChiSq

t from normal

lognormal from normal

Calculate V(X) | X~Bernoulli Calculate V(xbar) | xbar is mean of X

Normal from Uniform Take the sum of many simulated uniforms. Interpret that as a single simulation. Repeat the previous step to create many simulations that are sums of uniforms. Create a histogram of the result. ChiSq from Normal Take the sum of many squared standard normal simulations. Interpret that as a single simulation. Repeat the previous step to create many simulations that are sums of standard normals. Create a histogram of the result. F from Chisa Simulate 2 sets of china distributions . Divide each Chisq by its degree of freedom . Calculate the ratio of these two values . E. 8. Chisq1 / 1 1 / Chisq 2 / 1 2 Create a histogram of these ratios .t from normal Create a set of standard normal random variables. Create s set of chiSq random variables with 10 degrees of freedom. Divide each standard normal by a chiSq with 10 degrees of freedom. Create a distribution of the normals divided by chiSq's. \fCalculate V(X) | X~Bernoulli A Bernoulli random variable X is such that: X=1 with probability p X=0 with probability 1-p What is the variance of X? Show your calculations. Hint: V(X) = Summation( (X-E(X))? * P(X) )What is the variance of the average of a random variable X that is iid with variance of ?* V ( *bar ) ? Xbar = average of X xbar = Sum ( X; ) / n