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.
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.
Chapter11: Fiscal Policy
Section: Chapter Questions
Problem 19E
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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
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.Recommended textbooks for you
Economics Today and Tomorrow, Student Edition
Economics
ISBN:
9780078747663
Author:
McGraw-Hill
Publisher:
Glencoe/McGraw-Hill School Pub Co
Economics Today and Tomorrow, Student Edition
Economics
ISBN:
9780078747663
Author:
McGraw-Hill
Publisher:
Glencoe/McGraw-Hill School Pub Co