Coursework Assessment Brief
Section A: Assessment Brief and Requirements
You are a data analyst of an online wine retail shop. The CEO of your company wants to improve the current marketing strategy, and asked you to undertake a project on understanding the relationship between the customer’s wine consumption behavior and other traits. You are provided with some data from the marketing research team, and are expected to deliver some useful insight to the CEO based on the data.
Please download the Customer Personality Analysis Data (“marketing_data.xlsx”) from the course website and answer the following questions. NOTE: The data was adapted from the Customer Personality Analysis data on Kaggle (https://www.kaggle.com/imakash3011/customer-personality-analysis). Please note that the data we use for this exercise is modified from the original data, so please use the version provided on the course website. DO NOT directly download it from Kaggle. Below are the description of the variables:
• ID: Customer’s unique identifier
• Age: Customer’s age
• Income: Customer’s yearly household income (GBP)
• Years_Ed: Customer’s education level (total years of education)
• Family_Size: Customer’s household size
• Living_With: Customer’s marital status. 1 indicates the customer lives with a spouse/partner, 0 indicates otherwise.
• Total_Children: Number of children and teenagers in customer’s household
• Total_Kids: Number of children in customer’s household
• Total_Teens: Number of teenagers in customer’s household
• Spent_Wines: Amount spent on wine in last 2 years (GBP)
• Spent_Non_Wines: Amount spent on fruits, meat, fish, sweet, and gold in last 2 years (GBP)
• Spent_Fruits: Amount spent on fruits in last 2 years (GBP)
• Spent_Meat: Amount spent on meat in last 2 years (GBP)
• Spent_Fish: Amount spent on fish in last 2 years (GBP)
• Spent_Sweet: Amount spent on sweets in last 2 years (GBP)
• Spent_Gold: Amount spent on gold in last 2 years (GBP)
Please answer the questions below by analyzing the provided data. You can use Excel to complete this assignment, but using other software is allowed. For each question, please provide the key assumptions you made, the statistical methods you used, and the interpretation of your results. The report should be no more than 5 pages long (not including references/bibliography lists or appendices). It should be produced in a serif font, such as Times New Roman, size 12 and with single spacing.
Question 1.
Generate summary statistics of the data. Use at least one Table and/or Figure to support your analysis. Choose three variables that you find the most interesting, and discuss why.
Question 2.
a. A recent study shows that people’s socioeconomic status (such as income and education level) and their alcohol consumption are related.1 Your CEO wants to adapt this research finding in the marketing strategy. How would you advise him/her?
b. According to the 2021 winners of the Nobel prize in economics (and it is also generally believed), people with higher education tend to have higher incomes.2 Your CEO thinks this result will somehow affect his marketing strategy. How would you advise him/her? Does this affect the advice you provided in part a?
c. Recommend at least one marketing strategy based on your analysis above.
Question 3.
Your CEO likes your analysis. However, given the high marketing cost, s/he wants to only target a specific group of consumers. In particular, s/he suggests a targeting strategy based on the customer’s family status. How would you advise him/her?
Question 4.
a. After presenting your analysis to the group, you are given a comment from another data analyst that sometimes a linear model is not the best model to fit the data. How would you address his/her point?
b. After presenting your analysis to the group, the marketing research team raises a concern that collecting the information on the amount spent on each category (e.g., fruits, meat, fish, sweet, and gold) separately is costly and therefore, they are considering not collecting all, or at least part of, this information in the future. What would you advise?
Section B: Module Learning Outcomes covered in this Assessment
This assessment contributes towards the achievement of the following stated module Learning
Outcomes as highlighted below:
The following topics are covered:
• Central tendency and spread measures
• Basic probability theory, conditional probability and Bayes theorem
• Random variables and important distributions
• Normal distribution
• Sampling and confidence interval
• Hypothesis testing
• Regressions
Section C: How your work is assessed
Within each section of this assessment you may be assessed on the following aspects, as applicable and appropriate to this assessment, and should thus consider these aspects when fulfilling the requirements of each section:
• The accuracy of any calculations required.
• The strengths and quality of your overall analysis and evaluation;
• Appropriate use of relevant theoretical models, concepts and frameworks;
• The rationale and evidence that you provide in support of your arguments;
• The credibility and viability of the evidenced conclusions/recommendations/plans of action you put forward;
• Structure and coherence of your considerations and reports;
• Appropriate and relevant use of, as and where relevant and appropriate, real world examples, academic materials and referenced sources. Any references should use either the Harvard OR Vancouver referencing system (see References, Citations and Avoiding Plagiarism)
• Academic judgement regarding the blend of scope, thrust and communication of ideas, contentions, evidence, knowledge, arguments, conclusions.
• Each assessment requirement(s) has allocated marks/weightings. Student submissions are reviewed/scrutinized by and internal assessor and are available to an External
To help you assess the relative strengths and weaknesses of your submission please refer to UCL Assessment Criteria Guidelines, located at https://www.ucl.ac.uk/teaching-learning/sites/teaching-learning/files/migratedfiles/UCL_Assessment_Criteria_Guide.pdf
The above is an important link as it specifies the criteria for attaining 85% +, 70% to 84%, 60% to 69%, 50% to 59%, 40% to 49%, below 40%.
Sample Solution
