Answered step by step
Verified Expert Solution
Link Copied!

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.....)

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OpenStack Trove

Authors: Amrith Kumar, Douglas Shelley

1st Edition

1484212215, 9781484212219

More Books

Students also viewed these Databases questions

Question

=+ How well do you think you could do your job?

Answered: 1 week ago