Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: Draw an offer curve (supply curve)?
From
Nick Cox <[email protected]>
To
"'[email protected]'" <[email protected]>
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
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Guang Dai
Sent: 02 November 2011 20:42
To: [email protected]
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: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
Sent: Wednesday, November 02, 2011 2:23 PM
To: '[email protected]'
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
[email protected]
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 <[email protected]> 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/