Refer to the data in the Excel file “Cereal Data” that is posted on our course’s Moodle page.

a) Create a table with the values in a probability mass function and cumulative distribution function for the variable “Calories”.

b) Using Excel, graph your results from the tables in part (a) above. Hint: Refer to the online session “Excel Session 1” posted on Moodle.

c) What is the probability that a box from this population contains less than 100 calories per serving?

d) What is the probability that a box from this population contains between 90 and 110 calories per serving?

e) What is the probability that a box from this population contains more than 120 calories per serving?