Please submit your written report in MS Word and your complete work in Tableau by saving all your work as *.twbx file (Tableau Package Workbook)
you are given a 2003 paper by Frankel and Rose “Is Trade Good or Bad for the Environment? Sorting Out the Causality”
And two datasets:
Data Set 1: Original Data used for the Paper by Frankel and Rose “Frankel and Rose 2003 Data” (this is a
truncated dataset – I removed various unnecessary fields from the original data for this homework)
Data Set 2: Data from the World Bank on CO2 Emissions: “World Bank CO2 emissions Data”
Part 1:
The data set “Frankel and Rose 2003 Data” is already cleaned and ready for analysis but is missing information on CO2 emissions that you will need to complete the assignment. Therefore, I downloaded the CO2 emissions from the world bank and you need to clean the “World Bank CO2 emissions Data” and join it with the “Frankel and Rose 2003 Data”
Part 2:
Now that you have a nice dataset in Tableau that contains all the information you need from both datasets, you can investigate the relationship between environment and trade. (You can also use a Relationship between the two datasets if you don’t want to join them – choice is yours)
1. Use measure “Mean Sulfur dioxide” and “PWT 5.6 Openness” to recreate Figure 1 from the paper – recreate the figure with all the necessary improvements to make the data stand out, the original graph needs improvement, use what we have learned in class. Use the “Institutionalized Democracy Score” measure to create a “Low Democracy” group that has a score less than or equal to 8, and “High Democracy” that has a score higher than 8.
a. Hint1: The figure won’t include all the same countries as some of the values are missing and Tableau will omit them whereas in the paper, they forced some values with some missing information
2. Create the same figure as Figure 1 but with CO2 emissions and Openness (when I mean create the same figure, I mean create a scatter plot with the two new variables that makes the data clearly stand out. The original figure does not make the data stand out and needs improvement; I want your new figure to have all the right improvements that are discussed in the lecture notes and vidoes.)
a. Hint 2: In the first part, Sulfur dioxide was already a Mean variable while here CO2 is not for each country
3. Create a Dashboard with both figures
a. Allow for highlighting between the two figures on the dashboard, that is, selecting one or more countries in one figure, selects them in the second figure on the same dashboard.
4. Comment on the features of your visualizations; that is, how and why you chose to create the visualization you did.
Part 3: Recreate the information in Figure 1a as much as you can; focus on the top 6 graphs only and remake them by making the data stand out. The original figure is not very good, make this information better using 6 graphs that will have similar layout. The goal is to use the lessons we learned in class to make this graph better.
For income, use variable: PWT 5.6 Real GDP per capita "Income”
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
