Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help writing VBA code for the Triangular Function , then get the information from the user by creating a simple worksheet where the arguments
Need help writing VBA code for the Triangular Function, then get the information from the user by creating a simple worksheet where the arguments needed by the Triangular function can be typed into the worksheet by the user without the use of MsgBox, and InputBox. ( use cell style,turn off screen updating, protect the worksheet after.....)
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started