Simulating Normal Random Variables - Homepage Arizona 模拟正常的随机变量的亚利桑那州-主页.ppt

Simulating Normal Random Variables Simulation can provide a great deal of information about the behavior of a random variable Simulating Normal Random Variables Two types of simulations (1) Generating fixed values - Uses Random Number Generation (2) Generating changeable values - Uses NORMINV function Simulating Normal Random Variables Fixed Values Random Number Generation is found under Data/Data Analysis Values will never change Useful if you need to show how your specific results are tabulated Simulating Normal Random Variables Sample: Number of columns Number of rows Type of distribution Mean Standard Deviation (Leave blank) Cell where data is placed Simulating Normal Random Variables Ex. Generate a fixed sample of data containing 25 values that has a normal distribution with a mean of 13 and a standard deviation of 4.6 Simulating Normal Random Variables Soln: Simulating Normal Random Variables Ex. Generate a fixed sample of data containing 30 values in cells A1:F5 that has a normal distribution with a mean of 81 and a standard deviation of 21 Simulating Normal Random Variables Soln: Simulating Normal Random Variables(NORMINV-used in Project 2 Changeable Values NORMINV function Values will change by pressing F9 or by setting calculation in automatic mode Useful if you want several samples to average (eliminates a small number of poor values) Simulating Normal Random Variables NORMINV will be used to run simulations for the project Sample data looks similar to Random Number Generation sample data Difference is that values can change by pressing F9 Simulating Normal Random Variables Sample: - Any number between 0 and 1 (Use RAND( ) for random values) - Mean - Standard Deviation Simulating Normal Random Variables Ex. Generate a changeable sample of data containing 30 values in cells A1:F5 that has a normal distribution with a mean of 81 and a standard deviation of 21 Simulating Normal Random Variables Soln: Normal, Cal