I have a user that wants me to calculate the average of a quantity for 16 days, then re-average that quantity for the whole month on the assumption that the quantity for the remaining days is equal to the average.
Now I think that the final result will be the same as the first average, & I’m going through a lot of pain for nothing.
If I’m interpreting your first sentence correctly, then yes, it would be the same as the first average. Toss a quarter to the user and tell him to go buy a clue.
You are in a two-lap race around a one mile track. The first lap you average 30 mph. How fast do you have to go on the second lap to average 60 mph overall?
(Hint: It’s not 90 mph!)
“If ignorance were corn flakes, you’d be General Mills.”
Cecil Adams The Straight Dope
zyada: I have a user that wants me to calculate the average of a quantity for 16 days, then re-average that quantity for the whole month on the assumption that the quantity for the remaining days is equal to the average.
Now I think that the final result will be the same as the first average, & I’m going through a lot of pain for nothing.
Please define your variables, if you are going to present formulas. Your explanation of what the client wants is not explicit either.
You can’t assume that the first 16 days average is going to match the average for the last days of the month. The only way the client is right is if the last days of the month average exactly the same as the first 16 days. You can’t do what the client wants, and do it the right way if I’m interperting correctly what you are trying to say.
I read this and I’m not sure either what the customer would be asking for. If you have an average and use it for any number of other days and reaverage, it’ll always be the same. What I thought he was asking on first reading was to take an average of the first half month then seed that back in and thake an average of the last half of the month to see if they were close to the same. Maybe looking to see if the sales force was making quota in the first half and playing golf for the last half.
Nano, it’s a trick question. 60 mph for 2 miles takes 2 minutes. 30 mph for 1 mile takes 2 minutes. Second lap would have to be done in zero minutes.
The answer to the original post is yes, the average would remain the same.
For the racing problem, it took two minutes to do the first lap. To do two laps at 60 MPH would take two minutes. Therefore the second lap must be done in no time at all, or infinitely fast.
It’s the 17th. I have barrels of oil produced by a well each day for the first through the 16th. The average for these days is 3 barrels per day. The user wants me to calculate an average for the whole month - setting the days that I don’t have a value for yet to 3.
Is that better? (That wasn’t sarcasm, I know I have a problem explaining myself at times. I talk much better in C than in english!)
And Strainger - if I tossed a quarter to every user that needed a clue, I’d be operating on negative salary!
That’s one helluva well. So it’s made 48 barrels in the first 16 days of the month and user wants to say the thing is going to make 90 or 93 BO. Right? As long as it doesn’t sand up or water out or whatever.
Greg is right about the lap time - can’t be done once you’ve finished the first lap w/an average of 30 mph.
So thre user wants to use a trend in analysing their future production, not get an actual average for that month. They want to predict what might be. Correct?
Zyada, your user is an ass. If you assume all remaining entries will equal the arithmetic mean of the first 16 measurements, then the arithmetic mean will never shift. So, do the work he has asked for and charge him for the “effort” of performing both operations.
Melin, they’re correct on your problem and also on the race track problem. You sided with the wrong person, or at least a person who was thinking wrong at the time.
If you want to see the proper result from what should’ve been your last work with your equation, you should note that, in your equation, as it stands, you are multiplying miles times miles per hour in each term, which gives you miles[sup]2[/sup]/hour. You should instead be equating the sum of the two times for the successive laps, in hours, to their total time, in hours; that is:
1 mi 1 mi 2 mi
-------- + ------ = --------
30 mi/hr x 60 mi/hr
1/x then = 0, or x = <font face=“symbol”>¥</font>
Thus you must run the second lap at infinite speed to get your overall average speed for the two laps up to 60 mph.