Q3. (A) Based on the data in the Excel file Consumer Transportation Survey, construct tables for the

probability mass function and cumulative distribution function for the random variable Number of

Children. [HINT: Use the FREQUENCY function to summarize the variable, then calculate the relative

frequency (probability mass function) and cumulative relative frequency (Cumulative distribution

function)].

(B) What is the probability that an individual in the survey has exactly two children? P(X=2)

(C) What is the probability that an individual has less than two children? P(X<2)

(D) What is the probability that an individual has no more than two children? P(X<=2)

(E) What is the probability that an individual has at least two children? P(X>=2)

(F) What is the probability that an individual has more than two children? P(X>2)

probability mass function and cumulative distribution function for the random variable Number of

Children. [HINT: Use the FREQUENCY function to summarize the variable, then calculate the relative

frequency (probability mass function) and cumulative relative frequency (Cumulative distribution

function)].

(B) What is the probability that an individual in the survey has exactly two children? P(X=2)

(C) What is the probability that an individual has less than two children? P(X<2)

(D) What is the probability that an individual has no more than two children? P(X<=2)

(E) What is the probability that an individual has at least two children? P(X>=2)

(F) What is the probability that an individual has more than two children? P(X>2)