Dear All,
I hope you are staying well and keeping safe. I am new to variable creating codes and would be very grateful if you could advise on the following issue that I have been struggling with for the last few days.
I have a panel dataset and need to calculate an innovation score for each firm within the same industry using the following formula:
Innovation score = (number of firms with a worse value + (number of firms with the same value as the current firm's value/2))/ total number of firms. For example, let say there 10 firms in one industry and the focal firm's value is 80. There is another firm that has the same value. All other firms have scores lower than 80. So the score will be = (8 + (2/2))/10 = 0.90.
I need to calculate for all firms within other industries.
Many thanks in advance and best wishes.
Related Posts with Calculating a score for each firm within the same industry
Hello FriendsHello Friends, I ran a MG command and STATA displayed an error message which reads: "invalid new va…
Why the similar code leads to opposite resultI dealing with data like: 0 2 4 -1 0 1 -2 -1 0 i wanna generate all data t`i'*w[_n] but minus one wo…
Fill null values within an ordered list.Hi there. In a data structure like this, sorted in ascending order by NUMN, I need to program a rule…
Carhart 4 factor modelHi there, I am currently doing some analysis looking at the affect of CSR on stock returns during a…
Formatting data for ARIMA modelingThis is my first post so please excuse any errors. I would like to estimate ARIMA models to understa…
Subscribe to:
Post Comments (Atom)
0 Response to Calculating a score for each firm within the same industry
Post a Comment