Normal Distribution

Normal Distributions and Excel Tip Sheet incident 1 You argon sounding for a chance between 0 and a value x (below the x value). good character: A normal distribution with a mean of 15, a timeworn deviation of 3, and you be feel for the luck of less(prenominal) than 10. Use the NORMDIST bureau: X = 10 Mean = 15 modular Dev = 3 cumulative = 1 state: .0478. agency 2 You ar expression for a opportunity that is above the x value. event: A normal distribution with a mean of 15, a standard deviation of 3, and you are looking for the probability of more than than 17. Use the NORMDIST function: X = 17 Mean = 15 Standard Dev = 3 accumulative = 1 The probability from Excel is .7475. Since you are looking for a probability above the x value, you set off .7475 from 1. Answer = .2525. Situation 3 You are looking for the probability between dickens x values. Example: A normal distribution with a mean of 15, a sta ndard deviation of 3, and you are looking for the probability of universe between 13 and 16. Use the NORMDIST function twice: X = 13 Mean = 15 Standard Dev = 3 accumulative = 1 Probability from Excel: .2525. X = 16 Mean = 15 Standard Dev = 3 Cumulative = 1 Probability from Excel: .6306.

Since you are looking for the probability between the two x numbers, you subtract the smaller probability from the larger probability. Answer: .6306 - .2525 = .3781. Situation 4 In this stead you are working with a taste. Example: For a sample of 20, find the probability of less than 14 when you beget a normal distribution with a mean of 15 and a standard deviation of 3. First you find the standard error. ! reflexion: ? / ?n Here we have 3/?20 = .6708. right off you can use the NORMDIST function. X = 14 Mean = 15 Standard Dev = .6708 - - - > Did you plug-in that the standard error is used instead? Cumulative = 1 Answer: .0680. Situation 5 In this short letter you know the probability and are...If you loss to get a adequate essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay