You are asked to carry out a study on behalf of a business analytics specialised consultancy on a subsample of weekly data from Fresco Supermarket, one of the biggest in the UK$.$ Fresco$$s marketing management team wishes to identify trends and patterns in a sample of weekly data collected for a number of their loyalty cardholders during a $26-$week period. The data includes information on the customers$$ gender, age, shopping frequency per week and shopping basket price. Fresco operates two different types of stores $($convenience stores and superstores$)$ but they also sell to customers via an online shopping platform. The collected data are from all three different types of stores. Finally, the data provide information on the consistency of the customer$$s shopping basket regarding the type of products purchased. These can vary from value products to brands as well as the supermarket$$s own high$-$quality product series Fresco Top. As a business analyst you are required to analyse those data and make any necessary modifications in order to determine whether, for any single customer, it is possible to predict the value of their shopping basket.

The Fresco marketing management team is only interested in identifying whether the spending of the potential customer will fall into one of two possible groups including:

Low spender $($shopping basket value of $50$ or less$)$ and

High spenders $($shopping basket greater than $50)$

For the purpose of your analysis you are provided with the data set Fresco.xls $($i$.$e$.$ available via the Downloads accordion panel below$).$ You have to decide, which method is appropriate to apply for the problem under consideration and undertake the necessary analysis. Once you have completed this analysis, write a report for Fresco$$s marketing management team summarising your findings but also describing all necessary steps undertaken in the analysis. The manager is a competent business analyst himself$/$herself so the report can include technical terms, although you should not exceed five pages. Screenshots and supporting materials can be included in the appendix.

Requirements

After completing your analysis, you should submit a report that consists of two parts. Part A is a non$-$technical summary of your findings and Part B is a detailed report of the analysis undertaken with more details.

Part A

Part A: A short report for the Head of Fresco Marketing Management $(20$ per cent$).$ This should briefly explain the aim of the project, provide a clear summary and justification of the methods considered as well as an overview of the results.

Although the Head of Fresco$$s Marketing Management team who will receive this summary is a competent business analytics practitioner, the majority of the other team members have little knowledge of statistical modelling and want to know nothing about the technical and statistical underpinning of the techniques used in this analysis. This report should be no more than two sides of A$4$ including graphs, tables, etc. In this report, you should include all the objectives of this analysis, a summary of data and results as well as your recommendations $($if any$).$

Part B

Part B: A technical report on the various stages of the analysis $(80$ per cent$).$

The analysis should be carried out using the range of analytics tools discussed in the lecture. Write a short and concise report to explain the technical detail of what you have done for each step of the analysis.

The report should also cover the following information:

Any type of analysis that might be useful and check whether the main assumptions behind the analyses do not hold or cannot be

Give evidence of your understanding of the statistical tools that you are using. For example, comment on the model selection procedure and the coefficient interpretation, e$.$g$.$ comment on the interpretation of the logistic regression coefficients if such a method is used and provide an example of

Conclusions and explanation, in non$-$technical terms, of the main points