LinkBack URL
About LinkBacks
I want create 3 groups in close to equal in terms of total revenue and count of accounts. Account.xlsx
Group 1, 2, 3 should be as close to equal in terms of total revenue and count of accounts
I want create 3 groups in close to equal in terms of total revenue and count of accounts. Account.xlsx
Which is more important, total revenue or count?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
actually both. Condition is BOTH total revenue and count of accounts
.
thanks for your help.
Alright, I'll just make up an arbitrary scaling factor then, if it didn't even occur that you needed one.
See attached; least squares regression (of two variables) running off that VBA button. I treated revinue and count as independent, although they're not really. Well, be aware that of the hundreds of billions (or so) of possible solutions, this one converges at the first local minima it finds, so your starting distribution might matter.
Change the range definition in the module if you want to apply it to a larger function.
Well, in that case it might have to churn & burn for a while....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks