Now we are almost finished. On the Results tab you will see four large and empty yellow cells in column I. For the topmost large cell, calculate the average absolute difference between the true beta and the estimated betas for your five different samples (A1-A5). Your formula should reference the cells directly, dont do any calculations manually.

1 true alpha true beta alpha estimate beta estimate true beta-beta estimate 3 0 0 0 1 1 1 Avg of true beta-beta estimate) for samples A1-A5 0 1 0 0 1 1 1 1 1 1 Avg of (true beta-beta estimate) for samples 81-85