Spreadsheet: Marketing Campaign of Fast-food New Menu
Category:
Food & Beverage Business
Background:
A fast-food chain plans to add a new item to its menu.
This company is still undecided between the three possible marketing campaigns for promoting the new product.
In order to determine which promotion has the greatest effect on sales, the new item is introduced at locations in several randomly selected markets.
Analysis Work Path:
- Data Cleaning
- Pivot Table
- VLOOKUP and XLOOKUP
- Descriptive Statistics
- Hypothesis Testing
- Correlation Analysis
- Insights and Recommendations