Question

The weight of football players is normally distributed with a mean of 200 pounds and a variance of 25 pounds. What is the probability of players weigh between 160 and 240 pounds? Write your answer in terms of excel formula and explain each term of the excel formula.

Answer 1

Soltion:

Given that:

mean = = 200 pounds

variance = 25 pounds

standard deviation = = = 5 pounds

P( 160 < x < 240 ) = P ( x< 240) - P ( x< 160)

P ( x< 240) = open excel sheet , select cell put equal to NORMDIST(240,200,5,240) then enter.

P ( x< 240) = 1

P ( x< 160) = select cell put equal to NORMDIST(240,200,5,240) then enter

P ( x< 160) = 0

P( 160 < x < 240 ) = 1 - 0

P( 160 < x < 240 ) = 1