1 / 20

EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering

EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering. IENG 4 6 1 System Modeling and Simulation Course Fall 2012-2013 Laboratory. Open Microsoft office> Microsoft Excel File> New> Blank Workbook. Normal Distribution function.

emera
Download Presentation

EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering IENG461System Modeling and Simulation Course Fall 2012-2013 Laboratory

  2. Open Microsoft office> Microsoft Excel File> New> Blank Workbook

  3. Normal Distribution function Formula: =NORM.DIST(x,mean,standard_dev,cumulative) NORM.DIST gives the probability that a number falls at or below a given value of a normal distribution. The percentage of women less than or equal to 68 inches is: =NORM.DIST(68, 65.5, 2.5, TRUE) = 84.13% Formula: =NORM.INV(probability,mean,standard_dev,) NORM.INV is the inverse of the NORM.DIST function. It calculates the x variable given a probability. How tall would a woman need to be if she wanted to be among the tallest 75% of American women? =NORM.INV(0.25, 65.5, 2.5) = 63.81 inches

  4. NORMDIST FUNCTION for Probability Formula: =NORM.DIST(x,mean,standard_dev,cumulative)) Normal Distribution function Example1:

  5. Write the formula in B4 Normal Distribution function

  6. Enter Normal Distribution function

  7. Normal Distribution function Example2:

  8. Write the formula in B5 Normal Distribution function

  9. Enter Normal Distribution function

  10. Simulate standard random normal variable Formula: =NORM.DIST(RAND(),mean,standard_dev,cumulative) Example3:

  11. Enter and drag

  12. Simulate standard random normal variable Formula: =NORM.INV(RAND(),mean,standard_dev) Example4:

  13. Enter and drag

  14. Simulate uniform random variables Formula: =RAND()*(b-a)+a Example5:

  15. Enter and drag

  16. Simulate exponential random variables Formula: =EXPONDIST(x,lamba,cumulative) For random x : =EXPONDIST(RAND(),lamba,cumulative) Example6:

  17. Enter and drag

  18. Another way! First File > Options > Add-Ins > Analysis Tool Pack > Go> Ok Now : Data> Data Analysis> Random Number Generation>ok

  19. Another way! File > Options > Add-Ins > Analysis Tool Pack > Go> Ok Now : Data> Data Analysis> Random Number Generation>ok You can choose the distribution and fill the blanks easily.

  20. The End

More Related