Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribedimage 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

Step: 3

blur-text-image

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

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions