Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Public Economic need to do it in Excel.. OECD Fiscal Statistics Please follow the instructions below to download and organize data on fiscal expenditure and

"Public Economic" need to do it in Excel..

OECD Fiscal Statistics Please follow the instructions below to download and organize data on fiscal expenditure and government debt from the OECD statistics site https://stats.oecd.org/. 1. Statistical classification: Public Sector, Taxation and Market Regulation Government at a Glance Government at a Glance - yearly updates (not the 2011-2021 version) After selecting Public finance and economics, select 'General government expenditures as a percentage of GDP' from the 'Indicator' menu at the top of the data screen on the right. Then, select Export Excel from the upper menu and click the 'Export to XLS file' button to download the data. * When you try to open an XLS file received from the OECD for the first time, an error message appears stating that the file format and extension do not match. Ignore it and open it as is. When saving, make sure it is in xls or xlsx format before saving. 1) What was the total expenditure of the Korean general government in 2020 as a percentage of GDP? How many percentage points did this value increase compared to 2007? 2) Which countries had general government spending of more than 55% of GDP in 2020? (It is sufficient to write the answer in a blank cell, or to highlight a value greater than 50%) 3) If the countries with the largest ratio of general government spending to GDP in 2020 are arranged in order, how many places does Korea rank? (For Colombia, New Zealand and Turkey for which there is no data for 2020, the latest available data, i.e., 2019 values, will be used instead)

2. In the same statistical data as in question 1, public finance and economics, this time select 'General government gross debt as a percentage of GDP' from the 'Indicator' menu. Then, download the data in Excel format in the same way as in No. 1. 1) What was Korea's general government total debt as a percentage of GDP in 2019? How many percentage points did this value increase compared to 2007? 2) Which country had the highest ratio of general government debt to GDP in 2020? Which countries have general government debts greater than 100% of GDP? (It is sufficient to write your answer in a blank cell, or to highlight a value above 100%) 3) If the countries with the largest general government debt-to-GDP ratio in 2020 are arranged in order, where is Korea ranked? (For Colombia, Korea, New Zealand, etc. for which 2020 data is not available, 2019 values will be used instead)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: C Thomas,

12th Edition

007760086X, 9780077600860

More Books

Students also viewed these Economics questions

Question

The feeling of boredom.

Answered: 1 week ago