Assignment: Country-Wise CO Emissions Statistical Analysis (1970-2020)

Objective

Analyze and compare CO emissions data for the world's top 10 economies over the five decades from 1970 to 2020. Apply statistical methods to gain insights into emission patterns and variability, and present your findings in a clear, comparative format.

Assignment Instructions

1. Data Preparation

Obtain a dataset of annual CO emissions (country-wise, from the excel file given to you) and GDP data for countries for the period 1970-2020.

Identify the top 10 countries by GDP, using GDP figures from around 1970 for consistency across the time period.

Filter the emissions dataset to include only these 10 countries.

2. Selecting the Time Frame

Use emission data at decade intervals: 1970-80, 1980-90 and so on till 2020.

Ensure all selected countries have valid data for all these years.

3. Data Analysis

For each of the 10 countries:

Extract annual CO emissions for the 5 selected decade.

Calculate the following statistics using the extracted data:

Mean (Average) CO emissions

Emission variance

Standard deviation

Minimum emission value

Maximum emission value

Structure your results in a summary table (see format below).

4. Table Format

Complete your table as follows (fill with your calculated values): Decade 1970-1980

Country	Mean CO Emission	Variance	Standard Deviation	Minimum	Maximum
United States
USSR/Russia
Germany
Japan
France
United Kingdom
Italy
China
Canada
India

Complete your table as follows (fill with your calculated values): Decade 1980-1990

Country	Mean CO Emission	Variance	Standard Deviation	Minimum	Maximum
United States
USSR/Russia
Germany
Japan
France
United Kingdom
Italy
China
Canada
India

5. Interpretation and Reporting

Briefly interpret your results:

Discuss which country had the highest/lowest mean emissions.

Comment on the countries with the largest and smallest emission variability.

Identify any noticeable trends over time or outlier years.

Suggest possible reasons for observed differences (economic changes, policy, industrialization).

6. Submission

Excel file.

Submit a concise report (2-5 pages) featuring explanations, your summary table, and interpretative comments.

Consider including graphs or charts for visualization

Evaluation Criteria

Correctness and completeness of calculations.

Clear, organized presentation and adherence to the required table format.

Depth and clarity of interpretation.

Note: Ensure all statistical calculations use the same time points (1970, 1980, 1990, 2000, 2010, and 2020) for all countries to allow a fair comparison. Address missing data transparentlyeither by cleaning your dataset or clearly noting omissions.