• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 7 pages
Exam (elaborations)

ECS3709 Assignment 2 (COMPLETE ANSWERS) Semester 2 2026 - DUE 4 September 2026

Document preview thumbnail
Preview 2 out of 7 pages

ECS3709 Assignment 2 (COMPLETE ANSWERS) Semester 2 2026 - DUE 4 September 2026; 100% TRUSTED Complete, trusted solutions and explanations. For assistance, Whats-App 0.8.1..2.7.8..3.3.7.2... Savings, investment and economic growth [9] Use the data provided for the assessment to answer the following questions: (a) Calculate the correlation coefficient between savings and growth in each of the following Sub-Saharan African countries. Hint: Use the ‘correlation’ function of the Microsoft Excel data analysis tool: Botswana Kenya Provide the screenshot of the correlation results table for each country. (2) (b) Based on the results from (a), compare the correlation coefficients for the two countries and explain your findings. (1) (c) For each of the countries, perform a regression analysis where GDP, is modelled as a function of Savings and Investment. You thus need to run two separate regressions, one for Botswana and one for Kenya. You can make use of the Microsoft Excel data analysis tool, or you can use EViews. [Hint: you must first transform each variable using the logarithm, i.e. ‘log’ function]. Provide the screenshots of your summary output. (4) (d) Based on regression results from (c), compare and discuss the impact of savings and investment on economic growth in Botswana versus Kenya. (2) Q2 Technological progress [6] (a) According to the Solow model, long-run economic growth is determined by technological progress (A). Based on what you have studied about the production function, Y=F(K,AL), mention and explain two assumptions about technological progress. (4) (b) Use the IMF Data Mapper to provide a screenshot showing technological progress in Botswana and Kenya. As proxy for technological progress, you must use the AI preparedness index for ‘Human capital and labour market policies’. Compare the data for the two countries and provide a conclusion.

Content preview

ECS3709
Assignment 2 Semester 2 2026
Unique number:
Due date: September 2026


QUESTION 1: Savings, investment and economic growth [9]

1(a) Correlation between savings and growth [2]

The correlation coefficient was calculated using annual data from 1990 to 2024.
GDP was used as the measure of economic growth because the assessment
dataset provides GDP together with savings and investment. The Excel correlation
formula used was CORREL, and the detailed workings are included in the
accompanying Excel file.


Country Correlation between Savings and GDP


Botswana 0.919229


Kenya 0.957545

, QUESTION 1: Savings, investment and economic growth [9]

1(a) Correlation between savings and growth [2]

The correlation coefficient was calculated using annual data from 1990 to 2024. GDP
was used as the measure of economic growth because the assessment dataset
provides GDP together with savings and investment. The Excel correlation formula
used was CORREL, and the detailed workings are included in the accompanying
Excel file.


Country Correlation between Savings and GDP


Botswana 0.919229


Kenya 0.957545


Botswana correlation results




Figure 1: Excel correlation output for Botswana

Kenya correlation results




Figure 2: Excel correlation output for Kenya

1(b) Comparison of the correlation coefficients [1]

Both countries show a strong positive relationship between savings and GDP.
Botswana has a correlation coefficient of 0.919229, while Kenya has a slightly higher

Connected book
 image
Christian A. Conrad Applied Macroeconomics
Publisher: 2022 ISBN: 9783658393151 Edition: Unknown

Document information

Uploaded on
March 10, 2026
File latest updated on
September 3, 2026
Number of pages
7
Written in
2026/2027
Type
Exam (elaborations)
Contains
Questions & answers
R75,00

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
EduPal
4,2
(14448)
Sold
154658
Followers
36028
Items
5227
Last sold
4 hours ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their exams and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can immediately select a different document that better matches what you need.

Pay how you prefer, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card or EFT and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions