Thanks for your interest. Actually I am creating an Index for corporate firms. I have almost 300 companies and the sample period is 10 years. There are 6 categories that I need to measure. Under each category, there are several statements that will count the score of that category. I may use a likert scale, but I really want to put a scoring criteria using a statistical technique. For more understanding I am attaching an excel sheet.
... View more