fig 7 chances of survival according to the company's age

andrasvereckei commented 3 months ago

Chances of survival according to the company's age

Divide by fo3 do3
Cat. definitions are in #2

@collapse n_firms = rowcount(distinct(frame_id)), by(firmage, categ)
@egen max_n = max(cond(firmage == 0, n_firms, 0)), by(categ)
@generate survival = 100 * n_firms / max_n

"fo3 vs do3 kezdeti méretkategória esetleg megbontva belépési kohorsz (foundyear) szerint "

andrasvereckei commented 2 months ago

https://github.com/ceumicrodata/firms/blob/main/output/fig/survival.png

andrasvereckei commented 4 weeks ago

ta year if category =="medium domestic" & age_in_balance ==1 year | Freq. | Percent | Cum. -- | -- | -- | -- | | | 1990 | 2,817 | 44.39 | 44.39 1991 | 487 | 7.67 | 52.06 1992 | 371 | 5.85 | 57.91 1993 | 464 | 7.31 | 65.22 1994 | 310 | 4.88 | 70.11 1995 | 199 | 3.14 | 73.24 1996 | 146 | 2.3 | 75.54 1997 | 117 | 1.84 | 77.39 1998 | 93 | 1.47 | 78.85 1999 | 114 | 1.8 | 80.65 2000 | 100 | 1.58 | 82.23 2001 | 115 | 1.81 | 84.04 2002 | 75 | 1.18 | 85.22 2003 | 65 | 1.02 | 86.24 2004 | 72 | 1.13 | 87.38 2005 | 78 | 1.23 | 88.61 2006 | 71 | 1.12 | 89.73 2007 | 70 | 1.1 | 90.83 2008 | 45 | 0.71 | 91.54 2009 | 53 | 0.84 | 92.37 2010 | 44 | 0.69 | 93.07 2011 | 58 | 0.91 | 93.98 2012 | 21 | 0.33 | 94.31 2013 | 64 | 1.01 | 95.32 2014 | 33 | 0.52 | 95.84 2015 | 33 | 0.52 | 96.36 2016 | 40 | 0.63 | 96.99 2017 | 32 | 0.5 | 97.49 2018 | 46 | 0.72 | 98.22 2019 | 26 | 0.41 | 98.63 2020 | 26 | 0.41 | 99.04 2021 | 30 | 0.47 | 99.51 2022 | 31 | 0.49 | 100 | | | Total | 6,346 | 100 |

ta year if category =="medium domestic" & age_in_balance ==2 1991 | 2,701 | 38.36 | 38.36 -- | -- | -- | -- 1992 | 473 | 6.72 | 45.07 1993 | 427 | 6.06 | 51.14 1994 | 511 | 7.26 | 58.39 1995 | 336 | 4.77 | 63.16 1996 | 229 | 3.25 | 66.42 1997 | 187 | 2.66 | 69.07 1998 | 175 | 2.49 | 71.56 1999 | 122 | 1.73 | 73.29 2000 | 187 | 2.66 | 75.94 2001 | 117 | 1.66 | 77.61 2002 | 138 | 1.96 | 79.57 2003 | 87 | 1.24 | 80.8 2004 | 84 | 1.19 | 81.99 2005 | 81 | 1.15 | 83.14 2006 | 99 | 1.41 | 84.55 2007 | 96 | 1.36 | 85.91 2008 | 100 | 1.42 | 87.33 2009 | 72 | 1.02 | 88.36 2010 | 72 | 1.02 | 89.38 2011 | 78 | 1.11 | 90.49 2012 | 73 | 1.04 | 91.52 2013 | 52 | 0.74 | 92.26 2014 | 65 | 0.92 | 93.18 2015 | 61 | 0.87 | 94.05 2016 | 66 | 0.94 | 94.99 2017 | 47 | 0.67 | 95.65 2018 | 77 | 1.09 | 96.75 2019 | 78 | 1.11 | 97.86 2020 | 50 | 0.71 | 98.57 2021 | 46 | 0.65 | 99.22 2022 | 55 | 0.78 | 100 | | | Total | 7,042 | 100 |

andrasvereckei commented 4 weeks ago

@korenmiklos The number of medium domestic firms are bigger in age_in_balance ==2 then age_in_balance ==1. The reason is the first year == 1990. In the first year lots of these firms were large domestic firms. In the second year in 1991 they become medium domestic firms.

Two possible way:

Change first year definition in function panel(df::AbstractDataFrame)
Examine firms within size category. Change https://github.com/ceumicrodata/firms/blob/4575bf1ad840298233fe0993a2d9d23aa6364f03/src/functions.jl#L96 someting was medium for 5/10 years.

andrasvereckei commented 1 week ago

Foreign firms are at the bottom of the figure. Seems strange. FIXME

https://raw.githubusercontent.com/ceumicrodata/firms/b05699af05d8a828e77d9dc9d8fa0048679ffedc/output/fig/survival.png

korenmiklos commented 1 week ago

foreign should also be held constant after the first fix years. something @. ever_foreign = maximum(foreign), by(frame_id)On 2024. Nov 19., at 11:55, andrasvereckei @.> wrote: Foreign firms are at the bottom of the figure. Seems strange. FIXME https://raw.githubusercontent.com/ceumicrodata/firms/b05699af05d8a828e77d9dc9d8fa0048679ffedc/output/fig/survival.png

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: @.***>

andrasvereckei commented 6 days ago

foreign should also be held constant after the first fix years. something @. ever_foreign = maximum(foreign), by(frame_id)On 2024. Nov 19., at 11:55, andrasvereckei @.> wrote: Foreign firms are at the bottom of the figure. Seems strange. FIXME https://raw.githubusercontent.com/ceumicrodata/firms/b05699af05d8a828e77d9dc9d8fa0048679ffedc/output/fig/survival.png —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: @.***>

https://github.com/ceumicrodata/firms/pull/25/commits/48d5dbfc4bfcd75286460bb87632262794ae8958#diff-2fd14026f9c11d181c4535d73e2aecf42e603469ff12d4e47ec3a7ffe7119ccd

ceumicrodata / firms

fig 7 chances of survival according to the company's age #8