In: Math
Normal probability distribution
Is a continuous distribution
Review the in-class Excel worksheet and list criteria under which it is appropriate to use the normal distribution in the calculation of probabilities
Review the Excel Normal Distribution video clip in the In-class Excel folder. The feature needs the mean and the standard deviation of the distribution under study. Use Excel to calculate the following Normal distribution probabilities:
Mean = 5ft, standard deviation = .7ft. The probability that a woman’s height is over 5.7 ft
Mean = 126 1bs, standard deviation = 10 lbs. The probability that a woman’s weight is less than 110 lbs
Think about real life work or daily applications. Describe a situation that could possibly framed as a Normal distribution problem for which we can calculate probabilities. Please summaries your revision perspective here
The normal distribution is the most important probability distribution in statistics because it fits many natural phenomena. For example, heights, blood pressure, measurement error etc.
Excel calculation : (step to calculate capital fi or P(z) is written in the excel sheet itself)
Calculation :
REAL LIFE EXAMPLE OF NORMAL DISTRIBUTION WHERE PROBABILITIES CAN BE CALCULATED : In this scenario of increasing competition, most parents, as well as children, want to analyze the Intelligent Quotient level. Well, the IQ of a particular population is a normal distribution curve; where IQ of a majority of the people in the population lies in the normal range whereas the IQ of the rest of the population lies in the deviated range. So the question can be if the IQ level follows normal distribution, what is the probability that a student has IQ > 70