Get statistical data from our statistical database and analyze the relationship between GDP and government spending/money supply.

Get the data you need from the OECD and World Bank statistical databases, as well as the websites of the Bureau of Statistics and the Bank of Japan.

? GDP

? Financial expenditure

? Money supply (money stock) or monetary base

Get the data and analyze the impact of government spending and the money supply on GDP.

? Trends and tendencies of statistical data using line graphs, etc.

? Consideration of relevance using scatter plots

? Calculation of correlation coefficient

? Regression analysis (optional)

Based on the results of the analysis, consider the effects of fiscal and monetary policies based on the theory of the multiplier effect and the IS-LM model, and summarize them in a brief report.

The data used for analysis can be cross-sectional (multiple countries, single year) or time series (single country, multiple years). Include at least 20 or more observations.

This is the report template, please answer it.

1. Introduction

?

2. Theoretical background

?

3. Long-term trends with line graphs (for each statistic)

?

(analysis of line graph)

4. correlation

?

(Analysis of scatter plots and correlation coefficients)

5.. Demonstration by regression analysis

?

(Regression analysis results)

6. Discussion of analysis results

?

(Consideration based on the above analysis)

7. Conclusion

?

How to create line charts and scatter charts in Excel

Insert tab ? Select Line or Scatter

10000 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 0 5000 10000 15000 20000 25000