|Posted: June 28, 2016, 1:03 am - IP Logged|
billjamesonline, a website dedicated to baseball sabermetrics, features a listing of the hottest teams and hitters, ranked by temperature. For example, the hottest team right now is the Cleveland Indians at 115 degrees.
Well, I said to myself, why not something similar for the numbers drawn in a Pick 3 lottery? Might be kind of fun. I don't think that it would necessarily help to improve one's winning chances, but you never know. So, I spent a couple of weeks on it, trying different approaches, and I came up with the following:
1) Open up an excel spreadsheet, and make a grid seven columns by ten rows (eleven if you include headers).
2) Put the numbers 0-9 in ascending order in column A.
3) Column B will contain the numbers drawn in the first position. Award 10 points for the most recent number, 9 points for the next most recent, and so forth, until you award 1 point to the least recent number drawn. Only award points for the latest appearance.
4) Do the same thing for column C (second position) and column D (third position).
5) In column E, you will award points based on a number's appearance, regardless of position. Start with the most recent draw and WORK FROM RIGHT TO LEFT.
For example, suppose the last draw was 542. Number 2 is awarded ten points, number 4 is awarded nine points and number 5 is awarded eight points. The next to last draw was 338. Number 8 is awarded seven points and number 3 is awarded six points. The previous draw to that was 777. Number seven is awarded five points. Continue until you award the least recent number one point. Again, only award points based on the latest appearance.
6) For each number, add the points from columns B, C, D and 1/10th the points in column E. Place the total for each number in column F.
7) Column G is for the temperatures in Fahrenheit. For each number, multiply the totals from column F by 5.16 and subtract 16.
I came up with the following arbitrary parameters:
Hot = 80-144 degrees; Warm = 60-79 degrees; Cool = 40-59 degrees; Cold = 0-39 degrees.
As for the selection and arraignment, I 'll leave that up to you. I would think that it would be better to box the numbers, rather than play them straight.
Here is the workout after today's drawing of Minnesota's Daily Three:
Number 1 is the hottest number currently at 117 degrees. Number 4 is the coldest at 47 degrees.
Just another way to look at the Pick Three. Hopefully, a fun way.
"Announcing your plans is a good way to hear God laugh"