Solved: Customer Lifetime Value analysis assignment In this assignment, we wil

Question

Customer Lifetime Value analysis assignment In this assignment, we will try to analyze a business's point-of-sales data, determine their customers' CLV (customer lifetime value) and take decisions for the management. Access and analyze the transaction dataset provided. Answer the following questions. Provide charts when applicable. 1) State the basic descriptives from the dataset, including total and average number of customers, transactions and sales. (20 points) 2) Create a histogram and a boxplot of total sales amounts and transaction days. How are customers divided based on their spending patterns? (10 points) 3) Assume the company has an average of 15% variable cost for all the products. With the formula CLV-Sales-Cost, calculate the CLV for all the customers. (10 points) 4) The company wants to divide its customer groups into high, medium and low spenders. State a reasonable method that you can apply to divide the customers into three spending groups. Any reasonable method is acceptable (20 points) 5) Once you have divided the customers into three groups, calculate their average total sales per group. ((20 points) 6) The company is planning to lunch an advertising campaign for the three groups of customers. Advertising budget should not be more than 30% of lifetime value of customers. How much the company should spend in advertising in per person and in total for the three groups of customers? (20 points). Paste your R code, and upload the file on Canvas as one file.