Write down the excel function for each of these questions

(1 mark) How many cereals are included in the file (n)? = Answer (3dp)

(1 mark) How many cereals have greater than 95 calories per serve (X)? = Answer (3dp)

(1 mark) What is the sample proportion,

, of cereals with greater than 95 calories per serve? Answer (3dp)

(2 mark) Assuming the normality condition is satisfied. What is the 95%

confidence interval for the population proportion of cereals that have greater than 95 calories per serve?

Lower bound = Answer (3dp)

Upper bound = Answer (3dp)