Identify the data type and the level of measurement for each of the two variables in the data file – Gender and Coffee Consumption: Descriptive Analytics Assignment, NUS, Singapore

Instructions:

Complete the assignment individually.
– Include the following details in your submission:

• Module Title, Assessment Type, Date of Submission, your Name

Convert the word document to pdf before submission.
– For all questions, unless otherwise stated, show all the steps leading to the final answers to avoid
any loss of marks.
– Excel is expected to be used to assist the calculation and generate output, unless otherwise stated.
– For PDF submission (45 marks), extracts of relevant Excel output should be included where
necessary.
– For Excel submission (5 marks), only relevant output should be remained in the worksheet, aslabelled by question.
– You will be assessed on

• the quality of your written communication, that is, clear explanation and correct use of statistical notation (5 marks), and
• the completeness of the whole assessment (5 marks).

Question 1 

(a) Identify the data type and the level of measurement for each of the two variables in the data file – Gender and Coffee Consumption.
(b) Use Excel to find the mean, median, standard deviation and interquartile range for Coffee Consumption (in kg). You may use Excel Data Analysis Tool to generate the descriptive statistics, or individual Excel function for each of the measures. Do not simply paste the raw output as your answers.
(c) Generate a histogram for the coffee consumption using 9 bins to clearly show the shape of the distribution. Include appropriate label to the axes. You may use either of the Histogram function – Data Analysis Tool or INSERT function.
(d) Using the answers in part (b) and part (c), describe the distribution of the coffee consumption in terms of shape, center and spread using appropriate measures.