Hello, I have a question no sure if this correct subject but, I was asked the following. The plot in one graph, calculate and plot the federal cash transfer to GDP ratios for each province from 1990/91 to the last available year. I found all data but unsure how to plot data, but in the excel graph don't know how to plot it in one graph. Note I'm only plotting the debt-to-GDP ratio and cash transfers. The years and names are indicated in the table. I'm just having trouble representing the data in a meaningful way. Any help would be greatly appreciated. N.L.P.E.I.N.S.N.B.Que.Ont.Man.Sask.Alber.B.C.Y.T.N.W.T.GDP1990-1991 9,397 2,198 17,765 13,799 156,149 287,517 24,710 21,663 75,264 81,871 1,083 2,236GDP2018-2019 33,291 7,063 44,318 36,784 438,780 861,288 73,465 82,288 342,251 299,698 3,099 5,198 N.L.P.E.I.N.S.N.B.Queb.Ont.Man.Sask.Alber.B.C.Y.T.N.W.T. net debt1990-19913,5502194,7313,23637,55838,4384,7734,6055,6926,312-64-55net debt2018-201915,4142,17515,01114,105176,543338,49625,21111,83427,47742,13411779 cash transfer1990-19911,3983121,5991,4766,9725,7621,6951,5472,3652,096229879cash transfer2018-20191,2237663,6513,44023,41125,0904,4912,5098,0139,0521,1371,459 Debt to GDP ratio1990-1991 37.78 9.96 26.63 23.45 24.05 13.37 19.32 21.26 7.56 7.71- 5.91- 2.47Debt to GDP ratio 22018-2019 46.30 30.80 33.87 38.34 5.34 39.30 34.32 14.38 8.03 14.06 0.36 14.98

We have tried to answer this question by applying simple method that is normally used to represent…

Answered: Hello, I have a question no sure if…

Economics:

10th Edition

ISBN:9781285859460

Author:BOYES, William

Publisher:BOYES, William

Chapter11: Fiscal Policy

Section: Chapter Questions

Problem 19E

See similar textbooks

Related questions

Question

100%

Hello, I have a question no sure if this correct subject but, I was asked the following. The plot in one graph, calculate and plot the federal cash transfer to GDP ratios for each province from 1990/91 to the last available year. I found all data but unsure how to plot data, but in the excel graph don't know how to plot it in one graph. Note I'm only plotting the debt-to-GDP ratio and cash transfers. The years and names are indicated in the table. I'm just having trouble representing the data in a meaningful way. Any help would be greatly appreciated.

		N.L.	P.E.I.	N.S.	N.B.	Que.	Ont.	Man.	Sask.	Alber.	B.C.	Y.T.	N.W.T.
GDP	1990-1991	9,397	2,198	17,765	13,799	156,149	287,517	24,710	21,663	75,264	81,871	1,083	2,236
GDP	2018-2019	33,291	7,063	44,318	36,784	438,780	861,288	73,465	82,288	342,251	299,698	3,099	5,198

		N.L.	P.E.I.	N.S.	N.B.	Queb.	Ont.	Man.	Sask.	Alber.	B.C.	Y.T.	N.W.T.

net debt	1990-1991	3,550	219	4,731	3,236	37,558	38,438	4,773	4,605	5,692	6,312	-64	-55
net debt	2018-2019	15,414	2,175	15,011	14,105	176,543	338,496	25,211	11,834	27,477	42,134	11	779

cash transfer	1990-1991	1,398	312	1,599	1,476	6,972	5,762	1,695	1,547	2,365	2,096	229	879
cash transfer	2018-2019	1,223	766	3,651	3,440	23,411	25,090	4,491	2,509	8,013	9,052	1,137	1,459

Debt to GDP ratio	1990-1991	37.78	9.96	26.63	23.45	24.05	13.37	19.32	21.26	7.56	7.71	- 5.91	- 2.47
Debt to GDP ratio 2	2018-2019	46.30	30.80	33.87	38.34	5.34	39.30	34.32	14.38	8.03	14.06	0.36	14.98

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.