Magic Foods, a leading manufacturer of pickles, spice pastes, instant mixes. Although Magic Foods keeps leading market positions in a number of regions, recently the company witnessed an increase in competition resulting in a decrease of its sales. Company leadership wants to know the critical factors driving the sales and on which the company should focus so that to be able to increase the sales the most.

Pt.1

Define a problem statement which reflects the challenge facing Magic Foods leadership.

Pt 2

A. Apply descriptive modeling to analyze relationships between company sales and all predictor variables (3 points): a. Calculate correlation coefficients of company sales and the predictor variables b. Construct scatter plots of company sales and the predictor variables c. Calculate correlation coefficients of the population and number of popular brands, number of shops and dealers d. Analyze the pivot table summarizing variable values for each cluster (clusters represent a group of regions with similar properties in terms of the sales, population, number of brands, shops and dealers; clusters were assigned using a descriptive data mining technique called cluster analysis)

pt.3 B. Discuss the results of your analysis. Illustrate your answer with appropriate statistics and visualizations (2.5 points). a. How the sales factors impact the company sales? b. What factors influence company sales the most? c. How population in the sales regions are related to the number of popular brands, number of shops and dealers? d. Describe the current sales strategy for each regional group (cluster). How effective in your opinion is the current sales strategy?

Pt.4 Provide recommendations for the Magic Foods management