logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Hemant Kumar KhatriStatistics
(/5)

946 Answers

Hire Me
expert
Mark MohammadPhilosophy
(5/5)

615 Answers

Hire Me
expert
Neill BissonnetteData mining
(5/5)

907 Answers

Hire Me
expert
Anuj MittalMathematics
(/5)

806 Answers

Hire Me
Tableau
(5/5)

you are given a 2003 paper by Frankel and Rose “Is Trade Good or Bad for the Environment?

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

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”

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

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

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

293 Experts Online