Stats in the Wild

Well, it looks like I was wrong. In one of my posts from the beginning of the NFL playoffs, I spent quite some time complaining about how the Chargers and the Cardinals made the play-offs at 8 – 8 and 9 – 7, respectively. Looks like the Cardinals proved me wrong by making it all the way to the Super Bowl, making them the first 4 seed to make it to the Super Bowl since the league switched to 4 divisions in 2001.

Why has a 4 seed never made it to the Super Bowl (until this year) in the era of 4 divisions? It’s because usually they are the worst team in the play-offs. Since they have switched to 4 divisions, at least one wild card team has had a better record than one of the 4 seed 5 times in 7 seasons. No four seed has ever won a Super Bowl in the four division era, and Arizona is the only 4 seed to make it to the Super Bowl with four divisions.

(Note: This is the first Super Bowl in the 4 division era not to feature a number 1 seed.)

And what happens when we look back to when the NFL had only three divisions? We see that the 3 seed never made it to a Super Bowl, but the 4 seed (the highest wild card team) made it to (and won the Super Bowl) 2 times in the six seasons between 1996 and 2001. I’m going to eventually get around to going back as far as I can, but for now I only have data going back to 1996.) Also, over this same period, two number 4 seeds (the highest seeded wild card) won the super bowl.

So here is my suggestion: Seed teams based on record. If you win your division at 8-8 (San Diego) or 9-7 (Arizona), you should be a lower seed than a wild card team that went 11-5 (Baltimore) or 12-4 (Indianapolis). If you are trying to have a play-off that is the fairest, you should seed based on wins, not how it is currently done. Tennessee got royally screwed this year in the play-offs because of this system. Their reward for being the number one seed? A first round bye and then a showdown with the 11-5 5th seed which they lost, while the number 2 seed had a relatively easy ride to the conference championship by beating the lowly 8-8 4th seeded San Diego Chargers. It just doesn’t make sense to seed San Diego higher than Baltimore in this season. Baltimore is a better team and they had more wins. Make things fair and seed based on record.

Final note: I still think Arizona is terrible. But I have been wrong three weeks in a row. However, let me remind you that a 4 seed has never won a Super Bowl in the 4 division era. And I still think they are terrible. Thusly, the statsinthewild blog’s official pick for Super Bowl XLIII is the Pittsburgh Steelers 24-13.

Cheers.

This link has a good graphical representation of just how much value has been lost by some major banks.

Cheers.

Well, I’m done with my qualifying exam. I’ll know if I passed by late this week/early next week.

Anyway, here is a short project that I did on factor analysis in November.

Cheers.

Introduction
A major market index in the United States is the Dow Jones Industrial Average. Thirty large industrial companies stock prices contribute to the calculation of the Dow Jones industrial average. These companies are Boeing, Caterpillar, Chevron, Citigroup, Coca Cola, DuPont, Exxon Mobil, General Electric, General Motors, Hewlett Packard, Home Depot, IBM, Intel, Johnson and Johnson, JP Morgan Chase, Kraft Foods, McDonalds, Merck, Microsoft, Pfizer, Proctor and Gamble, United Tech, Verizon, WalMart, Walt Disney, Bank of America, AT and T, American Express, Alcoa, and 3M Company.

The amount of change in the price of these stocks will be highly correlated, as they are all part of the larger market. Factor analysis will be used to reduce the dimensionality of the 30 stocks in the Dow Jones average. This is being done because I am interested to see which stock’s prices move together.

Data
Data was collected from the website finance.yahoo.com. Data consists of the high, low, opening, and closing price of each of the thirty stocks as well as the volume of each stock for each day. Stocks vary in the length for which they have historical data, as some companies have been public longer than other. As such only the last 1000 trading days are considered in the analysis. This includes all data dating back to November 19, 2004. Rather than consider the actual price of the stock (since some stock prices are much higher or lower than others), the change in stock price from one closing bell to the next is considered for all thirty stocks.

Analysis
Using SAS 9.2, a factor analysis was implemented for the differences in closing prices for the 30 Dow Jones stocks over the last 1000 days. Using a scree plot \cite{scree} and by analyzing the eigenvalues of the correlation matrix, a sufficient number of factors will be chosen. Upon finding the principal components, the varimax \cite{Johnson} method will be used to find a final rotated factor solution.

Results
Keeping five factors, we can see see which stocks load heavily onto which factors by looking at the table. The variables that load heavily onto the first factor include, American Express (AXP), Bank of America (BAC), Citigroup (C), General Electric (GE), General Motors (GM), Home Depot (HD), and JP Morgan (JPM). With the exception of Home Depot and General motors, all of these companies are financial institutions, and General Motors and Home Depot are heavily affected by the availability of credit from these institution as GM sells large ticket items (cars) and HD is heavily tied to people buying houses, and thus affected by the mortgage market. It appears that this first factor explains variation related to the financial sector.

The companies that are heavily loaded onto the second factor include, Chevron (CVX), Disney (DIS), Johnson and Johnson (JNJ), Kraft Foods (KFT), Coca Cola (KO), McDonalds (MCD), Merck (MRK), Pfizer (PFE), Proctor and Gamble (PG), AT and T (T), Verizon (VZ), Wal-Mart (WMT), and Exxon-Mobil (XOM). All of these companies sell items directly to consumers, and the costs involved in each of these transactions with consumers is relatively small. So, it appears this second factor is explaining the variation due to the individual consumer.

The third factor includes Disney, Hewlett-Packard, IBM, Intel, and Microsoft. These companies, with the glaring exception of Disney, are all companies tied to computers. Thus, it appears that the third factor explains variation due to computer industry. While factor four include companies such as Alcoa, Cat, Chevron, DuPont, and Exxon-Mobil. This factor appears to explain variation in the manufacturing market. Both Chevron and Exxon-Mobil appear heavily loaded on both factor 2 and factor 4. This makes sense since both companies can essentially break down their earnings into two components, individual consumer sales and sales to other businesses.

Factor five includes United Technologies by itself, which is interesting because UTX hold such a large variety of companies including, Carrier, Hamilton-Sundstrand, Otis elevators, Pratt and Whitney, and Sikorsky Helicopter.

Conclusions
The movement in stock price of the 30 stocks which comprise the Dow Jones Industrial Average are highly correlated. As such they are a prime candidate for a factor analysis and a dimensionality reduction. Using five factors, we can group the variability in the stock market into categories. Roughly speaking the three categories that explain the most variation are financial, consumer goods, technology. The fourth and fifth factor seem to represent approximately the same dimension, namely, manufacturing and industry.

Using this factor analysis, we no can now view fluctuations in the stock market based on groups rather than the individual stocks. We have reduced the dimensionality of the stock in the Dow Jones from 30 down to 5, while still explaining 60 percent of the variability, greatly simplifying analysis of this stock data.

Future work in this direction could include using more than the past 1000 days of data and possibly including more than 30 stocks in the factor analysis.

Today on Slate, there is an article about Hal Stern’s call for all qunatitative analysts to boycott the BCS. I would like to let everyone know that in addition to Hal Stern and Bill James, the Stats in the Wild Blog is officially joining the boycott. That ought to bring the BCS to its knees.

A few notes about the article:
1. Statistical analysis is fantastic for ranking teams, but I don’t think it should have any place in deciding who wins a national championship. I think it is always preferable to have a deterministic set of criteria to decide who goes to the post season, like all professional sports. That way no one can complain when someone gets into the play-offs. (Except, in the NFL when the criteria lets in 9-7 Arizona and 8-8 San Diego and leaves out 11-5 New England…..) If you want to get in, meet the criteria and stop whining (like me).

In NCAA basketball there are both deterministic criteria (win your league) and at large bids for getting into the tournament. Every year teams are left out of the tournament, but, by including 65 teams, I doubt that any team with a legitamate chance to win a national title has ever been left out. And with the tournament the way it is, it allows team to make great memorable post-season runs. (Remember in 1997 when Arizona was a four seed and they beat THREE number one seeds on their way to a national championship? If NCAA basketball were run like NCAA football Arizona would have won some horseshit bowl game and no one would remember.)

If football went to an 8 (or 16) game play-off, sure good teams wouldn’t get in, but 8 is probably enough teams that you aren’t leaving out anyone who has a real shot to win it.

(Note: These last two notes have nothing to do with statistics and ramble on for much longer than they should. Enjoy.)
2. I hate the NCAA. I hate that young athletes are risking serious injuries and are making no money (except scholarship), while the schools, the administrators, the head coaches, and the television stations are collectively making billions of dollars. The kids see none of this money. And I hate it even more when these scum bag college coaches try to get a kid to stay for a 3rd or 4th year of eligibilty instead of entering the draft. Easy for a coach to say when he is making 3 million dollars a year. If some one was going to offer me a few million a year to do anything when I was a sophomore or junior in college, I would have left in an instant.

3. This is the last paragraph of the article:
“When it doesn’t, you can put the blame on the greedy small schools that wanted to milk money from the big football factories, on the greedy big schools that wanted to keep as much money as possible in the fewest possible hands, on the lunk-head football coaches who can’t program a computer to play tic-tac-toe but want to make all the rules, or on the Congress that sits idly by and watches it happen. You guys want to make a mess of this, you can make a mess of it without our help.”

Listen. I am all for a play-off in college football, but Congress doesn’t need to get involved. If I were to make a list of things that were (or should be) more important to Congress than the BCS and college football, I would never stop writing. You realize we are in TWO wars AND the worst economic crisis since the great depression AND are facing a 1.2 trillion dollar deficit. And you want to fix the BCS? Have some perspective.

Examples of Congress and Senate being ridiculous about footbal:Arlen Specter and T.O., Arlen Specter trying to punish the Patriots, Orrin Hatch whining about Utah’s team, and Cliff Stearns asking for Congress to postpone votes so he can attend the BCS championship game.

A short open letter:
Dear Orrin Hatch, Arlen Specter, and Cliff Stearns,

Grow up.

Sincerely,
The Statsinthewild Blog.

Happy New Year! Here is an article from the Freakonomics blog tracking American’s (un)happiness.

Cheers

Finals are over and I hope to post more regularly again. Here is a quick picture.

This picture, by French engineer Charles Joseph Menard, graphically depicts Napolean’s fateful march to Russia. The width of the line represents how many troops Napolean had at each point on his way to Russia and what makes this graphic so great is just how many different variables are all displayed at once.

Edward Tufte says in his book, The Visual Display of Quantitative Information, “Minard’s graphic tells a rich, coherent storhy with its multivariate data, far more enlightening than just a single number bouncing along over time. Six variables are plotted: the size of the army, its location on a two-dimensional surface, direction of the army’s movement, and temperature on various dates during the retreat from Moscow”.

In the last line of the description below the graph, Edward Tufte says, “It may well be the best statistical graphic ever drawn,” which, in my opinion, may be the best claim ever made about a statistical graphic ever.

Cheers.

For Stanley:
Complete caption of the graphic:
“This classic of Charles Joseph Minard (1781-1870), the French engineer, shows the terrible fate of Napolean’s army in Russia. Described by E. J. Marey as seeming to defy the pen of the historian by its brutal eloquence, this combination of data map and time-series, drawn in 1861, portrays the devastating losses suffered in Napolean’s Russian campaign of 1812. Beginning at the left on the Polish-Russian border near the Niemen River, the thick band shows the size of the army (422,000 men) as it invaded Russia in June 1812. The width of the band indicates the size of the army at each place on the map. In September, the army reached Moscow, which was by then sacked and deserted, with 100,000 men. The path of Napolean’s retreat from Moscow is depicted by the darker, lower band, which is linked to a temperature scale and dates at the bottom of the chart. It was a bitterly cold winter, and many froze on the march out of Russia. As the graphic shows, the crossing of the Berezina River was a disaster, and the army finally struggled back into Poland with only 10,000 men remaining. Also shown are the movements of auxiliary troops, as they sought to protect the right flank of the advancing army. Minard’s graphic tells a rich, coherent story with its multivariate data, far more enlightening than just a single number bouncing along over time. Six variables are plotted: the size of the army, its location on a two-dimensional surface, direction of the army’s movement, and temperature on various dates during the retreat from Moscow. It may well be the best statistical graphic ever drawn.”