Dear Madam/Sir, I would like to calculate the score average of other firms in the same year. For instance, for gvkey1 # 1011, the average score = score sum (gvkey # 1013, 1034,1036,1045,1065,1072,1073)/7. Any programming help would be greatly appreciated. gvkey1 year score 1011 1988 0.1508 1011 1988 0.0851 1011 1988 0.0258 1011 1988 0.0097 1013 1988 0.0215 1013 1988 0.0154 1013 1988 0.0842 1013 1988 0.0006 1034 1988 0.0434 1034 1988 0.0193 1034 1988 0.0324 1036 1988 0.004 1036 1988 0.0393 1036 1988 0.0177 1036 1988 0.0103 1045 1988 0.0712 1045 1988 0.0059 1045 1988 0.0636 1045 1988 0.007 1045 1988 0.0619 1065 1988 0.0144 1065 1988 0.0201 1065 1988 0.0006 1065 1988 0.0101 1072 1988 0.0663 1073 1988 0.0021 1073 1988 0.0462 1073 1988 0.006 Thank you Joon1
... View more