Skip to main content

Starting Simulation in Excel


Steps for Starting Simulation in Excel


1. Generating randomness

In simulation most important work is to generate random ness. You can use inbuilt rand()function for the same. When you enter the formula =RAND() in a cell, you get a number that is equally likely to assume any value between 0 and 1. Thus, around 25 percent of the time, you should get a number less than or equal to .25; around 10 percent of the time you should get a number that is at least .90, and so on

2. In order to conduct discrete simulation you need to use values of a discrete random variable.

3. Excel's VLOOKUP function stands for vertical lookup helps to find specific information in large data tables such as an inventory list of parts or a large membership contact list.

Enter the data in the cells. Let the first column of data contains the part names (say B ) and the second column (column C) contains the price of each part.


Vlookup can be used

1.Click on cell B1 and type the title lets say Part Name.

2. Click on cell C1 and type the title Price.

Click on cell C2 - the location where the results

Click on the Formulas tab.

Choose Lookup & Reference from the ribbon to open the function drop down list. Just click on VLOOKUP in the list to bring up the function's dialog box. As you enter data into the four blank rows of the dialog box which will form the arguments for the VLOOKUP function. These arguments tell the function about the information we need and where it we are after and where it should be searched.
Labels:

Comments

Post a Comment

Popular posts from this blog

Inter-Organizational Value Chain

The value chain of   a company is part of over all value chain. The over all competitive advantage of an organization is not just dependent on the quality and efficiency of the company and quality of products but also upon the that of its suppliers and wholesalers and retailers it may use. The analysis of overall supply chain is called the value system. Different parts of the value chain 1.  Supplier     2.  Firm       3.   Channel 4 .   Buyer
Post a Comment
Read more
Advantages and Disadvantages of EIS Advantages of EIS Easy for upper-level executives to use, extensive computer experience is not required in operations Provides timely delivery of company summary information Information that is provided is better understood Filters data for management Improves to tracking information Offers efficiency to decision makers Disadvantages of EIS System dependent Limited functionality, by design Information overload for some managers Benefits hard to quantify High implementation costs System may become slow, large, and hard to manage Need good internal processes for data management May lead to less reliable and less secure data
1 comment
Read more

System Analysis and Design (SAD)

Introduction to System Analysis and Design (SAD) System are created to solve Problems. One can think of the systemsapproch as an organised way of dealing with a problem. In this dynamic world , the subject system analysis and design, mainly deals with the software development activities. This post include:- What is System? What are diffrent Phases of System Development Life Cycle? What are the component of system analysis? What are the component of system designing? What is System? A collection of components that work together to realize some objectives forms a system. Basically there are three major components in every system, namely input, processing and output. In a system the different components are connected with each other and they are interdependent. For example, human body represents a complete natural system. We are also bound by many national systems such as political system, economic system, educational system and so forth. The objective of the system demands tha...
37 comments
Read more