Simulating Normal Random Variables模拟正常的随机变量.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 Tools/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 Ex. Suppose X is a normal random variable whose mean is 140 and standard deviation 18. Find a 90% confidence interval for sample mean for samples of size 6 of the random variable X. Simulating Normal Random Variables Soln: Simulating Normal Random Variables Ex. Generate a fixed sample of data containing 1000 samples of size 6 each, where the values in the sample represent final exam scores and have a normal distribution with a mean of 140 and a standard deviation of 18. Simulating Normal Random Variables Soln: Simulating Normal Random Variables Ex. For the 1000 samples created in the previous example, find the sample mean for each. Then use the DCOUNT function to determine how many of the 1000 sample mean values lie within the 90% confidence interval. Soln: Approximately 90% of the values should lie within th