?? For Math/Excel Experts

[KingOfTheSquares]

Mach, interesting point as medians are not cool to figure HFAs (but OK for totals as there is a wider spread to work with). Matter of fact I always find it interesting that the average on is almost always higher than the medians for totals. This may explain why a lot of numerical folk shoot at higher totals instead of understanding that your win% is based on a figure similar to medians, i.e. number of times above vs number of time below the o/u line.

[Machiavelli]

I have found the Excel functions that performs this medianish mean. It is called TRIMMEAN. To exclude (trim) the outer 50% of data, put

TRIMMEAN(array, .5)

in a cell.

If one only wants to trim extreme outliers, say the top 10% and bottom 10%, you would use

TRIMMEAN(array, .2)

since the parameter in the TRIMMEAN function is the total percentage of values you want to exclude.

See also MS Excel help for TRIMMEAN.

[Machiavelli]

Very true, KOTS, and I think baseball totals have the most complicated mean/median issues.

[pokerjoe]

Thanks for that, Mach.

I've always done, uh, more "creative" trimmean, you might say [img]i/expressions/face-icon-small-wink.gif[/img]

Of course, my fantastically and unnecessarily convoluted formulas are part of the fun for me.

jpblade, I certainly respect anyone who learns to program for real. I just think that, for most of us, Excel is pretty good. And I especially think that the average sports bettor, even the average MW poster, is so limited at math skills that using Excel is the most you could hope for.

I think downloading info from websites is still the trickiest/most limited aspect of Excel, so anything that works better for doing that, hats off to.

[AussieVamp2]

<< Thanks for that, Mach.

I've always done, uh, more "creative" trimmean, you might say [img]i/expressions/face-icon-small-wink.gif[/img]

Of course, my fantastically and unnecessarily convoluted formulas are part of the fun for me.

jpblade, I certainly respect anyone who learns to program for real. I just think that, for most of us, Excel is pretty good. And I especially think that the average sports bettor, even the average MW poster, is so limited at math skills that using Excel is the most you could hope for.

I think downloading info from websites is still the trickiest/most limited aspect of Excel, so anything that works better for doing that, hats off to. >>



You might be able to write stuff in VBA to process boxscores, dunno, but spreadsheets not a good storage medium.

[Machiavelli]

I could parse boxscores in Excel if I wanted to, without much difficultly. Hardest thing would be just getting all of the info into Excel in text format. But I imagine that is a problem with every platform unless you can write code that imports (webcrawls?) from the web (?)

[AussieVamp2]

Yep. Whether VBA can do that, good question?

[Machiavelli]

You can import data into excel and avoid the copy/paste routine, but you have to do it one URL at a time and I don't think there is a way around manually inputting the URL.

[Machiavelli]

Actually I just gave it a second look, and I think you might be able to do it in VBA. You can do an web query from there, so it should be possible to dynamically feed it a URL.