PART 2 The country representatives have accepted the proposal. Please go ahead with carrying out the activitiesftasks mentioned in the proposal {part 1}. In addition to the activities stated in {part 1}, the representatives would also like us to include the following items in your report: 1. Explore the relationship across a pair of different aspects of the country over time. For example, is there a relationship between the population and the environmental indicators over time? Can this relationship be quantied? Note, that the choice of aspects could be inuenced by the available data. 2. Construct a condence interval for one of the aspects. Please state all assumptions clearly and provide an interpretation of the interval. 3. Are there any legal or ethical issues with the data that is being used in the report? Please provide some detailsfjustication. These three requests must be incorporated into the methodology section i.e. update the methodology section from part 1 . As before, we are expected to apply the knowledge from the unit modules to address these requests. One of the main features of the final report is the results of the analysis. For this section the expectation is to produce a dashboard using the data for the country mentioned in PART 1. The dashboard is simply a collection of different types of graphs (similar to the ones in our lab work). The emphasis is presenting the data using the different types of plots such as time series plots, scatter plots, histograms, box plots andfor cumulative percentage charts. Ensure that the plot type is matched well the data is being used. In addition to this, results should also include numerical data summaries as well as the analysis pertaining to the first two requests. Lastly, it is very important that we provide brief commentary on all plotslresults of the analysis. The commentary is expected to be based on the content covered in the unit. The final report should be the following components: Cover letter - Update from part 1 : This should now also include an updated statement about what the report is about. It should explicitly state any changes (if applicable} that was have made since the original proposal. Executive Summary - A brief outline/summary of what the report contains. This summary must be 1 sheet. This summary must not contain any plots andfor tables. It is strongly advised that this section be written at the and once all the other sections have been finalised. Introduction - Update from part 1 {Proposal section): Incorporate the coverage of the new requests. Methodology - Update from part 1: Please include the methodology for addressing the three new requests. Results - Flefer to the description of this section on the first page, Conclusion 8: Recommendations - Adequately summarise the main results of the analysis and propose recommendation/suggestions for future work. For example, what (in the expert opinion} would be possible if there was more time and resources References - Just provide the links Cover Letter: Strategic Plans for the Equatorial Guinea targeting issues on Population, Macroeconomic indicators, Environmental indicators, COVID-19 impact Dear Sir/ Madame, I, [your name], a consultant, wishes to submit this proposal to the government of Equatorial Guinea. This proposal aims to help the country prepare country-level profile which can be used to assist policy makers in preparing strategic plans for the country. I believe that I have the necessary data management and analysis skills to carry out this task. I have evaluated some issues that the citizens living in Equatorial Guinea are facing. I will tackle some aspects in population, macroeconomic indicators, environmental indicators, and COVID-19 impact. Yours faithfully, [your name], Consultant Proposal/ Discussion on Population in Equatorial Guinea Equatorial Guinea or the Middle Africa's population reaches about 1,410,419 as of September of this present year equivalent to 0.02% of the total world population. This data is based on Worldometer elaboration of the latest United Nations data. The country's population continues to grow rapidly and is expected to continue in the years to come. However, the country is still on track when it comes to the ratio of the land and population. Based on my readings, the population of males in the country is far more than that of females, Macroeconomic Indicators Equatorial Guinea has been previously known to be dependent of the commodities like cocoa, but now enjoys a purchasing power parity. This country is no longer one of the "least" developed country. Their GDP or Gross Domestic Product value represents 0.01 percent of the world economy making them out of the "least" developed country status. Despite its great economic progress, the country is still struggling to improve its wealth distribution. There is ongoing additional development of existing commercially viable oil and gas deposits as well as new exploration in other offshore concessions. It is also suggested that this country would reinvest some oil revenue into agriculture which is a good thing to gain a better growth in the country's economy and because this is their main economic driver.Environmental Indicators Equatorial Guinea boasts a wealth of natural resources, including forests, arable land and mineral resources, namely gold, oil, uranium, diamonds and columbite-tantalites. Equatorial Guinea also has other largely unexploited human and natural resources, including a tropical climate, fertile soils, rich expanses of water, deepwater ports, and an untapped, source of labor. However, their Agriculture which is cocoa has never fully recovered. This country can also focused on this aspect aside from reinvesting in oil because this can potentially help their agricultural industry grow. COVID 19 Impact Like all other countries, Equatorial Guinea has implement safety measures to aid the spread of the virus. Restrictions and health measures in place, restaurants, shops, places of worship, and hotels will be allowed to reopen, provided they follow hygiene standards. Nightclubs and entertainment venues remained closed. Their economy was greatly affected as well. STRATEGIC OPTIONS Trade: Equatorial Guinea's top exports are Crude Natural ($3.65B), Petroleum Gas ($1.3B), Acyclic Alcohol ($377 M), Rough Wood ($343 M) and Gold ($17.5 M). The fisheries sector of the REG comprises 314 000 km2 of an exclusive economic zone (EEZ) and 644 km of coastline and many bays, rivers and mangroves. These geographical features, as well as the structure of the maritime sector and the proper development of the inland river system; Allow the country to benefit from its abundant fishery resources. Potential fisheries resources Approximately 74 000 tons of fish and 600 tons of crustaceans, of which approximately 5 000 tons are estimated. In the same vein, Equatorial Guinea has an agricultural potential that can allow it to do so. Ensure its food safety. The region's economy was dominated by agriculture. The richness was primarily derived from the export of wood, cocoa and coffee. Methodology: To be able to thoroughly expand this proposal, and discuss all other issues, the need for conducting interviews and surveys will be implemented in Equatorial Guinea. And an in-depth research and article reading was also done to justify all the facts stated in this proposal.Part 1 (10%) - Prepare a Proposal As a consultant, you are submitting a tender/proposal to a government of a country to help them prepare a country-level profile (in the form of a final report). You believe that you have the necessary data management and analysis skills to carry out this task. Country level profiles are used to assist policy makers in preparing strategic plans for the country. In the first stage of this project, you will prepare a tender/proposal which will explicitly outline the information that you will include in the final report (part 2 of the project). Your proposal will consider the following aspects of the country: 1. Population 2. Macroeconomic indicators 3. Environmental indicators 4. COVID-19 impact In addition to the above, you are required to choose another aspect of your choice which you think is unique to your country and will help in its development. Examples of this include main industries, technological capability, human rights information etc. All the aspects listed above are quite broad. It is up to you to select what you think it appropriate for the policy makers. For example, when presenting the country's population information, we could choose to focus on population growth, age group distribution or gender distribution. Additionally, with most of the data being time series, you will also need to decide what time horizon you want to focus on. For example, in the population case, do you want to consider all the data available (all years) or only the recent years. Please provide very brief reasons for your choices.The proposal will consist of the following sections: 1. Title page 2. Cover letter - A very brief letter outlining your case for assisting in the preparation of the country level profile. 3. Table of contents 4. Proposal - What will be included in the final report? Briefly, describe why this work is important. 5. Methodology - Specific details on how the information will be presented (relate to materials in module 2 and 3). Also included here will be the details on data sources and definitions (module 1). You may also include any limitations on data availability (if applicable)