Question 1170100: Not sure where this goes but lets try here. I have the sum of values for each day of the week. The sum changes daily but the range is always 7 days at a time. So lets say Sun-Sat = 750, then Mon-Sun = 825, then Tue-Mon = 678, then Wed-Tue = 913. Is there a way to determine the values for each day over time?
Answer by ikleyn(52879)   (Show Source):
You can put this solution on YOUR website! .
I thought on this problem.
Surely, the most interesting part is to get a setup, i.e. to create a mathematical model.
The only model, which may work in this case, is THIS.
There are 10 unknown variables, in all: seven for the first week Sun-Sat,
and 3 additional unknown variables for the days Sun, Mon and Tue of the next week.
For these 10 unknowns, we have 4 equations: each single equation is the given sum for 7 days in the range.
Having this system of 4 equations in 10 unknowns, we actually have 6 "free unknown variables", that may have any
values, and 4 dependable unknowns - - - these four unknown are entirely defined by the six "free unknown variables"
and the structure of the 4 equations.
If you are interested, you may develop the solution further from this point to completion.
What to me, the further developing this idea is not interesting to me, so I will not work on it.
In this problem, as I said above, the more or less interesting part is setuping and creating a Math model.
The rest is just boring technique.
The problem itself does not seem interesting to me, excluding the setup, which is just done.
|
|
|
