Paper route salary formula (reverse engineer...again for lack of a better word;)
Ok suppose I have these variables:
Pieces of mail : 302
Number of stops: 177
TotalWeight* : 272
Hours allocated: 1(:)48
Another 4 numbers: 360(pieces),254(stops),258(weight),229(hours)
- totalweight is actually 27.2KG and 25.8KG, I decided (so far) to just keep them all regular numbers because I think I'm interested in the relation between numbers, not their intrinsic value..might be wrong here, same for Hours allocated which I just give the numbers 148 and 229
Ok so I'm trying to figure out given 302,177 and 272 the outcome is 148 in above example. So how much weight (if any) is given to any (or all) of these variables? I have much more data to work with than above example.
Google took me towards 'regression' in excel and I think I'm on the right track there but my knowledge is just lacking :(. Can someone give a noob a nudge in the right direction, I prefer this to be a learning experience vs 'oh that's easy, here's how you do it' ;).
Thanks in advance,
Mr.Mailman