Excel: Market Research Strategies
Offered By: LinkedIn Learning
Course Description
Overview
Leverage the power of Excel to become a more effective marketer. Learn how to use Excel to tackle product pricing, focus group response analysis, and more.
Syllabus
Introduction
- Performing marketing analytics in Excel
- What is product demand?
- Measuring product demand
- Organizing sales data
- Seasonality in product demand
- Moving averages and product demand
- Price elasticity and product demand
- Predicting demand for a new product
- Regressions for forecasting
- Using Excel for regressions
- Demand forecasting caveats
- Product pricing basics
- Products with pricing power
- Products without pricing power
- Price or volume? The big trade-off
- Price differentiation and wholesaling
- Advertising attribution and identity
- Hedonic shoppers and price
- A/B testing and Excel
- Online survey marketing research
- Interpreting survey results
- Forecasting propensity to buy
- Statistics with survey groups
- Regressions and survey data
- Purchase intent and price
- Cost-per-click and customer value
- Lifetime customer value
- Customer churn calculations
- Customer acquisition cost
- Waterfall charts and marketing variance
- Interpreting variance walk charts
- Applying Excel to market research
Taught by
Michael McDonald
Related Courses
Supply Chain FundamentalsMassachusetts Institute of Technology via edX Forecasting Models for Marketing Decisions
Emory University via Coursera Retail Fundamentals
Dartmouth College via edX Marketing Analytics
Indian Institute of Technology, Kharagpur via Swayam Decision Support System For Managers
NPTEL via Swayam