Assignment #1 is attached... Assignment #2 is the next step from Assignment #1.Instructions and template is attached.

1. Extract the attached Excel file called WORLDBANKSBUX2015.xlsx into a Tableau workbook. Exclude all records for which ROLLUP=1. (I.e, Keep only those records for which ROLLUP=0.)2. Create a plot that depicts the relationship between the log transform of GDP per Capita (on the horizontal axis) and the log transform of Life Expectancy for All (on the vertical axis). Set the size of each plot point to reflect the Population of its country. Include Country Name as detail in the Marks card.3. In a separate worksheet create two scatter plots (on the same worksheet) that show separately the log-scale relationship between Life Expectancy for Women v GDP per Capita and Life Expectancy for Men v GDP per Capita. Size each scatter point by Population. Include a trend line (with confidence interval) in each plot.4. On a third worksheet generate a Tree Map that displays GDP per Capita as the tile size. Set the color of the tiles to reflect country Population; edit the Color options to use Red-Blue Diverging palette, centered at 100,000,000. Include CCountry Name as a label.5. Create a Symbol Map in a separate worksheet that depicts GDP per Capita by the size of a circle and Life Expectancy (for ALL) by the color of the circle. For color use the Green-Gold palette. Create a filter that excludes all countries whose Life Expectancy value is missing or null. Edit the Size of the circles to increase the size at the smallest end of the range of GDP per Capita values.6. Create a filled map that depicts GDP per Capita by the color of each country. Use the Red-Blue Diverging palette, centered on 20,000. Overlay a Circle that depicts Life Expectancy (ALL) by Size. Create a Filter in the worksheet that excludes all countries that do not have at least 1 Starbucks store. 7. Submit your work in a .twbx file.

Temperature patterns seen to be changing around the U.S. Winters seem shorter, summers seem hotter, and major storms seem more frequent. Let’s collect some data and look at what’s happening in your area. You can use the Weather Underground web page at www.wunderground.com to collect historical data for a particular city. The Weather Underground (www.wunderground.com) was created by a student/professor team at the University of Michigan and shortly became a public company providing current and historical weather data for the United States and other countries. At the top of the Weather Underground home page you will find a box for entering the name of a city, state or country. Enter your home city to see the current weather conditions there. Scroll down and select the History & Almanac Table in which you can enter a date to see statistics for any day from the past thirty years. Below the field where you enter a specific date you can select Calender View and see all temperatures for a specific months.We want to collect the Max. Temperature reading for each day in your home city or a city near you in February (for cold temperatures) and August (for hot temperatures) for a minimum of 3years.