Math


ESPN Passport: The Games I Have Attended 2

Anyone who knows me knows that I love stats. One of the more underrated sports related stats website has to be ESPN Passport. It is an awesome service provided by ESPN that allows you to archive all the sports events you have been to (and even watched from home) and spews out stats about how the teams have done in those games. They show a win-loss record, active winning or losing streak and how the teams have done at home and on the road in the games you saw them play. Over time, they have added medals which you can earn if you attend events and the team goes on a winning or even a losing streak.

Full link to all the stats available here on Google Drive.

Here’s a look at some of the stats for my events: (Note: I only log the games that I have attended in person)

I am certain that I missed a couple of games that I attended in person but of the 38 games I have logged in so far, there are 10 teams that I have never seen lose (3 of them I have seen on more than one occasion):

New York Mets: 3-0, 2 games at Citi Field (vs. Yankees and Chicago White Sox) and one at Rogers Center
Seattle Mariners: 2-0 (both in the same stadium but once when it was SkyDome and one as Rogers Center)
West Virginia Mountaineers (CFB): 2-0 (both at High Point Solutions Stadium)

The following teams are 1-0: Houston Astros, Cincinnati Bearcats (CFB), Fresno State Bulldogs (CFB), Buffalo Sabers, San José Sharks, Miami Heat and Syracuse Orangeman (CBB).

The most frequent teams that I have seen are by far the Toronto Blue Jays and New York Yankees:

Toronto Blue Jays: 6-9 record, 5-7 at home and 1-2 on the road (all road games at Yankee Stadium)
New York Yankees: 8-5 record, 5-3 at home and 3-2 on the road (all road games at Rogers Center)

List of Arenas with record of home team in brackets:
SkyDome/Rogers Center (5-7)
Old/New Yankee Stadium (5-3)
High Point Solutions Stadium (3-4)
Citi Field (2-0)
Izod Center (2-1)
Madison Square Garden (1-1)
Air Canada Center (0-1)
Rutgers Athletic Center (0-1)
TD Garden (0-1)
Citizens Bank Ballpark (0-1)

Stats by Sport:
Major League Baseball: 23 games
NCAA DI Football: 7 games
National Hockey League: 4 games
National Basketball Association: 3 games
NCAA DI Basketball: 1 game

Finishing off with the medals page, I have six in total which include easy ones like checking into your first event, posting comments and attending a game on a holiday. However two cool ones that I have is “Zero Hero” which is attending a game with a shutout (I just got at the Mets/White Sox game) and “Doubleheader” which is attending two games in one day. I got that one on October 27, 2007 by watching a college football game between Rutgers Scarlet Knights and West Virginia playing a game at noon and then heading over to Madison Square Garden to see the Toronto Maple Leafs and the New York Rangers play at 7pm.

 


Quick Working Stats

While there is some down time at work, I pulled up a file I created when I started work here which has been breaking down the data of how much I am working and when. By no means am I complaining of the hours I work because the things I have learned so far and people I get to work with have taught me a tremendous amount in a very short time span but I am a math major and we do these types of things so here is a quick snapshot:

Time In Time Out Avg/Day Avg/Week
Jul-10 8:33 17:06 8:32 42:42
Aug-10 8:09 17:40 9:30 47:33
Sep-10 8:10 17:31 9:21 46:46
Oct-10 8:12 18:15 10:03 50:15
Nov-10 8:09 18:07 9:57 49:49
Dec-10 8:10 17:21 9:10 45:53
Jan-11 8:09 18:15 10:06 50:30
Time In Time Out Avg/Day Avg/Week
Q3 2010 8:17 17:26 9:08 45:41
Q4 2010 8:10 17:54 9:43 48:37
Q1 2011 8:09 18:15 10:06 50:30

Just interesting to note that following the very first month, the time that I can into work got pulled back half an hour and the time I left pushed forward one half. A fantastic start for January so far and we’re barely half way through since I was here unexpectedly until almost 10PM last week which did well to push that average up near record levels although I don’t think (and hope) it won’t sustain during the next two weeks as lots of things are progressing steadily.

The end of December was kind of nice with people going on vacation and not a lot of things on my plate before the year but I still averaged leaving at pretty high 5:21PM leave time given those numbers includes a 1:30PM, 2:00PM and 3:00PM dismissal in consecutive weeks leading up to the new year.

Avg/Day
Monday 9:40
Tuesday 9:17
Wednesday 9:49
Thursday 9:23
Friday 9:19

One surprising note was that initially hit me what that Friday HAD to be the day which I worked the longest but the average per day just didn’t show that. It just turns out that if I take away those “early dismissal” prior to long weekends, the Friday average jumps a whole 41 minutes to 10 hours per every Friday which includes a 13+ hour day this past Friday.

With that, I’m off to lunch.


Math Puzzle: May 2010 1

[Edit] So I kind of assumed everything would think order of operations automatically apply but I guess I should have stated that. Yes, assume natural order of operations and not addition before multiplication in this example. [/Edit]

I found this math puzzle from Monroe CC. All you have to do is arrange the digits 1 through 9 in the grid blow so that all six of the equations (3 horizontal and 3 vertical) are all true.

If you are stuck, try solving for just one row and one column and then moving your way forward. I’ll probably post the result in a day or two but feel free to submit your answer if you think you have it.


Excel Help Request [Solved] 2

[Edit] Problem solved, using a SumIF ended up fixing both of my problems. Thanks to Mr. Feraudo. [/Edit]

For you Microsoft Excel experts out there, I have data on the scoring for an individual player and I am trying to figure out the use of a formula or two to calculate the following: I need to calculate the number of goals a person scored at Home (or Away) without individually counting them and then do the same thing for games in which the player’s team Won or Loss.

I thought about using CountIf but I’m not sure how to count items from a range of data based on a criteria that is not necessarily in the range. For example, if I want to count items from the Goals column based upon whether the Location is Home or not. Also, I’m not too familiar with using the Offset formula to calculate a column’s worth of data in a single cell as opposed to repeat it for every cell.

Any suggestions would be greatly appreciated. Even if you think you have something that might work but you aren’t too sure, feel free to shoot me an email or talk to me online about it.