Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Economics

Authors: Mark Hirschey

12th edition

9780324584844, 324588860, 324584849, 978-0324588866

Students also viewed these Economics questions