利用Excel进行统计分析-Chapter6-The Normal Distribution and Other Continuous Distributions.ppt

Statistics for ManagersUsing Microsoft? Excel 5th Edition Chapter 6 The Normal Distribution and Other Continuous Distributions Learning Objectives In this chapter, you will learn: To compute probabilities from the normal distribution. To use the normal probability plot to determine whether a set of data is approximately normally distributed. To compute probabilities from the uniform distribution. To compute probabilities from the exponential distribution Continuous Probability Distributions A continuous random variable is a variable that can assume any value on a continuum (can assume an uncountable number of values) thickness of an item time required to complete a task temperature of a solution height These can potentially take on any value, depending only on the ability to measure precisely and accurately. The Normal DistributionProperties ‘Bell Shaped’ Symmetrical Mean, Median and Mode are equal Location is characterized by the mean, μ Spread is characterized by the standard deviation, σ The random variable has an infinite theoretical range: -? to +? The Normal DistributionDensity Function The Normal DistributionShape The Normal DistributionShape The Standardized Normal Distribution The Standardized Normal Distribution The Standardized Normal Distribution: Density Function The Standardized Normal Distribution: Shape The Standardized Normal Distribution: Example The Standardized Normal Distribution: Example Normal Probabilities Normal Probability Tables Normal Probability Tables Finding Normal ProbabilityProcedure Finding Normal ProbabilityExample Finding Normal ProbabilityBetween Two Values Given Normal Probability, Find the X Value Second, convert the Z value to X units using the following formula. Assessing Normality It is important to evaluate how well the data set is approximated by a normal distribution. Normally distributed data should approximate the theoretical normal distribution: The normal distribution is bell shaped (symmetr