Netflix

1. Introduction

2.1. Problem

Historically, changes in emissions from fossil fuel combustion have been dominant factor affecting CO2 emission trends in U.S. Student is analyzing CO2 emission data in U.S for various sectors during the period of 1990-2007.

Data Categorization and Source

2.2. The CO2 emission data (measured in Million Metric Tons) is categorized into 5 sectors namely (1) Commercial (2) Electric Power (3) Industrial (4) Residential and (5) Transportation for each year from 1990 to 2007 for each state in USA. The Source of this data is link http://www.epa.gov/climatechange/emissions/downloads/CO2FFC_2007.pdf

2. Following analysis were conducted on this data to explain the trend

3.3. Data analysis shows that the total CO2 emissions in U.S increased by 18% showing an upward

trend of aprox. 1% increase each year. While there were few fluctuations the general trend was upward. (Figure 1)

2.2 Graph (Figure 1a) shows an upward trend in CO2 emissions in all sectors except industrial which shows a downward trend. (Figure 1a)

2.3 Graph (Figure 1b) shows top 5 states emitting highest CO2. Bottom 5 states with low emission rate are Idaho, South Dakota, Rhode Island, Vermont and District of Columbia (Graph not shown in this document). District of Columbia is the only state that has least CO2 emissions.

2.4 The Sectors contributing to maximum CO2 emissions are Electric Power and Transportation. Electric power CO2 emission increased by an average of 41% and Transportation sector increased by almost 35% during 1990-2007. Sectors that contributed to least CO2 emissions are Commercial and residential.

2.5 Pivot table and chart shows average CO2 emissions in U.S and the major sectors that are contributing to the overall CO2 emission. Electric power is maximum at 38% followed by Transportation at 32%.

2.6. Empirical rules do not apply as the actual and expected counts vary and the data does not follow normal...