Please as soon as possible

Topic: How do CO2 emissions vary globally?

Two specific questions:

• Do countries with higher CO2 emissions also have largeagricultural sectors?

• Do CO2 emissions vary by geographicregion?

This is an Excel file:https://drive.google.com/file/d/1R5pArnQ062_uNKHTHyJ0odioGrpQmnvn/view?usp=sharing

Read the dataset into R and extract the data that you will needfor this analysis. You can extract the columns by referring to themby name or by number. Provide the code that you use to do this.

Example:

#Read CSV file

allglobal <- read.csv(file.choose())

#Extract chosen columns using names

Assignment 2 global <- allglobal[, c("Country", "Region","GDP", "TaxRevenue")]

#Extract chosen columns using column numbers global <-allglobal[, c(1, 3, 12, 30)]

#Inspect data head(global)

Explore your two questions using appropriate summary statisticsand graphs. The following structure is recommended for eachquestion:

• Clearly state the question being analysed (e.g. with aheading)

• Summary statistics and graphs. In the example above,you might use R idiom such as

– mean(global$GDP) or maybe median(global$GDP) (why thedifference)?

– hist(global$GDP)

– boxplot(GDP~Region, data=global) . . .

although in this case you might be better off using logarithmicaxes, boxplot(GDP~Region, data=global, log=’y’)

you should include at least 3 different types of graphsand 4 different summary statistics. Marks will only beawarded if the graphs, summary statistics and explanations arecorrect and appropriate.

Thank you so muuch!!