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

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

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

CONCEPTUAL VIEW OF MIS

The concept is a blend of principles, theories and practices of management, information and system giving rise to a single product called MANAGEMENT INFORMATION SYSTEM . The concept of management gives high regard to the individual and his ability to use the information. MIS gives information through data analysis. While analyzing the information, it relies on many academic disciplines like management science, OR, organization behavior, psychology, etc. The foundation of MIS is the principles of management and its practices. MIS uses the concept of management control in its design and relies heavily on the fact that the decision maker is a human being and is a human processor of information. A MIS can be evolved for a specific objective it is evolved after systematic planning and design. It calls for an analysis of business, management views and policies, organization culture and the management style. The MIS,therefore relies heavily on systems theory.The systems theory offers soluti
Post a Comment
Read more