Includes Index.

Introduction
I Using Excel to Summarize Marketing Data
1 Slicing and Dicing Marketing Data with PivotTables
2 Using Excel Charts to Summarize Marketing Data
3 Using Excel Functions to Summarize Marketing Data
4 Estimating Demand Curves and Using Solver to Optimize Price
5 Price Bundling
6 Nonlinear Pricing
7 Price Skimming and Sales
8 Revenue Management 9 Simple Linear Regression and Correlation
10 Using Multiple Regression to Forecast Sales
11 Forecasting in the Presence of Special Events
12 Modeling Trend and Seasonality
13 Ratio to Moving Average Forecasting Method
14 Winters Method
15 Using Neural Networks to Forecast Sales
16 Conjoint Analysis
17 Logistic Regression
18 Discrete Choice Analysis
19 Calculating Lifetime Customer Value

Marketing Analytics:Data-Driven Techniques with Microsoft Excel shows business managers and data analysts how to use a relatively simple tool--Excel---to analyze useful business information using powerful analytic techniques.This comprehensive book shows how to use each technique to solve a practical businenss problem and achieve optimum marketing results.