Hello everyone.
I am working on Cox regression using a panel dataset. My observation is 4029 with 255 firms. The following is a part of dataset what I used
input float C_ID int Time double Informality byte Failure double ROA
1 18 1.02 0 9.68
1 19 -.42 0 11.37
1 20 .39 0 15.66
1 21 .24 0 16.66
1 22 .04 0 11.86
1 23 .02 0 11.99
1 24 .01 0 12.97
1 25 -.05 0 6.92
1 26 .02 0 3.83
1 27 -.34 0 2.99
1 28 .35 0 7.06
1 29 .23 0 12.99
1 30 .01 0 12.13
1 31 .07 0 14.15
1 32 -.02 0 12.61
1 33 .09 0 8.05
1 34 -.03 0 5.02
2 56 -.22 0 6.43
2 57 -.42 0 6.72
2 58 .39 0 7.2
2 59 .24 0 8.74
2 60 .04 0 9.47
2 61 .02 0 5.86
2 62 .01 0 .95
2 63 -.05 0 2.15
2 64 .02 0 1.47
2 65 -.34 0 1.93
2 66 .35 0 2.29
2 67 .23 0 3.54
2 68 .01 0 3.89
2 69 .07 0 4.37
2 70 -.02 0 6.31
2 71 .09 0 3.79
2 72 -.03 0 3.04
3 6 -.36 0 73.54
3 7 -.34 0 23.98
3 8 .39 0 20.96
3 9 .25 0 16.02
3 10 .05 0 36.97
3 11 -.02 0 22.29
3 12 .04 0 14.62
3 13 0 0 12.84
3 14 -.07 0 14.62
3 15 -.49 0 27.82
3 16 .7 0 73.17
3 17 .3 0 27.63
3 18 -.04 0 49.05
3 19 .02 0 21.81
3 20 .08 0 44.49
3 21 .13 0 23.93
3 22 -.04 0 30.87
4 9 .01 0 35.63
4 10 -.29 0 6.57
4 11 .21 0 11.42
4 12 .22 0 15.86
4 13 .01 0 15.36
4 14 -.01 0 23.5
4 15 -.02 0 5.01
4 16 -.02 0 5.61
4 17 .02 0 8.91
4 18 -.4 0 10.87
4 19 .37 0 6.54
4 20 .25 0 4.58
4 21 -.01 0 5.19
4 22 .02 0 23.51
4 23 -.01 0 35.08
4 24 .03 0 34.43
4 25 -.04 0 35.42
5 61 .04 0 13.53
5 62 -.39 0 6.81
5 63 .33 0 4.36
5 64 .24 0 4.39
5 65 .01 0 3.3
5 66 -.01 0 3.47
5 67 -.02 0 3.43
5 68 0 0 5.78
5 69 0 0 5.92
5 70 -.49 0 5.35
5 71 .58 0 6.41
5 72 .26 0 6.6
5 73 0 0 13.14
5 74 0 0 18
5 75 .01 0 316.4
5 76 .05 0 351.51
5 77 -.03 0 365.06
6 9 -.02 0 15.57
6 10 -.39 0 15.68
6 11 .33 0 4.44
6 12 .24 0 6.06
6 13 .01 0 6.98
6 14 -.01 0 6.8
6 15 -.02 0 8.44
6 16 0 0 9.67
6 17 0 0 9.75
6 18 -.49 0 5.94
6 19 .58 0 4.29
6 20 .26 0 8.9
6 21 0 0 14.47
6 22 0 0 12.38
6 23 .01 0 2.08
the main independent variable is informality; failure is the event for firm liquidation, and time is the time to liquidation. ROA is firm profit. Here failure event coded as 1 is not visible and it comes later. I tried to plot the Kalpan Meier curves after Cox regression. But the graph does not look appropriate. Kindly help. Also, there are two groups based on firm resource diversification. Please help me understand what is wrong with the graph and why. It will be very helpful as this is my thesis work.
I am working on Cox regression using a panel dataset. My observation is 4029 with 255 firms. The following is a part of dataset what I used
input float C_ID int Time double Informality byte Failure double ROA
1 18 1.02 0 9.68
1 19 -.42 0 11.37
1 20 .39 0 15.66
1 21 .24 0 16.66
1 22 .04 0 11.86
1 23 .02 0 11.99
1 24 .01 0 12.97
1 25 -.05 0 6.92
1 26 .02 0 3.83
1 27 -.34 0 2.99
1 28 .35 0 7.06
1 29 .23 0 12.99
1 30 .01 0 12.13
1 31 .07 0 14.15
1 32 -.02 0 12.61
1 33 .09 0 8.05
1 34 -.03 0 5.02
2 56 -.22 0 6.43
2 57 -.42 0 6.72
2 58 .39 0 7.2
2 59 .24 0 8.74
2 60 .04 0 9.47
2 61 .02 0 5.86
2 62 .01 0 .95
2 63 -.05 0 2.15
2 64 .02 0 1.47
2 65 -.34 0 1.93
2 66 .35 0 2.29
2 67 .23 0 3.54
2 68 .01 0 3.89
2 69 .07 0 4.37
2 70 -.02 0 6.31
2 71 .09 0 3.79
2 72 -.03 0 3.04
3 6 -.36 0 73.54
3 7 -.34 0 23.98
3 8 .39 0 20.96
3 9 .25 0 16.02
3 10 .05 0 36.97
3 11 -.02 0 22.29
3 12 .04 0 14.62
3 13 0 0 12.84
3 14 -.07 0 14.62
3 15 -.49 0 27.82
3 16 .7 0 73.17
3 17 .3 0 27.63
3 18 -.04 0 49.05
3 19 .02 0 21.81
3 20 .08 0 44.49
3 21 .13 0 23.93
3 22 -.04 0 30.87
4 9 .01 0 35.63
4 10 -.29 0 6.57
4 11 .21 0 11.42
4 12 .22 0 15.86
4 13 .01 0 15.36
4 14 -.01 0 23.5
4 15 -.02 0 5.01
4 16 -.02 0 5.61
4 17 .02 0 8.91
4 18 -.4 0 10.87
4 19 .37 0 6.54
4 20 .25 0 4.58
4 21 -.01 0 5.19
4 22 .02 0 23.51
4 23 -.01 0 35.08
4 24 .03 0 34.43
4 25 -.04 0 35.42
5 61 .04 0 13.53
5 62 -.39 0 6.81
5 63 .33 0 4.36
5 64 .24 0 4.39
5 65 .01 0 3.3
5 66 -.01 0 3.47
5 67 -.02 0 3.43
5 68 0 0 5.78
5 69 0 0 5.92
5 70 -.49 0 5.35
5 71 .58 0 6.41
5 72 .26 0 6.6
5 73 0 0 13.14
5 74 0 0 18
5 75 .01 0 316.4
5 76 .05 0 351.51
5 77 -.03 0 365.06
6 9 -.02 0 15.57
6 10 -.39 0 15.68
6 11 .33 0 4.44
6 12 .24 0 6.06
6 13 .01 0 6.98
6 14 -.01 0 6.8
6 15 -.02 0 8.44
6 16 0 0 9.67
6 17 0 0 9.75
6 18 -.49 0 5.94
6 19 .58 0 4.29
6 20 .26 0 8.9
6 21 0 0 14.47
6 22 0 0 12.38
6 23 .01 0 2.08
the main independent variable is informality; failure is the event for firm liquidation, and time is the time to liquidation. ROA is firm profit. Here failure event coded as 1 is not visible and it comes later. I tried to plot the Kalpan Meier curves after Cox regression. But the graph does not look appropriate. Kindly help. Also, there are two groups based on firm resource diversification. Please help me understand what is wrong with the graph and why. It will be very helpful as this is my thesis work.
Comment