Back to Templates
DATA ANALYSIS
Purchase Probability Calculator (NMS)
Spreadsheet to process Newton-Miller-Smith survey data into revenue curves.
LIVE PREVIEW
| Price Point | Definitely Buy (5) | Probably Buy (4) | Might Buy (3) | Wtd. Probability % | Exp. Revenue |
|---|---|---|---|---|---|
| $50 | 40 | 30 | 20 | 45% | $22,500 |
| $60 | 30 | 25 | 15 | 35% | $21,000 |
| $70 | 15 | 20 | 10 | 20% | $14,000 |
| -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- |
Instructions
- 1Input Counts: Enter raw survey responses.
- 2Assign Weights: e.g., Def Buy = 0.7 probability.
- 3Find Peak: Identify price with highest Exp. Revenue.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Convert 'Likert scale' survey responses into actual revenue forecasts.
Key Features
Weighting Logic: Adjust calibration.
Revenue Curve: Auto-plot.
Common Use Cases
Sales Forecasting: Budgeting.
Price Optimization: NMS Analysis.
Frequently Asked Questions
What weights to use?
70%/30%/10% is a conservative standard.