What's a simple way to create demand curves and other economic diagrams?

Question

I'm looking for either advice to doing this in Excel or another simple way using software.

Answer 1

Supply & Demand curves are basically look like" X"'s.

In Excel, make two columns: Supply & Demand (Column A & B)

Supply (A) should have a maximum value and decrease: Ie: 50, 40, 30, 20, 10, 0.: List these under Column "A" which you've titled "Supply"
Demand (B) should increase in number (start with zero): Ie: 0, 10, 20, 30, 40, 50.
-------------------------
Excel spread sheet looks like this:
Supply --- Demand
50 --- 0
40 --- 10
30 --- 20
20 --- 30
10 --- 40
0 --- 50

Then highlight all information and request a line graph.--- The information should look like an “X” when you’re done --- with an equalibrium (Price) of $25.00.

Answer 2

Using excel graph with p on the x axis
column a - fill with prices 0 to max value
column b - S= f(p) for linear dependence use S= constant x p so that S=0 when p=0
NOTE: for a model that assumes increasing returns to scale the dependence should be less than linear so p^b with b<1 would be more realistic
column c - D= g(p) for a linear dependence D=(large number) - constant x p
NOTE: If you have Utility curves for consumers (say Cobb Douglas) then find the formula for quantity purchases as a function of price algebraically and use that as your demand curve f(p)