Calculating Intraclass correlation coefficients

[Em Mohamed]

Dears,

I have a panel dataset.

Company ID: Company
Year
Dependent variable: ROA
Independent variable= Accounting Experience (AccExp) of CEO
Person ID: CEOIDs

I want to calculate the Intraclass correlation coefficients, could any one help me in this?

* Example generated by -dataex-. For more info, type help dataex
clear
input long Company float Year double FinBERTSentiment float Military_CEOs_Chair_Dummy long CEOIDs
 1 2010   .06255212677231026 1 6354
 1 2011  .023492560689115115 1 6354
 1 2012  .051224944320712694 1 6354
 1 2013   .04344919786096257 1 6354
 1 2014  .030564784053156147 1 6354
 1 2015   .03143313798614811 1 6354
 1 2016   .05271398747390397 1 6354
 1 2017   .05558388577256502 0 6354
 1 2018   .02774049217002237 0 2131
 1 2019  .020512820512820513 0 2131
 1 2020   .02368421052631579 0 2131
 1 2021   .03558718861209965 0 2131
 2 2011  .021479713603818614 0  446
 2 2012  .012690355329949238 0  446
 2 2013   .00954653937947494 0 2500
 2 2014   .06553398058252427 0 2500
 2 2015  .015463917525773196 0 2500
 2 2016   .04555808656036447 0 2500
 2 2017   .03333333333333333 0 2500
 2 2020  .046052631578947366 0 3936
 2 2021   .06838709677419355 0 3936
 3 2013  .012195121951219513 0 8683
 3 2014   .04455445544554455 0 8683
 3 2015  .030894308943089432 0 8683
 3 2016  .044657097288676235 0 8683
 3 2017   .02100840336134454 0 8683
 3 2018  .009140767824497258 0 8683
 3 2019  .009191176470588236 0 8683
 3 2020  .015841584158415842 0 8683
 4 2010  .013807285546415981 0  638
 4 2011   .08067226890756303 0  638
 4 2012   .09943714821763602 0  638
 4 2013   .05714285714285714 0 8310
 4 2014   .03586206896551724 0 8310
 4 2018  .034818941504178275 0 4542
 4 2019    .0267515923566879 0 4542
 4 2020   .05193075898801598 0 2525
 4 2021   .04015544041450777 0 2525
 5 2012   .03860294117647059 0 6554
 5 2013  .009380863039399626 0 6554
 5 2015  .005037783375314861 0  581
 5 2016   .03488372093023256 0  581
 6 2013  -.04216867469879518 0 8708
 6 2015   .05307262569832402 0 2511
 6 2016   .05574912891986063 0 3534
 6 2017   .07224770642201835 0 3534
 6 2018   .10775047258979206 0 3534
 6 2019   .07314814814814814 0 3534
 6 2020   .02977667493796526 0 3534
 6 2021   .09728506787330317 0 3196
 7 2010   .08469055374592833 0  875
 7 2012   .07975460122699386 0  875
 7 2013   .07407407407407407 0  875
 7 2014  .058465286236297195 0  875
 7 2015   .05502846299810247 0  875
 7 2016   .05163511187607573 0  875
 7 2017  .037996545768566495 0  875
 7 2018   .03634085213032581 0  875
 7 2019   .03468208092485549 0  875
 8 2013   .02533783783783784 0 2600
 8 2014  .017892644135188866 0 2600
 8 2015   .05172413793103448 0 2600
 8 2016   .04007285974499089 0 2600
 8 2017  .045774647887323945 0 2600
 8 2018   .03801652892561983 0 5006
 8 2020  .016985138004246284 0 5482
 8 2021    .0647985989492119 0 5482
 9 2011  .050699300699300696 0 7766
 9 2012   .07441860465116279 0 7766
 9 2013   .04751131221719457 0 7766
 9 2014  .016483516483516484 0 7766
 9 2015   .01978021978021978 0 7766
 9 2016   .04182509505703422 0 7766
 9 2017   .03488372093023256 0 7766
 9 2018  .028933092224231464 0 7930
 9 2019  .057746478873239436 0 7930
 9 2020              .028125 0 7930
 9 2021   .03959131545338442 0 7930
10 2014   .04779411764705882 0 6172
10 2015  .054820415879017016 0 6172
10 2017   .05673758865248227 0 4496
10 2018  .057803468208092484 0 3742
10 2019   .06679764243614932 0 3742
10 2020    .0821917808219178 0 3742
10 2021   .14655172413793102 0 3742
11 2010 -.005405405405405406 0 6475
11 2011  -.03571428571428571 0 6475
11 2012   .04564315352697095 0 6475
11 2013   .07871720116618076 0 6348
11 2014  .022988505747126436 0 6348
11 2015  .026694045174537988 0 6348
11 2016  .036334913112164295 0 6348
11 2017   .03938730853391685 0 6348
11 2018   .03171953255425709 0 6348
11 2019   .04789272030651341 0 6348
11 2020    .0297951582867784 0 6243
11 2021  .024013722126929673 0 6243
12 2013   .13561847988077497 0 6000
12 2014    .0913884007029877 0 6000
12 2016  .038910505836575876 0 6000
end
format %ty Year
label values Company Company
label def Company 1 "000002", modify
label def Company 2 "000004", modify
label def Company 3 "000005", modify
label def Company 4 "000006", modify
label def Company 5 "000007", modify
label def Company 6 "000008", modify
label def Company 7 "000009", modify
label def Company 8 "000010", modify
label def Company 9 "000011", modify
label def Company 10 "000012", modify
label def Company 11 "000014", modify
label def Company 12 "000016", modify
label values CEOIDs CEOIDs
label def CEOIDs 446 "30138572", modify
label def CEOIDs 581 "30142622", modify
label def CEOIDs 638 "30145990", modify
label def CEOIDs 875 "30164062", modify
label def CEOIDs 2131 "30192166", modify
label def CEOIDs 2500 "30257424", modify
label def CEOIDs 2511 "30258038", modify
label def CEOIDs 2525 "30258380", modify
label def CEOIDs 2600 "30262523", modify
label def CEOIDs 3196 "30313965", modify
label def CEOIDs 3534 "30324183", modify
label def CEOIDs 3742 "30330803", modify
label def CEOIDs 3936 "30344026", modify
label def CEOIDs 4496 "30365356", modify
label def CEOIDs 4542 "30366949", modify
label def CEOIDs 5006 "30383026", modify
label def CEOIDs 5482 "30407648", modify
label def CEOIDs 6000 "3044154", modify
label def CEOIDs 6172 "3047844", modify
label def CEOIDs 6243 "3050228", modify
label def CEOIDs 6348 "3053560", modify
label def CEOIDs 6354 "3053716", modify
label def CEOIDs 6475 "3054726", modify
label def CEOIDs 6554 "3055274", modify
label def CEOIDs 7766 "3062824", modify
label def CEOIDs 7930 "3066194", modify
label def CEOIDs 8310 "3079234", modify
label def CEOIDs 8683 "3091370", modify
label def CEOIDs 8708 "3092478", modify