Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION I The Distributions of Household Economic Accounts by Statistics Canada provide important insights into the trends in household economic well-being and income inequality in
QUESTION I The Distributions of Household Economic Accounts by Statistics Canada provide important insights into the trends in household economic well-being and income inequality in Canada. The related table can be found at: https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3610058701 The table is labelled as "Distributions of household economic accounts, income, consumption and saving, by characteristic, annual (x 1,000,000)". Note that all figures listed in the table are on an annual basis and are measured in millions of dollars. You can easily change the default choice under "Characteristics" and "Reference Period" from the dropdown menu. By pressing the "Apply" button, the table will be updated to reflect your choices. In addition, the table allows you to Add Remove data and provides various download options to you. All your calculations and plots for this assignment should be performed using the Microsoft Excel software package. a. Change the "Reference Period" from the default one to the period 1999-2020 which is the longest period publicly available. This period applies to all parts of this assignment. Download the "Household Disposable Income" series for the five quintiles: lowest, second, third, fourth and highest. The series represent the income earned by each quintile in a given year net of taxes paid to the government and including transfers received by the government. Note that the five quintiles are all listed in the "Characteristics" tab. i. Calculate the percentage annual change in household disposable income by income quintile. Please use the formula for the annual change rather than the approximation provided by the logarithm of the series. ii. Plot in a single figure the percentage annual changes calculated in part (i) for all income quintiles against the year. iii. Comment on the figure in part (ii) focusing on the change in disposable income between the last two years in the sample
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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