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
complete excel formulas, solutions, and answers
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!