Software
Software used is Microsoft Excel.
Source
Finding Major League Baseball salary through http://www.usatoday.com/sports/mlb/salaries/2014/team/all/ .
Data Extraction
Extracting the data with a simple copy and paste to a notepad.
Process
The process of this was a simple copy and paste to a notepad. After that I upload the file to an Excel and cleaned the data and sorting the data to my preference. The next step was sorting the data by “Salary” largest to smallest for each year. After that filling the team with proper visual analytics colors.
Analyzing the Data
The visualization shows MLB team salaries from each year from 2004 to 2014. Each column represents the lowest (bottom) to the highest (top) paid salaries. All the World Series Championships winners (highlighted orange) are aligned horizontally to easily compare relative team salaries.
I’ve also wanted to show a simple bar chart from 2004-2006 graph made with excel to compare the different visualization techniques.
Both charts have its’ pros and cons. If I wanted something to pop out with a quick glance the first graph would be better, but if I wanted detail data the second graph would be a better choice.
The question we have to ask “Does a higher salary equate to a better chance or more World Series Championships? “
vizualanalytics 