31 replies to this topic

[williamevanl]

I'm trying to code something and I (as well as two phd's) have just spun my wheels about how to calculate something that should be pretty simple. I'm changing the terms so that I dont' have to list company materials.
I hope this analogy doesn't suck, all I need is (the average number of Race Cars per Race track) Additionally, (Race Car * Race Track = a race day)

Race Cars------Race Tracks------Race Day
15------------ 300 ------------- (15*300)
30------------ 10 ------------- (30*10)
45 ----------- 25 ------------- (45*25)
70 ----------- 6 ------------- (70*6)
9 ------------- 500 -------------- (9*500)


Each Race Car races on each race track so the average number of Race Tracks for each Race car is just the number of Race Tracks, Right. So the average number of race tracks for the first row is 300 because for each of the 15 cars, they each race 300 tracks.

Originally we though well the average number of race tracks per race car is just the average number of race tracks divided by instances so (841 / 5) this would work if all of the race cars were equal maybe? So that's wrong.

My boss thinks it should be calculated (total sum of RACE DAYS / total sum of Race Cars) which also seems incorrect. (or is it)

We are just looking for average number of Race Tracks per Race Car but I think we have confused ourselves to where we don't know which way is up. :(

Thanks!

[CommittedC0der]

Ok kinda hard to understand but, what im thinking is:
Day 1: Cars: 15, Tracks: 300. Average Tracks Raced Per Car:300

Now you continue the rest of the cars and tracks like this? Or start adding the tracks and cars together? If continue it looks like this correct?
Day 1: Cars: 15, Tracks: 300. Average Tracks Raced Per Car:300
Day 2: Cars: 30, Tracks: 10. Average Tracks Raced Per Car:10
Day 3: Cars: 45, Tracks: 25. Average Tracks Raced Per Car:25
Day 4: Cars: 70, Tracks: 6. Average Tracks Raced Per Car:6
Day 5: Cars: 9, Tracks: 500. Average Tracks Raced Per Car:500

Now you want to know the average number of tracks per cars for each day? Or for all days together? As I understand it, the math should be tracks/cars = average.

Hope this helped ~ Committed. :)

[williamevanl]

Yes, sorry you made that easier to understand, now I need the the average number of tracks raced for all the days together.

[CommittedC0der]

Well then it would all the tracks summed which is, 841, then add the cars(169) and divide: 841/169 = 4.97.

Hope this is what you meant ~ Committed. :)

[williamevanl]

No, and I think thats why it get confusing. What you said would be true if you were dividing the race tracks amongst the cars but you aren't, Its not the case that the sum of tracks is divided by the cars because each car races on every track.
my mistake I asked the question badly. I need the total average tracks raced per car.

[CommittedC0der]

ok...

Quote

now I need the the average number of tracks for all the days together.

So are we trying to figure out the average tracks per the 5 days? or what exactly are we try to find out? Sorry just not undertanding clearly.

~ Committed.

[williamevanl]

So I'm looking for the total average of tracks raced per car for all 5 days combined. So just one value average number of tracks raced per car.

[CommittedC0der]

ok

Quote

I need the total average tracks raced per car.

Then it would totalTracks/TotalCars = average(841/169 = 4.97 race's per car? Im not seeing how this is incorrect.

[williamevanl]

CommittedC0der said:

ok
Then it would totalTracks/TotalCars = average(841/169 = 4.97 race's per car? Im not seeing how this is incorrect.

Why are we splitting up total tracks. It's not the case that there are 841 tracks and you have to separate them evenly amongst the cars. Each car races on every track. I understand the confusion though, I had a lot of these wait what?, moments.

You have the average tracks raced per car /per day right. Now I juts need the total average for all five days. So I need an average of that average.

[CommittedC0der]

Quote

So just one value average number of tracks raced per car.

This would be 4.97. (4.97 average tracks per car * 169 cars = 839.93 tracks)

But then you go onto say:

Quote

It's not the case that there are 841 tracks and you have to separate them evenly amongst the cars.

So I believe I am totally lost, lol.

I suggest you post plainly the average your looking for e.g: How many tracks raced per car, of all days combined.

EDIT: Ok then the answer its 4.97, that is how many races each car must complete to get 839.93 totalTracks, which is the closest divisible number to the real totalTracks of 841. Hope that was clear.

Good Luck ~ Committed. :c-biggrin:

[Vswe]

(300+10+25+6+500)/5=168.2

maybe...?

EDIT:

Or maybe you're after:

((300 * 15) + (10 * 30) + (25 * 45) + (6 * 70) + (500 * 9)) / 169 = 64.1715976

It's a bit hard to understand what you're looking for. :/

[CommittedC0der]

Quote

(300+10+25+6+500)/5=168.2

Thats not right is it? Thats theaverage number of tracks raced per day, where looking for the average races per car for all 5 days correct?