Hey,

Can someone please help with these business statistics questions?

I'm so lost.

Thank you :)

B33 X V fx A B C D E Name Manufacturer Calories N Puffed_Wheat Quaker Oats 50 3 Muesli_Raisins,_Dates,_&_Almonds Other 150 A 100%_Bran Nabisco 70 5 Grape-Nuts Other 110 6 Lucky_Charms General Mills 110 Maypo Other 100 8 Apple_Cinnamon_Cheerios General Mills 110 9 Almond_Delight Other 110 10 Multi-Grain_Cheerios General Mills 100 11 Quaker_Oatmeal Quaker Oats 100 12 Product_19 Kellogs 100 13 Frosted_Mini-Wheats Kellogs 100 14 Smacks Kellogs 110 15 Raisin_Bran Kellogs 120 6 Cinnamon_Toast_Crunch General Mills 120 17 Puffed_Rice Quaker Oats 50 18 Corn_Flakes Kellogs 100 19 Nutri-Grain_Almond-Raisin Kellogs 140 20 100%_Natural_Bran Quaker Oats 120 21 Wheaties_Honey_Gold General Mills 110 22 23 24Question 1 Not yet saved Marked out of 3.00 \\V Flag question Question 2 Not yet saved Marked out of 2.00 \\V Flag question A healthy breakfast can make or break your day. A dietitian at MQ hospital suggested that the calories in breakfast cereals should be 93 calories per cup. It is assumed that calories in breakfast cereals are normally distributed with a mean of 93 calories per cup and a standard deviation of 4 calories per cup. We surveyed the cereal preferences of 20 STAT1250 students and recorded the nutrition content. Download and open the survey data Cereal calories.xlsx file. Use these data to test the dietitian's belief. Keep your answers to 3dp 1. (1 mark) What is the sample mean for calories in breakfast cereals obtained from the student survey? = 2. (1 mark) What is the Absolute value of the test statistic for this hypothesis test? = 3. (1 mark) What is the corresponding Pvalue for testing the dietitian's belief? (2 mark) Without calculating the 95% confidence interval for calories in breakfast cereals. Based on the test statistic and the pvalue calculated from the survey data, do you think the dietitian's belief is located inside the confidence interval? (Hint: write your p value here and briefly explain your answer.)