Question: Question 2-5: Complete questions 3-5 below and submit your answers in one Microsoft Word document. Do not submit your work as an Excel spreadsheet. If

 Question 2-5: Complete questions 3-5 below and submit your answers in

one Microsoft Word document. Do not submit your work as an Excel

Question 2-5: Complete questions 3-5 below and submit your answers in one Microsoft Word document. Do not submit your work as an Excel spreadsheet. If you use Excel to make your numeric calculations, copy and paste the work as a table into the Microsoft Word document for submission. Files that are not submitted in Word format will not be opened or graded. Number all question parts correctly and clearly. When you are done with your word document, type the phrase "See below\" in the textbox below and then upload your saved Word document. Q2. Go to the Statistics Canada website https:/www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000501 to view the annual average Consumer Price Index for Canada. Change the Reference period years from 1999 to 2021 and click Apply to see the updated data table. Answer the following questions and provide data and calculations where necessary. (20 points) 1. What is the CPI base year being used and what is the value of the index in that year? 2. Calculate the rates of inflation between 2018-2019 and 2020-2021. Round your answer to two decimal places. 3. Which product category had the highest price level changes since the base year to present? Which category experienced the lowest price level increases? Any explanations for both price level changes? 4. By what percentages have the price of food, shelter and household furnishings changed from the base year to the most current period? What about from 2019 to the most current year? 5. In which ways might the CPI data on food not accurately reflect what is really happening to prices in this product category

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!