st: Assistance if possible

[Saint Joseph <forevertruthful2004@yahoo.com>]

Dear Sir/Madam
 
I will like to join the stata group as well as find a way to solve the problem below:
 I calculate the highest 24-month concentration of merger bids involving firms in that industry in each decade.2 This 24-month period is identified as a potential wave. Taking the total number of bids over the entire decade for a given industry, I simulate 1000 distributions of that number of occurrences of industry member involvement in a bid over a 120-month period by randomly assigning each occurrence to a month where the probability of assignment is 1/120 for each month. I then calculate the highest 24-month concentration of activity from each of the 1000 draws. Finally, I compare the actual concentration of activity from the potential wave to the empirical distribution of 1000 peak 24-month concentrations. If the actual peak concentration exceeds the 95th percentile from that empirical distribution, that period is coded as a wave. For example, 36% of the 161 bids in the health care industry in the 1990s occurred within one 24-month period starting
 in May of 1996. Out of 1000 simulated distributions of 161 bids across a 10-year period, the 95th percentile of maximum concentration within any 24-month period is 27%. Thus, the cluster of bids in the health care industry starting in May of 1996 is coded as a wave.”
 
 



*
*   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/