
Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Fast Food Chain Company- EDA & Statistical Measurement
Project type
Food Supply Chain- EDA & Statistical Measurement
The What?
The business is a fast food chain company. They want to do promoting about new product and havent decided yet which campaign has the greatest effect on sales.
The How?
We can use numerical data to extract insight by using descriptive statistics, we can use categorical column to provide the characteristic insight.
INSIGHTS
- Most of the market size is medium size at 58,39%, the second one is large with 30,66%, and with small size only 10,95%
-Most of the age of market is around 1 year at 14,60%, and it is only 0,73% at age more than 25 years
- From One of three promotions that were tested, the second and third promotion are high aroun 34,31% respectively, Whereas the first promotion only 31,29%
the week of promotion increased significantly by 10% from each week
The number of sales remain stable at 0,18%
From the p-value we can conclude that there is a significant linear relatioship between independent variable (Promotion, market size and location) and dependent variable (sales)
Campaign that brings the greatest effect on sales
- From One of three promotions that were tested, the second and third promotion are high around 34,31% respectively, Whereas the first promotion only 31,29%
- Based on the correlation, we can conclude that there is no multicollinearity
from the hypothesis testing, we can conclude that the correlation is valuable (reject H0) three variables there are market size, location, and age of store,
the aspect that has a strongest correlation to sales is market size