Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: Draw an offer curve (supply curve)?


From   Nick Cox <n.j.cox@durham.ac.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Draw an offer curve (supply curve)?
Date   Wed, 2 Nov 2011 20:48:01 +0000

As said, you can use -separate- on -p-. Different IDs would just be superimposed and whichever was plotted last would show on top. I can't comment on what MS Excel can do. 

Nick 
n.j.cox@durham.ac.uk 


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Guang Dai
Sent: 02 November 2011 20:42
To: statalist@hsphsun2.harvard.edu
Subject: RE: st: Draw an offer curve (supply curve)?

no, that really doesn't matter. If two identical pairs are offered by two IDs, we just assign half of the "stairstep" to one ID and color the half with the ID's color. 
But I'm interested in how to do that. In excel, this is very easy, but seems not in Stata.   


Guang Dai | Economist, Market Surveillance Administrator | 403.705.3183 | #500, 400 - 5th Avenue S.W., Calgary AB T2P 0L6 | www.albertamsa.ca 
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
Sent: Wednesday, November 02, 2011 2:23 PM
To: 'statalist@hsphsun2.harvard.edu'
Subject: RE: st: Draw an offer curve (supply curve)?

Your own example shows that the same (quantity, price) pair can apply to different values of -ID-, so that distinguishing them is not fully possible. Otherwise you would need to apply -separate- to -p-. 

Nick
n.j.cox@durham.ac.uk 

G. Dai

By the way, is there any way to indicate the ID of the offered quantity, that is the stairstep in the curve? Say, can we use different colors to distinguish IDs in the offer curve?
thanks,

On Mon, Oct 24, 2011 at 7:07 AM, Brian P. Poi <bpoi@stata.com> wrote:
> G. Dai wrote:
>>
>> Dear all,
>> I have a dataset on real offering behavior and I want to draw an 
>> offering curve (supply curve) from the data set.
>> One simple example of the data is following:
>>
>> ID    Qantity_Offered    Price_asked
>>
>> 1       10                         99
>> 2        23                        90
>> 1        5                          50
>> 4       30                         32
>> 3       39                         10
>> 2       30                          0
>> 4       20                          0
>> 3       20                          0
>>
>> ID is the individual participating in the trade, and quantity_offered 
>> is the quantity they can offer at the price of Price_asked.
>> We can see some individuals just ask zero price for some quantities, 
>> while ask a higher price for extra quantities.  My object is draw an 
>> offer curve (supply curve) from the data in an efficient way because 
>> the dataset  is big.
>>
>> Any suggestion is appreciated.
>> Thanks and have a great weekend!
>
> How about something like this:
>
> . input id q p
> 1       10                         99
> 2        23                        90
> 1        5                         50
> 4       30                         32
> 3       39                         10
> 2       30                          0
> 4       20                          0
> 3       20                          0
> end
>
> . sort p                  // put data in ascending price order . gen 
> totalq = sum(q)     // running sum of total quantity offered
>                          // for price <= p . line p totalq, 
> connect("stairstep")
>


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index