MLB Standings 2016-2017 Visualization

Consider the MLB (Major League Baseball) Standings 2016-2017 data set. There are two Excel worksheets that contain the 2016 and 2017 standings data. Some important variables in the data set are team names, actual winning percentage (W-L%), and predicted winning percentage (pythWPct). Develop a visualization using Tableau to answer each of the following three questions.

1. Which teams were most under-performing and over-performing their predicted winning percentage in 2016?

2. Which teams’ winning percentages improved the most from 2016 to 2017? Which teams got the second worst?

3. Construct an interesting question and answer it visually. (You may need to search from Google the actual meanings of the abbreviations describing other variables in the data set.)