# discussion

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.

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

## 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 17Population

Sales

0 replies