70.2K

Verified Solution

Link Copied!

The table is labelled as "Distributions of household economic accounts, wealth, by characteristic, quarterly (x,000,000)n. Note that all figares fisted in the table are on a quarterly (3 months) basis and are measured in millions of dollars. Net worth or wealith is measured as the difference between a houschold's total assets and its liabilities. 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 from the second quarter of 2022 (2022: Q2) up to the second quarter of 2023 (2023: Q2). This period applies to all parts of this assignment unless explicitly stated otherwise. How much has aggregate houschold wealth changed in terms of monetary value between: (i) 2022: Q2 and 2023: Q2, and (ii) between 2023: Q1 and 2023: Q2? (2 marks) b. Obtain the share of wealth for the highest wealth quintile (top 20\%) as of 2023:Q2 and compare it with the combined share for the lowest and second wealth quintiles for the same 1 quarter. Note that the latier share accounts for the wealth of 40% of all houscholds in Canada. How do these shares compare to their values in 2023: Q1? (2 marks) c. Select the "Value per household" option under the Statistics tab to obtain the relevant dafa for the average bousebold in each wealth quintile for 2023: Q2. What is the average value of financial assets for the two lowest wealth quintiles combined and how does it compare to that for the avenage household in the highest wealth quintile? What about real estate? (2 marks) d. Consider now the average household for the following four wealth quintiles: (1) the combined lowest and second wealth quintile, (2) the third wealth quintile, (3) the fourth wealih quintile - four quintiles calculate

Answer & Explanation Solved by verified expert

See Answer