10 Jul Tableaue Assignment
Question Description
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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.