Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored 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