Write My Paper Button

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

Uncategorized

Home » Uncategorized » 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

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).
Buy Custom Answer of This Assessment & Raise Your Grades
Get A Free Quote

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.

Stuck with a lot of homework assignments and feeling stressed ?
Take professional academic assistance & Get 100% Plagiarism free papers
Get A Free Quote

The post 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 appeared first on Singapore Assignment Help.

Need help with your paper?

X
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?