Question 1 (40 points):
Imagine that you are approached by a chained apparel shop where it would like to know more about its customers. To this end, you are provided with the 'Apparel_Chain.csv' dataset (available on my.wbs). The dataset has one-year information on customers of the respective chained apparel shop who bought products in-store and online. The dataset includes the following list of variables, collected via loyalty card of their customers:
Variable Name |
Description |
ID |
ID of the customer |
age |
age of the customer |
income |
income of the customer |
single |
"yes" if the customer is single, "no" otherwise |
distance |
distance traveled to the shop (in Miles) |
service.sat |
overall satisfaction score of the customer from the shop (1 – 10, where 10 is extremely satisfied) |
visit.on |
number of online visits |
transa.on |
number of online transactions |
spend.on |
£ spent online |
transa.off |
number of offline transactions (i.e., visiting the shop) |
spend.off |
£ spent offline |
The marketing department is now asking you to answer the following specific research questions by analyzing the dataset provided:
A. Find the number and the portion (i.e., %) of single customers (5 points). B. Draw a boxplot for 'age' and interpret your boxplot (5 points).
IB9JB0
C. Draw a histogram for the overall satisfaction score of respondents. Interpret your histogram (including a discussion about the mean, standard deviation, and the number of observations) (5 points).
D. Draw a scatterplot for the following variables and interpret your plots: (15 points)
1. The number of online visits by the customer andthe amount (i.e., in £) spentonline. 2. The number of online visits by the customer and the distance from the shop.
3. Thenumber of onlinevisits by thecustomerandthe amount(i.e., in £)spentoffline. E. Find the correlation between the following variables and interpret your results: (10
points)
1. The number of online transactions by the customer andthe amount (i.e., in£) spent online.
2. Income of the customer and the number of offline transactions.
Notes that you should consider in your answer:
Include your R code and its respective results in your solution.
Make sure you clearly explain, justify, and detail all the assumptions and steps in your solution. These might include data cleaning (e.g., dropping variable(s), observation(s), changing type of variable(s), etc.) or any other assumptions or steps.
Carefully and completely interpret your results.
Critically build all your arguments and implications (based on all your results) for the chained apparel shop management team.
The only part NOT counted in your word limit is your output from the RStudio’s console. Everything else (e.g., your code, tables, and words in your figures) counts.
Question 2 (35 points):
Imagine that a friend of yours runs a family restaurant. Your friend is now asking for your advice on their family business. Your friend puts together the information about a sample of their customers, including the following list of variables:
Variable Name |
Description |
amount |
the value (in £) of the customer’s current food |
satisfaction |
overall expressed satisfaction with the food (0 – 100, where 0 is extremely dissatisfied) |
satisfaction.serv |
overall expressed satisfaction with the service (0 – 100, where 0 is extremely dissatisfied) |
credit |
contains information about the payment; whether the payment was done by credit card or not, or not available |
online |
whether the booking was made online or not |
day |
day of the week that the customer dined-in |
item |
number of items in the current order |
last_amount |
the value (in £) of the last dine |
discount |
whether the customer received a discount (=1) for the current booking or not (=0) |
Based on the dataset 'iDine.csv,' answer the following questions:
A. Try to help the family business of your friend by finding what drives the customer’s current food value (hint: run a linear regression, where your dependent variable is: 'amount') (20 points).
B. Based on the provided dataset and your results in part A, evaluate the following statement by your friend: "To increase our revenue, I think we should provide more discount to our customers" (15 points).
Notes that you should consider in your answer:
Include your R code and its respective results in your solution.
Make sure you clearly explain, justify, and detail all the assumptions and steps in your solution. These might include data cleaning (e.g., dropping variable(s), observation(s), changing type of variable(s), etc.) or any other assumptions or steps.
Carefully and completely interpret your results (including all your coefficients) and link them to your suggestions.
Critically evaluate the implications (based on all your results) for the family business. Make sure that you use specific and concrete examples in your solution.
The only part NOT counted in your word limit is your output from the RStudio’s console. Everything else (e.g., your code, tables, and words in your figures) counts.
Question 3 (25 points):
Choose an online music platform (of your choice):
A. Briefly describe the platform and its services (5 points).
B. Identify and evaluate how the platform can leverage 'marketing analytics' in its activities to create value for itself and its customers (10 points).
C. Critically discuss other opportunities (than those you discussed in part B) that can provide the focal platform with delivering (even more) value to itself and its customers (10 points).
Note that your answer (including arguments, discussions, recommendations, etc.) must be realistic, coherent, and logical.
https://apaxresearchers.com/storage/files/2023/04/01/9667-bh4_07_31_20_l2-workshop.pdf
https://apaxresearchers.com/storage/files/2023/04/01/9667-XWX_07_31_11_l4-workshop.pdf
https://apaxresearchers.com/storage/files/2023/04/01/9667-Ghr_07_31_02_l6-workshop.pdf
https://apaxresearchers.com/storage/files/2023/04/01/9667-6W9_07_30_53_l1-workshop.pdf
https://apaxresearchers.com/storage/files/2023/04/01/9667-LbQ_07_30_44_l3-workshop.pdf
https://apaxresearchers.com/storage/files/2023/04/01/9667-PJf_07_30_35_l7-workshop.pdf
This Question Hasn’t Been Answered Yet! Do You Want an Accurate, Detailed, and Original Model Answer for This Question?
Copyright © 2012 - 2024 Apaxresearchers - All Rights Reserved.