pricing model

November 11, 2009

A Complex Pricing Model Made Easy by Excel (part 2)

Curtis Seare Excel, Pricing Analytics Excel, Pricing Analytics, pricing model

We are now ready, having performed a historical analysis in part 1 of this post, to create a useful system for pricing. Depending on how comfortable you are with statistics and mathematical operations with standard deviations, you may or may not understand why the excel formulas are set up the way that they are. A full explanation of the mathematics…

November 10, 2009

A Complex Pricing Model Made Easy by Excel (part 1)

Curtis Seare Excel, Pricing Analytics averageif, Excel, pricing model, stdev if

Pricing is perhaps one of the hardest aspects of marketing to get right. And even though it’s impossible to keep control over and measure all of the variables involved, using analytics can help you track and predict enough of those variables so you can set the price where it needs to be. Here, we will outline an example of how…