Question: complete excel formulas, solutions, and answers please Question 1 50 Points Generate 50 random numbers using EXCEL. Use one EXCEL FILE and save it as
complete excel formulas, solutions, and answers please
Question 1 50 Points Generate 50 random numbers using EXCEL. Use one EXCEL FILE and save it as your SURNAME_LAB2 and rename each sheet as PROB1, PROB2, etc. (1) Using the midsquare method: Use Xo = 8798 (2) Using the mixed(linear) congruential method: Use Xo = 8798, a=53, c=17, m=10,000 (3) Using the multiplicative congruential method: Use Xo = 8798, a=53, c=0, m=10,000 (4) Using the additive congruential method (X8 to X57) Use X1 = 8798, X2 = 6727, X3 = 2846, X 4= 7594, X5 = 2121, X6 = 2427 X7 = 3185 m=10,000, n=7 (5) Using the quadratic congruence method: Use Xo = 8798, m=7921 Use the editor to format your
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
