Data Base Trifecta Question

[Dan Montilion]

Would any of the data base types help out a fellow handicapper?

If this is possible...

Median trifecta payoff
2006 So. Cal circuit (HOL, DMR, SA)
Dirt only

With these filters...

Each field size from 8 thru 16
Include Fav in top three
Exclude Fav in top three

How many races for each of the above cells.

I realize that the larger field sized may not produce enough races for a median, in that case an avg. would suffice.

I've noticed that in some recent threads more that one poster has mentioned of proving or disproving handicapping angles, facts and such with simple key strokes, so I thought if it was easy for the folks that have data bases to do that, well I thought I'd take a shot with this query.

[Que]

I'm not certain these figures are correct, but here's what I came up with:


$1 TRI: HOL (4/26/06 - 12/16/06)

nFld=8: w/FAV - 77 instances (median $89.60)
nFld=9: w/FAV - 76 instances (median $98.30/$105.00)
nFld=10: w/FAV - 67 instances (median $144.40)
nFld=11: w/FAV - 21 instances (median $213.10)
nFld=12: w/FAV - 26 instances (median $307.30/$316.50)
nFld=13: w/FAV - 6 instances (median $203.80/$248.30)
nFld=14: w/FAV - 11 instances (median $147.50)
nFld=15: w/FAV - 0 instances
nFld=16: w/FAV - 0 instances

nFld=8: w/o/FAV - 50 instances (median $242.60/$246.60)
nFld=9: w/o/FAV - 26 instances (median $326.40/$333.40)
nFld=10: w/o/FAV - 48 instances (median $410.30/$412.40)
nFld=11: w/o/FAV - 18 instances (median $518.10/$581.20)
nFld=12: w/o/FAV - 15 instances (median $1,232.30)
nFld=13: w/o/FAV - 6 instances (median $1,442.80/$1,653.60)
nFld=14: w/o/FAV - 5 instances (median $2,469.90)
nFld=15: w/o/FAV - 0 instances
nFld=16: w/o/FAV - 0 instances

$1 TRI: SA (3/8/06 - 10/29/06)

nFld=8: w/FAV - 68 instances (median $79.40/$83.70)
nFld=9: w/FAV - 44 instances (median $110.80/$111.40)
nFld=10: w/FAV - 41 instances (median $101.40)
nFld=11: w/FAV - 22 instances (median $179.10/$200.90)
nFld=12: w/FAV - 10 instances (median $215.70/$232.70)
nFld=13: w/FAV - 2 instances (median $260.00/$3,934.30)
nFld=14: w/FAV - 2 instances (median $333.20/$457.90)
nFld=15: w/FAV - 0 instances
nFld=16: w/FAV - 0 instances

nFld=8: w/o/FAV - 24 instances (median $217.20/$217.50)
nFld=9: w/o/FAV - 28 instances (median $347.20/$395.10)
nFld=10: w/o/FAV - 23 instances (median $502.80)
nFld=11: w/o/FAV - 13 instances (median $597.50)
nFld=12: w/o/FAV - 14 instances (median $569.10/$849.70)
nFld=13: w/o/FAV - 3 instances (median $1,344.60)
nFld=14: w/o/FAV - 0 instances
nFld=15: w/o/FAV - 0 instances
nFld=16: w/o/FAV - 0 instances

$1 TRI: DMR (7/19/06 - 9/6/06)

nFld=8: w/FAV - 48 instances (median $70.40/$71.60)
nFld=9: w/FAV - 44 instances (median $126.30/$132.90)
nFld=10: w/FAV - 40 instances (median $140.50/$141.60)
nFld=11: w/FAV - 12 instances (median $165.00/$168.90)
nFld=12: w/FAV - 19 instances (median $14.80)
nFld=13: w/FAV - 0 instances
nFld=14: w/FAV - 0 instances
nFld=15: w/FAV - 0 instances
nFld=16: w/FAV - 0 instances

nFld=8: w/o/FAV - 23 instances (median $236.80)
nFld=9: w/o/FAV - 18 instances (median $424.90/$609.90)
nFld=10: w/o/FAV - 20 instances (median $432.20/$535.50)
nFld=11: w/o/FAV - 10 instances (median $558.50/$900.10)
nFld=12: w/o/FAV - 12 instances (median $494.80/$667.40)
nFld=13: w/o/FAV - 0 instances
nFld=14: w/o/FAV - 0 instances
nFld=15: w/o/FAV - 0 instances
nFld=16: w/o/FAV - 0 instances

[Dan Montilion]

Que,

Thank You.