Working with BIG Data, Data analysis using Excel 20 marks You are employed by a supermarket chain which has recently begun offering a new line of organic products. Senior management of the supermarket want to identify which customers are likely to purchase these products. They have asked you to analyse some existing data and make a recommendation to assist them with this task.

The supermarket has a customer loyalty program. As an initial buyer incentive plan, the supermarket provided coupons for the organic products to all of the loyalty program participants and collected data from their purchases, including whether these customers purchased any of the organic products.

Required

You need to perform an analysis to identify which customers are likely to purchase organic products. Its up to you to decide which data items are meaningful, you will need to play around or a while to build an understanding of how the patterns for each data item are playing out. You require to use charts to more accurately visualize the data patterns.

1. Once you have identified your target customers you require to prepare a brief report (maximum 300 words) suitable for senior management. Make sure you include a clear recommendation identifying which customers should be targeted as a priority for future promotions involving organic products. You need to justify your target recommendation by referring to the analytical results you obtained (10 marks).

2. You must incorporate three charts to visually illustrate the patterns you relied on when you selected your target customers (10 marks).

The ORGANICS data set is available through the LMS and contains 13 variables and more than 22,000 observations. The variables in the data set and a brief description of each are shown below (please refer to the next page).