Based on my sample data shown below I am trying to understand the following and I am not sure what sort of regression report I should use or if there is another report type that I can generate instead.
1) Which variables (columns C-F, in green) affect rank (column B, in orange) and by how much does each variable affect it (the weighting)?
2) Those records that have identical categories (column A, in orange), they will never have the same ranking. That being said, once I answer question #1, I'd still like to know if the statistics are different based on each category. For example, if GC is weighted 50% for rank, does that mean it has the same weight for items in astronomy as those in electronics categories?
3) Some variables are yes/no. How do I include them in my analysis? Should I change them to 0's and 1's? Would that even give me a statistical significant result since the values are not very changing?
Any ideas on how to approach this would be very much appreciated. Thanks in advance.