Question: This must be done in excel. PLEASE EXPLAIN/SHOW YOUR WORK. Create a program that enables the user to com- pute random numbers from a Normal
Create a program that enables the user to com- pute random numbers from a Normal distribu- tion and graph the corresponding values. This program will ask the user to input the total number of random numbers to be generated, the mean and standard deviation of the distribution. The program will then compute the random values, and display user's input, the random values and the corresponding graph. Below we describe the sub procedures needed to complete this exercise: a. The InputData sub procedure asks the user to us 3. ment, ate- ding , and nt of hould t. input the total number of random numbers to be generated, the mean and standard de- viation of the distribution. This data is then displayed in the worksheet. ises. b. The RandomNr sub procedure generates and displays the random numbers in the worksheet. c. The Reset sub procedure clears the current d. The Graph sub procedure graphs the random e. The Main sub procedure alls the other sub- Place a button labeled "Random Values" on the worksheet. numbers generated routines in the appropriate order. es the ree rk- worksheet. Assign the Main sub procedure to this button
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
