Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the data in Table 1, answer the following questions: a.Calculate the absolute change in government expenditure on education (as % of GDP) between 2005
Using the data in Table 1, answer the following questions:
- a.Calculate the absolute change in government expenditure on education (as % of GDP) between 2005 and 2020 in Botswana, and also in Sweden and Hong Kong (in percentage points). How do the three countries compare? Include your workings and report your answers to one decimal place.
- b.Calculate the percentage change in (i) government expenditure on education (% of GDP) as well as (ii) government final consumption expenditure (% of GDP) between 1990-2020 in Hong Kong. Include your workings and report your answers to one decimal place.
- c.Use Excel to calculate the average for all three countries in 2020 for both indicators: government expenditure on education (% of GDP) and government final consumption expenditure (% of GDP). Briefly compare each country against the average. Include your workings and report your answers to one decimal place.
- d.Use Excel to create a 'Combo' chart ('Clustered column - Scatter on Secondary Axis' chart type), which displays government expenditure on education (% of GDP) in Botswana, Sweden and Hong Kong in 2020 as clustered columns, while displaying government final consumption expenditure (% of GDP) in Botswana, Sweden and Hong Kong in 2020 as scatter points on a secondary axis.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started