Hi, I need help with this project is based on applying descriptive models.

I need to answer these questions based on the data that I attached in the photos. Also, I need to Conduct necessary calculations and visualizations to answer the questions.I need to Submit Excel spreadsheet(s) with calculations/ visualizations to the assignment. You may submit additional Excel spreadsheets if you feel they are necessary to support your answers

Question #1: I need to prepare a business memo to report and discuss your findings on this case.

Question #2: Define a problem statement which reflects the challenge facing Magic Foods leadership.

Question #3: Apply descriptive modeling to analyze relationships between company sales and all predictor variables.Discuss the results of your analysis, implications for future data analysis.Illustrate your answer with appropriate statistics and visualizations.Provide recommendations for the Magic Foods management.

**Conduct necessary calculations and visualizations to answer the questions.Submit your Excel spreadsheet(s) with calculations/ visualizations to the assignment dropbox before the posted deadline.You may submit additional Excel spreadsheets if you feel they are necessary to support your answers

Very grateful for the help!

Territory No. of Shops No. of Dealers No. of Popular | Population (in Sales (in No. (in hundred) (in hundred) Brands thousand) $mil) Correlation 8 7 12 71 10 Sales & Population 0.9745651 6 Strong positive relationships 6 13 59 8 Sales & Stores 0.9136736 19 36 6 135 Strong positive relationships, although weaker than the relationships btw Sales &Population 45 19 49 2 149 58 6 12 13 70 10 4 3 11 45 5 9 17 13 58 12 18 45 148 56 15 28 103 25 13 29 115 29 11 16 40 3 145 52 12 18 38 4 139 48 13 17 42 3 146 51 14 8 8 16 68 9 15 7 14 13 73 11 16 10 20 11 85 21 17 IN IN 14 56 4 18 7 18 14 68 18 19 9 9 14 67 9 20 7 4 14 62 8 21 8 19 13 70 19 22 16 21 16 100 24 23 15 30 9 123 30 24 14 26 13 102 26 25 18 31 6 133 42 26 5 5 12 58 6 27 11 19 12 80 20 28 10 27 114 28 29 15 39 140 50 30 17 35 5 134 46Sales 50 30 20 10 Sales [in $100000) vs. Number of Stores [in hundreds) 10 12 14 Numner of Stores 16 1!} 20 _| Sales (in $100000) vs. Population (in Thousands) 70 60 50 40 Sales 30 20 10 30 50 70 90 110 130 150 170 Population