Question: Need help writing VBA code. Thanks in advance Create a spreadsheet application to help a user generate triangularly distributed random numbers that could be used

Need help writing VBA code. Thanks in advance

Need help writing VBA code. Thanks in advance Create a spreadsheet applicationto help a user generate triangularly distributed random numbers that could beused in simulations Create a worksheet named Introduction which has a textboxthat explains the basic operation of your application. Make sure this worksheet

Create a spreadsheet application to help a user generate triangularly distributed random numbers that could be used in simulations Create a worksheet named Introduction which has a textbox that explains the basic operation of your application. Make sure this worksheet is always displayed (activated) when the workbook is opened. Then complete the requirements below Requirements 1. Write a User Defined Function (UDF) to generate a random number based on a triangular distribution. The triangular distribution is a probability distribution that is commonly used in business spreadsheet simulations. It is literally triangularly shaped. There are three parameters to this distribution, labeled a, b and c. The parameters a and c are the minimum and maximum possible values respectively, and the parameter b is the most likely value (where you see the high point in the triangle). This is a simple distribution for people to understand, but it is not straightforward to generate random numbers for this distribution. The method is as follows: Calculate d b a c a) Generate a uniformly distributed random number u between 0 and 1 with VBA's Rnd function . If U

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 Databases Questions!