I'm trying to link the data from a group that is reached independently so that we can rank success of a group or groups to each other. The two independent variables are Profit gains and Expenditures (or profit losses). The numbers are broken down as follows, for example . . .
1. The New York group (gains) $114, (losses) 48
2. The Boston group (+) $92, (-) $70
3. Toronto group + $88, - $74
4. Baltimore group + $79, - $83
5. Tampa Bay + $63, - $99
Since these figures are subject to change, I could really use a function that would allow a group to move up and down within this faction along with their figures after the new tallies are accounted for. So in the first column would be in the Name of the Group (or in this case the city) followed by the two variables (which would be connected) much like it appears above. Does such a function exist?
Thanks in advance for the help on this one.
1. The New York group (gains) $114, (losses) 48
2. The Boston group (+) $92, (-) $70
3. Toronto group + $88, - $74
4. Baltimore group + $79, - $83
5. Tampa Bay + $63, - $99
Since these figures are subject to change, I could really use a function that would allow a group to move up and down within this faction along with their figures after the new tallies are accounted for. So in the first column would be in the Name of the Group (or in this case the city) followed by the two variables (which would be connected) much like it appears above. Does such a function exist?
Thanks in advance for the help on this one.
