Reference no: EM13993939

In the excel data set ClassPaper.xls posted on class website you will find data from the WorldDevelopmentIndicatorsdatabase. 

You have data for 126 nations for 10 years from the year 2000 to 2009.

x1 CO2 emissions (metric tons per capita)
x2 Electricity production (kWh)
x3 Electricity production from coal sources (% of total)
x4 Electricity production from hydroelectric sources (% of total)
x5 Electricity production from natural gas sources (% of total)
x6 Electricity production from nuclear sources (% of total)
x7 Electricity production from oil sources (% of total)
x8 Electricity production from renewable sources, excluding hydroele
x9 GDP per capita, PPP (constant 2005 international $) 
x10 PM10 (Particulate Matter pollution), country level (micrograms per cubic meter)
x11 Population Using Microsoft Excel, 

study the relationship between the variables x1 and x9 in the year 2000 and the year 2009. What is your  hypothesis about the relationship between these variables? Use basic statistics to study this (i.e graphs, correlation, linear regression). Between the year 2000 and 2009 has the relationship changed? If "yes", what could have caused this? (You can do the same for variables x8 and x9, or x8 and x9, or x10 and x9).

In the answer, I need the graphs and the regressions

Attachment:- ClassPaper.xls