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]

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/

**References**:**Re: st: Draw an offer curve (supply curve)?***From:*"G. Dai" <dgecon@gmail.com>

**RE: st: Draw an offer curve (supply curve)?***From:*Nick Cox <n.j.cox@durham.ac.uk>

**RE: st: Draw an offer curve (supply curve)?***From:*Guang Dai <Guang.Dai@albertamsa.ca>

- Prev by Date:
**RE: st: xthtaylor by hand or using xtivreg2** - Next by Date:
**st: RE: RE: RE: How to label days of week and hours of day on x axis** - Previous by thread:
**RE: st: Draw an offer curve (supply curve)?** - Next by thread:
**Re: st: Draw an offer curve (supply curve)?** - Index(es):