In order to further understand the study, James determines to estimate the population mean consumption of coffee using the data obtained: Descriptive Analytics Assignment, NUS, Singapore

In a multicultural country like Singapore, coffee plays an important role in social interactions. People enjoy having a cup of coffee with friends or even business negotiations. James has been operating a premium coffee shop in the country. He has an intention to expand the shop into a coffee shop chain within the country. In order to understand the coffee culture in near future, he collected some information from a random sample of 150 coffee drinkers. The gender and annual coffee consumption (in kg) data are stored in the Excel data file Assignment Data T2’24 (Re-assessment).

Question 3

In order to further understand the study, James determines to estimate the population mean consumption of coffee using the data obtained.

NOTE: Round the mean and standard deviation you obtained in Q1(b) to 2 decimal places before using them to do the calculation here.
(a) Using Excel Data Analysis Tool, construct a 95% confidence interval estimate for the population mean coffee consumption. Show all your workings.(b) Interpret the interval obtained in part (a).
(c) Explain whether it is reasonable to say that the population mean coffee consumption is 2.6 kg.
(d) Using a significance level of 5%, test whether there is evidence to conclude that the population mean coffee consumption differ from 2.6 kg. Show all the steps in your manual working. No Excel is required.