Calculate the intersection of supply and demand curve

A

Angus

How to calculate the intersection (price and quantity) of
supply and demand curves, which are drawn by equation (or
actual data of observation)?
 
B

Bernie Deitrick

Angus,

If you have two formulas, you set up the two formulas to refer to the same
input cell, and subtract them, and use Solver to set the result of the
subtraction to zero by manipulating the input cell.

If you have data, you need to fit a curve first.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weeks of Supply Calculation 1
Set up Supply and Demand chart with equilibrium price? 1
LINEST and Dynamic Regression 0
How do I create a demand supply curve in word? 1
Intersection of two curves 4
create manufacturing demand based on customer delivery 0
demand/supply curves 1
Supply and Demand Charting 2

Top