# Green House Gas emissions Excel Based Project

Description

1 attachmentsSlide 1 of 1attachment_1attachment_1.slider-slide > img { width: 100%; display: block; }
.slider-slide > img:focus { margin: auto; }

Unformatted Attachment Preview

chart using real-world data you retrieve from the internet. The subject of
the chart can be anything related to economics, the pandemic, the
election, climate change, sports, entertainment, or whatever you find
interesting. First, you will need to collect the raw data to create your
chart, and below I will give some examples of places to look for data
that can easily be imported into Excel. You will submit your chart as an
Excel file to Canvas when you are done. Your chart can either be a
histogram or a scatterplot.
Option 1: Histogram
If you so choose, your chart may be a histogram. We learned how to
make them in Excel lab 3, so you may want to revisit that lab.
Remember, a histogram isnt simply a bar chart. Instead, it depicts how a
sample (or population) of data is distributed. So each bar of a histogram
measures the number of observations that lie in a predetermined data
range (the bin range). To construct your histogram, you will need to
choose the size of the bin ranges yourself. Just make sure that you dont
have too many or too few bins. The chart should convey some useful
short 2-3 sentence description of what the histogram shows.
Here is an example for how the final chart should look. I made the
histogram below to show the age distribution of people who have died of
COVID-19 during the November 8-14 period of 2020. I found the data
on the website for the US Centers for Disease Control and prevention.
Note, you must include the data and a link to its source along with your
chart.
Option 2: Scatterplot
Alternatively, you could create a scatterplot. We made this type of chart
in Excel lab 4. For this chart you will need to find a data set that has two
separate measures for a cross-section of entities (individuals, countries,
firms, industries, etc.). In other words, your data set should measure of
two characteristics of your chosen entity at a single point in time. For
example, you could use geographic and economic data for states, cities,
or countries from a particular year. Alternatively, the data could at the
micro level and cover individuals, firms, or economic sectors. Below is
an example scatterplot that shows the relationship between the death rate
from air pollution and GDP per capita for countries on the African
continent in 2015. Notice how there are two measures (death rate and
GDP) for the countries, each of which are represented by blue a dot.
Some suggestions
Here are some places on the internet with easily accessible data in the
Excel format:
https://www.data.gov (Lots of US government data, just enter a search
term)
https://fred.stlouisfed.org (US Federal Reserve economic data)
https://www.census.gov (US Census data)
https://ourworldindata.org (Various data sets across many subjects)
https://covidtracking.com/data (Pandemic data)