Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help writing VBA code for the following : Create a spreadsheet application to help a user generate triangularly distributed random numbers that could be

Need help writing VBA code for the following :

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

Sql++ For Sql Users A Tutorial

Authors: Don Chamberlin

1st Edition

0692184503, 978-0692184509

More Books

Students also viewed these Databases questions

Question

discuss the problem of compulsive sports gambling.

Answered: 1 week ago