File talk:Price elasticity of demand and revenue.png

Spreadsheet

Here's the spreadsheet used to create the original graphs in a comma-delimited format. The arc elasticity formula was used:

"Units","Price","Elasticity","Total Revenue"
-0.5,51,,
0,50,101,0
0.5,49,99,24.5
1,48,32.3333333333333,48
1.5,47,19,70.5
2,46,13.2857142857143,92
2.5,45,10.1111111111111,112.5
3,44,8.09090909090909,132
3.5,43,6.69230769230769,150.5
4,42,5.66666666666667,168
4.5,41,4.88235294117647,184.5
5,40,4.26315789473684,200
5.5,39,3.76190476190476,214.5
6,38,3.34782608695652,228
6.5,37,3,240.5
7,36,2.7037037037037,252
7.5,35,2.44827586206897,262.5
8,34,2.2258064516129,272
8.5,33,2.03030303030303,280.5
9,32,1.85714285714286,288
9.5,31,1.7027027027027,294.5
10,30,1.56410256410256,300
10.5,29,1.4390243902439,304.5
11,28,1.32558139534884,308
11.5,27,1.22222222222222,310.5
12,26,1.12765957446809,312
12.5,25,1.04081632653061,312.5
13,24,0.96078431372549,312
13.5,23,0.886792452830189,310.5
14,22,0.818181818181818,308
14.5,21,0.754385964912281,304.5
15,20,0.694915254237288,300
15.5,19,0.639344262295082,294.5
16,18,0.587301587301587,288
16.5,17,0.538461538461539,280.5
17,16,0.492537313432836,272
17.5,15,0.449275362318841,262.5
18,14,0.408450704225352,252
18.5,13,0.36986301369863,240.5
19,12,0.333333333333333,228
19.5,11,0.298701298701299,214.5
20,10,0.265822784810127,200
20.5,9,0.234567901234568,184.5
21,8,0.204819277108434,168
21.5,7,0.176470588235294,150.5
22,6,0.149425287356322,132
22.5,5,0.123595505617978,112.5
23,4,0.0989010989010989,92
23.5,3,0.0752688172043011,70.5
24,2,0.0526315789473684,48
24.5,1,0.0309278350515464,24.5
25,0,0.0101010101010101,0

- RedWordSmith 03:44, Apr 2, 2005 (UTC)

Copied accross by Jarry1250 (talk) 15:09, 28 February 2010 (UTC)