Analyze your results from the causation and correlation exercise posted in this week’s D2L module and then prepare a short posting (no more than 200 words) covering the variable sets and de
Analyze your results from the causation and correlation exercise posted in this week's D2L module and then prepare a short posting (no more than 200 words) covering the variable sets and describing their relationship and quality. In addition, provide at least one recommendation for Magic Foods company to address their sales issue(s) given your chosen variable set.
Data
| Territory No. | No. of Stores (in hundred) | No. of Dealers (in hundred) | No. of Popular Brands | Population (in thousand) | Sales (in $mil) | Dependent,Indepenent Variables | Pearson's Correlation Coefficient r | Coefficient of Determination R2 (Quality) | Relationship | |
| 1 | 8 | 7 | 12 | 71 | 10 | Sales & Population | 0.9746 | 94.98% | Very Strong Positive Relationship | |
| 2 | 6 | 6 | 13 | 59 | 8 | Sales & No. Stores | 0.00% | |||
| 3 | 23 | 5 | 12 | 135 | 45 | Sales & No. Pop Brands | 0.00% | |||
| 4 | 29 | 29 | 14 | 149 | 58 | Sales & No. Dealers | 0.00% | |||
| 5 | 6 | 12 | 13 | 70 | 10 | Sales & Territory No. | 0.00% | |||
| 6 | 4 | 3 | 11 | 45 | 5 | |||||
| 7 | 9 | 17 | 13 | 58 | 12 | |||||
| 8 | 18 | 45 | 2 | 148 | 56 | |||||
| 9 | 15 | 28 | 9 | 103 | 25 | |||||
| 10 | 13 | 29 | 9 | 115 | 29 | |||||
| 11 | 16 | 29 | 3 | 145 | 52 | |||||
| 12 | 18 | 20 | 4 | 139 | 48 | |||||
| 13 | 17 | 35 | 3 | 146 | 51 | |||||
| 14 | 8 | 8 | 16 | 68 | 9 | |||||
| 15 | 7 | 14 | 13 | 73 | 11 | |||||
| 16 | 10 | 20 | 11 | 85 | 21 | |||||
| 17 | 2 | 2 | 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 | 31 | 9 | 123 | 30 | |||||
| 24 | 14 | 26 | 13 | 102 | 26 | |||||
| 25 | 18 | 52 | 6 | 133 | 42 | |||||
| 26 | 5 | 15 | 12 | 58 | 6 | |||||
| 27 | 11 | 19 | 12 | 80 | 20 | |||||
| 28 | 10 | 15 | 8 | 114 | 28 | |||||
| 29 | 15 | 10 | 4 | 140 | 50 | |||||
| 30 | 17 | 55 | 5 | 134 | 46 |
Sales vs Population
Sales (in $100000) vs. Population (in Thousands)
Sales (in $mil) 71 59 135 149 70 45 58 148 103 115 145 139 146 68 73 85 56 68 67 62 70 100 123 102 133 58 80 114 140 134 10 8 45 58 10 5 12 56 25 29 52 48 51 9 11 21 4 18 9 8 19 24 30 26 42 6 20 28 50 46 8 6 23 29 6 4 9 18 15 13 16 18 17 8 7 10 2 7 9 7 8 16 15 14 18 5 11 10 15 17
Population
Sales
,
Causal Analysis Instructions
Magic Foods – Case Study
Case Description
Magic Foods is a leading manufacturer of pickles, spices, pastes and instant mixes. With quality products and customer satisfaction, the company maintains a leading position in the processed food market in a number of regions. However, very recently, the company has witnessed an increase in competition resulting in a decrease of sales. Company leadership wants to know the critical factors driving sales and what should the company focus on to be able to increase sales.
Generally, the company would like to know how many potential customers are in their market space, how can they be reached and how fierce is the competition? However, the ultimate measure of performance is sales. As a result, the company collected data on:
a. Last year sales in various regions
b. Population in each region
c. Number of food stores in each region
d. Number of Magic Food’s dealers in each region
e. Number of popular competitor brands of similar products sold in each region
Instructions
You may work with other students in this course section. First, conduct necessary calculations and scatter plot visualizations to address parts below using the provided Excel spreadsheet model with data. Use the Excel spreadsheet model to determine the relationships between all of the data using Correlation Analysis (aka Causal Analysis). The first relationship has been calculated and you are to complete the correlation coefficients (r) and coefficient of determination values (R2) for each of the remaining variables. The correlation coefficient is to be calculated using the Excel CORREL function. The coefficient of determination (R2) is the squaring of the correlation coefficient (r). The dependent variable is the objective measure (sales) and the independent variables are the population, No. of stores, No. of dealers, No. of competitive brands and the region number.
Finally, prepare a short response (1-2 paragraphs, not to exceed 200 words) for this week’s discussion describing the relationships of each correlated set – in terms of strength and polarity (positive or negative) using the r coefficient. The r coefficient is always shown using a leading 0 with at least 3 decimal places – example: 0.9746 or -0.9748. Then, describe the proportional quality of the relationships using the correlation of determination R2 (r squared) as a percent with 2 decimal places – example 94.98%. Finally, which variable best describes the impact on Sales?
1
image1.png
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
