Use the Data to Construct Supply and Demand Curves (Need it in 1 day)
forlos.fgqilarf91
20160606042559supply_and_demand_example.xlsSilver Summary Chart
| Silver Supply and Demand | ||||||
| Year | Price Per Oz | Supply (million oz.) | Demand (million oz.) | |||
| 2011 | $35.12 | 1121.8 | 1043.3 | |||
| 2012 | $31.15 | 1004.6 | 1006.6 | |||
| 2013 | $23.79 | 1137.9 | 988.9 | |||
| 2014 | $19.08 | 1131.9 | 1053.3 | |||
| 2015 | $15.68 | 1170.5 | 1040.6 | |||
| Price | $15.00 | $20.00 | $25.00 | $30.00 | $35.00 | $40.00 |
| Supply (Million Oz) | 1121.8 | 1004.6 | 1137.9 | 1131.9 | 1170.5 | |
| Demand (Million Oz) | 1043.3 | 1006.6 | 988.9 | 1053.3 | 1040.6 |
Silver Summary Chart
Supply (Million Oz)
Demand (Million Oz)
Silver Supply
| Silver Supply | |||
| Year | Supply (million oz.) | Devation | Variance |
| 2011 | 1121.8 | 8.5 | 71.6 |
| 2012 | 1004.6 | -108.7 | 11824.4 |
| 2013 | 1137.9 | 24.6 | 603.2 |
| 2014 | 1131.9 | 18.6 | 344.5 |
| 2015 | 1170.5 | 57.2 | 3267.3 |
| Total | 5566.7 | -0.0 | 16110.9 |
| Average | 1113.3 | 4.0 | |
| Sum of squared Devation | 16110.9 | ||
| Sum of Devation/ n-1 | 4027.7 | ||
| Square Root of Sum of Devation/n-1 | 63.5 | ||
| Standard Devation of Supply | 63.5 | ||
| Supply Mean | 1,113.3 | ||
| Supply Median | 1,131.9 | ||
| Supply Mode | None | ||
| Supply Range | 165.9 |
Silver Supply
Silver Supply Supply (million oz.)
Silver Demand
| Silver Demand | |||
| Year | Demand (million oz.) | Devation | Variance |
| 2011 | 1043.3 | 16.8 | 280.9 |
| 2012 | 1006.6 | -19.9 | 397.6 |
| 2013 | 988.9 | -37.6 | 1416.8 |
| 2014 | 1053.3 | 26.8 | 716.1 |
| 2015 | 1040.6 | 14.1 | 197.7 |
| Total | 5132.7 | -0.0 | 3009.1 |
| Average | 1026.5 | 4.0 | |
| Sum of squared Devation | 3009.1 | ||
| Sum of Devation/ n-1 | 752.3 | ||
| Square Root of Sum of Devation/n-1 | 27.4 | ||
| Standard Devation of Supply | 27.4 | ||
| Demand Mean | 0.0 | ||
| Demand Median | 988.9 | ||
| Demand Mode | None | ||
| Demand Range | 64.4 |
Silver Demand
| 1043.3 |
| 1006.6 |
| 988.9 |
| 1053.3 |
| 1040.6 |
Demand (million oz.)
Silver Price per Oz
| Silver Price | |||
| Year | Price Per Oz | Devation | Variance |
| 2011 | $35.12 | $10.16 | $103.14 |
| 2012 | $31.15 | $6.19 | $38.27 |
| 2013 | $23.79 | -$1.17 | $1.38 |
| 2014 | $19.08 | -$5.88 | $34.62 |
| 2015 | $15.68 | -$9.28 | $86.19 |
| Total | $124.82 | $0.00 | $263.60 |
| Average | $24.96 | $4.00 | |
| Sum of squared Devation | $263.60 | ||
| Sum of Devation/ n-1 | $65.90 | ||
| Square Root of Sum of Devation/n-1 | $8.12 | ||
| Standard Devation of Price | $8.12 | ||
| Price Mean | $24.96 | ||
| Price Median | $23.79 | ||
| Price Mode | None | ||
| Price Range | $19.44 |
Silver Price per Oz
Price Per Oz
