Your cart is currently empty!
ECON 1035 – BUSINESS STATISTICS 1 Assessment 3 Individual Assignment
$ 10.00
ECON 1035 – BUSINESS STATISTICS 1 Assessment 3 Individual Assignment Instructions:This is an individual assignment with a total of 40 marks. The allocation of marks is asfollows:Statistical Analysis with Excel File:32Professional Report:8Total:40Report Structure The response must be provided in the form of a professional report with no more than 10pages (excluding the cover page).The structure…
Description
ECON 1035 – BUSINESS STATISTICS 1 Assessment 3 Individual Assignment
Instructions:This is an individual assignment with a total of 40 marks. The allocation of marks is asfollows:Statistical Analysis with Excel File:32Professional Report:8Total:40Report Structure
The response must be provided in the form of a professional report with no more than 10pages (excluding the cover page).The structure of your professional report must include:
A Title,
An Executive Summary,
An Introduction
,Analysis, andConclusions.Submission You must submit anelectronic copyof your assignment on Canvas.See the attached Template of your submission for more details.Excel fileThis assignment requires the use of Microsoft Excel.You will also be using Data AnalysisTool-Packto complete the assignment.You need to submit the Excel file along with your report. The excel file needs to be clear andcarefully organized and must show all workings underlying the Professional report andassociated statistical analysis. It will be treated as an appendix to your report, i.e., notincluded in the page count.DO NOTleave your responses in the Excel workbook.You will need to take the relevantresults from your Excel workbook and incorporate into your report. The report needs to bestandalone.Presentation Instructions:Your written professional report should comply with the following presentation standards:1)Typed using a standard professional font type (e.g. Times Roman), 12-point font size.2)1.5-line spacing, numbered pages, and clear use of titles and section headings.3)Delivered as a Word (.doc or .docx) or PDF (.pdf) file.4)Checked for spelling, typographical and grammatical errors. Where relevant, round to 3decimal places.5)With all relevant tables and charts, the report should be no more than 10 pages long.RMIT Classification: Trusted
Problem Description:This is a further analysis ofCarbon Dioxide (CO2) emissions with an objective to investigatethe factors that influence carbon emissions. Governments worldwide have been promotingthe use of renewable energy as a strategy not only to increase access to electricity but also toreduce environmental degradation because of its lower level of carbon dioxide emissions.Toformulate effective policies to mitigate carbon emissions, it is crucial to understand thefactors that influence it.
Since this is an additional analysis on CO2 emissions, the content in the Introduction sectionof your report may overlap with the one in the Group Assignment. However, you areencouraged to develop/source new background materials that align with the objective of thecurrent analysis. You will use a similar dataset as in Assignment 2 but with some additionalinformation. The data are drawn from the World Bank database for year 2015. The sampleused for analysis comprises of57 high-income countries (HIC) and 130 low- or middle-income countries (LMIC),as per the World Bank classification of world economies. Thedataset contains the following information:1
.CO2: per capita carbon dioxide emissions (metric tons)
2.group: the dummy variable group = 1 if it is a high-income country (HIC), and = 0 ifit is low- or middle-income country (LMIC).
3.urban:the dummy variableurban= 1 if the country is highly urbanised (i.e 70% ormore of the population live in urban areas), and = 0 if the country is not highlyurbanised
4.dense:the dummy variabledense= 1 if the country is densely populated (i.e morethan 200 individuals live in 1 square kilometre of land area), and = 0 if it is notdensely populated.5.GDP: per capita GDP, in USD1000, at constant 2015 prices6.renewable: share of renewable energy consumption out of total energy consumption(in %)Key instructions to follow:1.Locate the data file (IndividualAssignmentData.xls) on CANVAS.2.Use the5%significance level where relevant or not specifically mentioned.3.While explaining your findings, please ensure that youexplain both statisticalfindings and provide interpretations in the context of the scenario.[Marks distribution:32 marks for statistical analysis + 8 marks for presentation]1.Before estimating the regression equation,using the full sampleconduct a preliminary analysis of the relationship between CO2 emissions and each of the following variables:1)renewable; 2)GDP; 3)urban; and 4)dense.Use tables and/or appropriate graphs forthe categorical variables (urban, dense) and the continuous variables (GDP, renewable).Make a scatter graph for CO2 emission to all the variables (4 scatter graphs) use the graphto answer the 4 parts in question 1.Interpret your findings by answering the following questions:a)Are CO2 emissions higher in urbanised countries? Scatter graph
