Determing Value of "jar" of Coins
Hi everyone. I have been creeping the forums for a little while now and love it. :)
I have been having this problem for a while and i was hopping to get some direction.
I am trying to determine with a fairly high problilty the total value of a "jar of coins" Now it is NOT actually a jar or coins. I am looking at boxes of coins with high values ($1000+).
I have/get values for the box weights, The box weights inlcuding coins, and the total(exact) value of the coin values/coin count breakdowns.
I also have weights each individual coin. Now the values of each box will be fairly static. meanign that each box is holds money from a specific location. So what i am thinking is that because of this I can use historical values (coin totals, weights) to create a correlative value for each location.
Am i on the right track? it has been stumpping me for a while and i want the answer :)
Updated Explination with example
Ok here is another go at what i am looking for.
I am trying to determine the amount(Value) of money(coins)(the majority being 0.25 and higher. Money i would like to deal with is Canadian and American but primarly Canadian. So 0.25, 1.00, 2.00 coins are the MAJOR majority but there is also 0.01, 0.05 and 0.10 coins) inside a container based on weight.
Each container is filled with money once a week (Monday to friday)(not always on the same day but 95%+ of the time it is the same day of the week). The container holds money from the same location each week.
There is three sets of data that I have avaliable to help determine the value. I have historical container weights, I know the individual container weight. I also have the actual coin counts from the historical containers. Meaning I know the weight and i know exactly how much money was inside of the container broken down into exact coin type counts.
I do not have all coin counts for historical data and I would like to be able to determine container value in the future as I cannot always get exact count. So What i want to be able to do i determine the value of the container based on weight hopefully using historical data to increase the probability
Here is some sample data of what i have avaliable (actual numbers):
Container is 9.5 to 10 pounds
Grant Total: $34,761.40
Total Weight of Container 1 (Container and Money weighed as one, not a calculated value): 929.09 pounds.
let me know if you need anymore information
Edit: Oh if there sample is to large i have a few examples of smaller container values