#### Re: Freight car distribution

Mike Brock <brockm@...>

Larry Ostresh writes:

"I ran my "random train" Excel program for 100,000 iterations to test

whether it was working OK. The average number of boxcars per train,

by railroad, seemed to properly mirror the national fleet as

represented by Tim Gilbert's data for 1949:"

Larry, could you explain what you are talking about? You show RR [ i.e., SP excluding T&NO ], number [ number of SP box cars { 27757 } ] Nat'l % [ you show 4.0% but Tim shoed 3.9% ] and Random % [ 4.01% ]. What is the derivation of the random %?

RR___Number___Nat'l %___Random %

SP-Pac___27,757___4.00%___4.01%

"(The "Number" and "Nat'l %" columns above are from Tim's 1949 list of

boxcars."

Yep.

"His data are at "4060totalboxcarsUSownership.xls" in the

files section of this list."

Yep.

"The "Random %" column is the average

percentage of cars per train generated by my Excel program after

100,000 iterations. Each train consisted of 40 boxcars.)"

Hmmm. Well, 40 box cars is OK...actually 39.

"While running the program, I tallied the maximum number of cars for

each railroad over all the iterations. In a 40 boxcar train, the

average number of cars would be 40 times the national percentage

shown in the above table."

Why do you say that?

"For example, the average number of SP-Pac

cars would 40 * 4% = 1.6 cars - 1 or 2 cars per train."

Well...actually that's not so at all. The correct number is 4. 136/34= If you use real...rather than theoretical data. IOW, the 4% [ actually 3.9% ] fails to produce the actual number of cars...136.

"Any

particular 40 boxcar train may have more or less SP-Pac cars (0 to

40)."

"After 100,000 trials, there were in fact trains with no SP-Pac

boxcars, but no train had more than 9 of them."

We know that there were 4 of 34 trains...11.76%...of the trains with far more than 9 SP bx cars.

The 1953 data shows the "infamous" train with 36 or more SP bx cars [ not T&NO ].

Mike Brock

"I ran my "random train" Excel program for 100,000 iterations to test

whether it was working OK. The average number of boxcars per train,

by railroad, seemed to properly mirror the national fleet as

represented by Tim Gilbert's data for 1949:"

Larry, could you explain what you are talking about? You show RR [ i.e., SP excluding T&NO ], number [ number of SP box cars { 27757 } ] Nat'l % [ you show 4.0% but Tim shoed 3.9% ] and Random % [ 4.01% ]. What is the derivation of the random %?

RR___Number___Nat'l %___Random %

SP-Pac___27,757___4.00%___4.01%

"(The "Number" and "Nat'l %" columns above are from Tim's 1949 list of

boxcars."

Yep.

"His data are at "4060totalboxcarsUSownership.xls" in the

files section of this list."

Yep.

"The "Random %" column is the average

percentage of cars per train generated by my Excel program after

100,000 iterations. Each train consisted of 40 boxcars.)"

Hmmm. Well, 40 box cars is OK...actually 39.

"While running the program, I tallied the maximum number of cars for

each railroad over all the iterations. In a 40 boxcar train, the

average number of cars would be 40 times the national percentage

shown in the above table."

Why do you say that?

"For example, the average number of SP-Pac

cars would 40 * 4% = 1.6 cars - 1 or 2 cars per train."

Well...actually that's not so at all. The correct number is 4. 136/34= If you use real...rather than theoretical data. IOW, the 4% [ actually 3.9% ] fails to produce the actual number of cars...136.

"Any

particular 40 boxcar train may have more or less SP-Pac cars (0 to

40)."

"After 100,000 trials, there were in fact trains with no SP-Pac

boxcars, but no train had more than 9 of them."

We know that there were 4 of 34 trains...11.76%...of the trains with far more than 9 SP bx cars.

The 1953 data shows the "infamous" train with 36 or more SP bx cars [ not T&NO ].

Mike Brock