Homework Help is Here – Start Your Trial Now!
Science
Earth Science
Procedure This entire lab is done in Microsoft Excel. Enter the data and answer the questions about your analysis. Global contributions to CO2 emissions The data table below shows CO₂ emissions (in kilotons) from several countries in 2014. Citation: Olivier, J.G.J., Janssens-Maenhout, G., Muntean, M. Peters, J.H.A.W., Trends in global CO2 emissions - 2015 report, JRC report 98184 / PBL report 1803, November 2015. Country USA China Russia Japan India UK Canada Poland South Africa Brazil Nicaragua Iceland Nigeria CO2 emissions (Ktons) 5334529 10540749 1766427 1278921 2341896 415420 565991 298130 392718 501102 4991 3848 93871

Procedure This entire lab is done in Microsoft Excel. Enter the data and answer the questions about your analysis. Global contributions to CO2 emissions The data table below shows CO₂ emissions (in kilotons) from several countries in 2014. Citation: Olivier, J.G.J., Janssens-Maenhout, G., Muntean, M. Peters, J.H.A.W., Trends in global CO2 emissions - 2015 report, JRC report 98184 / PBL report 1803, November 2015. Country USA China Russia Japan India UK Canada Poland South Africa Brazil Nicaragua Iceland Nigeria CO2 emissions (Ktons) 5334529 10540749 1766427 1278921 2341896 415420 565991 298130 392718 501102 4991 3848 93871

Applications and Investigations in Earth Science (9th Edition)
Applications and Investigations in Earth Science (9th Edition)
9th Edition
ISBN:9780134746241
Author:Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Chapter1: The Study Of Minerals
Section: Chapter Questions
Problem 1LR
See similar textbooks
icon
Related questions
Question
Procedure This entire lab is done in Microsoft Excel. Enter the data and answer the questions about your analysis. Global contributions to CO₂ emissions The data table below shows CO2 emissions (in kilotons) from several countries in 2014. Citation: Olivier, J.G.J., Janssens-Maenhout, G., Muntean, M. Peters, J.H.A.W., Trends in global CO2 emissions - 2015 report, JRC report 98184 / PBL report 1803, November 2015. Country USA China Russia Japan India UK Canada Poland South Africa Brazil Nicaragua Iceland Nigeria CO2 emissions (Ktons) 5334529 10540749 1766427 1278921 2341896 415420 565991 298130 392718 501102 4991 3848 93871
Transcribed Image Text:Procedure This entire lab is done in Microsoft Excel. Enter the data and answer the questions about your analysis. Global contributions to CO₂ emissions The data table below shows CO2 emissions (in kilotons) from several countries in 2014. Citation: Olivier, J.G.J., Janssens-Maenhout, G., Muntean, M. Peters, J.H.A.W., Trends in global CO2 emissions - 2015 report, JRC report 98184 / PBL report 1803, November 2015. Country USA China Russia Japan India UK Canada Poland South Africa Brazil Nicaragua Iceland Nigeria CO2 emissions (Ktons) 5334529 10540749 1766427 1278921 2341896 415420 565991 298130 392718 501102 4991 3848 93871
Procedure • Enter the above data into Microsoft excel or google sheets (keep in mind the directions are for excel). • Put the emissions column in order by clicking on the column above the emissions column, thus highlighting the emissions for each country. Then, right click on the highlighted column and scroll down and select sort then choose "sort largest to smallest." When prompted, select "expand the selection" • Make 2D column chart of the data by highlighting both columns, then select the "insert" menu and select column chart then choose 2D column 2-D Column V Question: List the 5 countries that are the worst offenders and why do you think this is so?
Transcribed Image Text:Procedure • Enter the above data into Microsoft excel or google sheets (keep in mind the directions are for excel). • Put the emissions column in order by clicking on the column above the emissions column, thus highlighting the emissions for each country. Then, right click on the highlighted column and scroll down and select sort then choose "sort largest to smallest." When prompted, select "expand the selection" • Make 2D column chart of the data by highlighting both columns, then select the "insert" menu and select column chart then choose 2D column 2-D Column V Question: List the 5 countries that are the worst offenders and why do you think this is so?
Expert Solution
Step 1: Introduction

The above data shows CO2 emissions from several countries. 

The global emission of CO2 

The task is to make a 2D column chart. 

After choosing ascending order we have to find out 5 countries which are the highest contributors to CO2 emission. 

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Applications and Investigations in Earth Science …
Applications and Investigations in Earth Science …
Earth Science
ISBN:
9780134746241
Author:
Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:
PEARSON
Exercises for Weather & Climate (9th Edition)
Exercises for Weather & Climate (9th Edition)
Earth Science
ISBN:
9780134041360
Author:
Greg Carbone
Publisher:
PEARSON
Environmental Science
Environmental Science
Earth Science
ISBN:
9781260153125
Author:
William P Cunningham Prof., Mary Ann Cunningham Professor
Publisher:
McGraw-Hill Education
Earth Science (15th Edition)
Earth Science (15th Edition)
Earth Science
ISBN:
9780134543536
Author:
Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:
PEARSON
Environmental Science (MindTap Course List)
Environmental Science (MindTap Course List)
Earth Science
ISBN:
9781337569613
Author:
G. Tyler Miller, Scott Spoolman
Publisher:
Cengage Learning
Physical Geology
Physical Geology
Earth Science
ISBN:
9781259916823
Author:
Plummer, Charles C., CARLSON, Diane H., Hammersley, Lisa
Publisher:
Mcgraw-hill Education,
SEE MORE TEXTBOOKS