From the course: Data Analytics for Pricing Analysts in Excel

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Price discrimination with multiple variables

Price discrimination with multiple variables - Microsoft Excel Tutorial

From the course: Data Analytics for Pricing Analysts in Excel

Start my 1-month free trial Buy for my team

Price discrimination with multiple variables

“

- [Narrator] I'm in the 03_06_Begin Excel file. Alright, now we've previously looked at a couple of different examples of price discrimination and found that it didn't make sense for companies to be engaging in it. They still wanted to optimize their prices but price discrimination just wasn't going to help them to increase their profitability. But we'd also been looking at only a single variable. In this case, we want to look at a couple of different variables. Let's pretend we're looking at a television manufacturer. They have a couple of different characteristics of their product that people care about, TV screen size and resolution, for example. This is typical in the real world, right? There's probably more than one product characteristic for most products out there the customer cares about. So we now have essentially a company that's looking at six different possible products. They have large, medium, and small…

Contents