My Math Forum  

Go Back   My Math Forum > Science Forums > Economics

Economics Economics Forum - Financial Mathematics, Econometrics, Operations Research, Mathematical Finance, Computational Finance


Reply
 
LinkBack Thread Tools Display Modes
May 25th, 2011, 09:22 AM   #1
dag
Newbie
 
Joined: May 2011

Posts: 4
Thanks: 0

State "adjustment" optimization

Hi

I have a list of all states with an "initial adjustment" on each state. I need to group the states together into a variable number of groups, and apply one "leftover adjustment" to each group to try and minimze the sum of the "initial adjustment" and the "leftover adjustment". I only have access to MS Excel.

I've grouped the states into five groups for the posted example, but the spreadsheet is set up to change the number of groups in cell J1. The number of states in each group does NOT have to be the same, i.e. Group 1 can have 3 states while group 2 has 10 states. Any pointers would be appreciated, I am fully competent in using Excel.

Thanks
dag
Attached Files
File Type: xlsx Example.xlsx (18.8 KB, 26 views)
dag is offline  
 
July 18th, 2011, 06:58 AM   #2
dag
Newbie
 
Joined: May 2011

Posts: 4
Thanks: 0

Re: State "adjustment" optimization

Ok, what would I need to change to make this problem solvable?
dag is offline  
Reply

  My Math Forum > Science Forums > Economics

Tags
adjustment, optimization, state



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can anyone help me finding this book "Evariste Galois "Toti" johnmath Math Books 6 January 27th, 2013 03:13 PM
A "simple" application of dirac delta "shift theorem"...help SedaKhold Calculus 0 February 13th, 2012 11:45 AM
"separate and integrate" or "Orangutang method" The Chaz Calculus 1 August 5th, 2011 09:03 PM
sample exeriment-need help finding "statistic" and "result" katie0127 Advanced Statistics 0 December 3rd, 2008 01:54 PM
terms "non-increasing" or "non-decreasing" Ujjwal Number Theory 2 September 29th, 2008 07:06 AM





Copyright © 2019 My Math Forum. All rights reserved.