ZuoTi.Pro
Question

The following table sets out the CPI index for each quarter from March 2009 to March...

The following table sets out the CPI index for each quarter from March 2009 to March 2018. Use this information to answer questions 2, 3 and 4 below.
Quarter
Consumer price index; All groups - Quarterly
Mar-2009
92.5
Jun-2009
92.9
Sep-2009
93.8
Dec-2009
94.3
Mar-2010
95.2
Jun-2010
95.8
Sep-2010
96.5
Dec-2010
96.9
Mar-2011
98.3
Jun-2011
99.2
Sep-2011
99.8
Dec-2011
99.8
Mar-2012
99.9
Jun-2012
100.4
Sep-2012
101.8
Dec-2012
102.0
Mar-2013
102.4
Jun-2013
102.8
Sep-2013
104.0
Dec-2013
104.8
Mar-2014
105.4
Jun-2014
105.9
Sep-2014
106.4
Dec-2014
106.6
Mar-2015
106.8
Jun-2015
107.5
Sep-2015
108.0
Dec-2015
108.4
Mar-2016
108.2
Jun-2016
108.6
Sep-2016
109.4
Dec-2016
110.0
Mar-2017
110.5
Jun-2017
110.7
Sep-2017
111.4
Dec-2017
112.1
Mar-2018
112.6
2. Calculate the year-end (or annual) inflation rate for the March 2018 quarter. Show all workings including the formula used. (1 mark) – Maximum number of words 30
3. Using excel calculate the year-end inflation rate for each quarter for the period March 2010 to March 2018. Paste your spreadsheet with the answers into the assignment. (2 marks) – Spreadsheet only
4. Using Excel, prepare a graph of the year-end inflation rate for each quarter for the period March 2010 to March 2018. Paste your graph into the assignment. Make sure you carefully label your graph including an appropriate title, axis labels and legend. (1 mark) – Graph only

business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
The following table sets out the CPI index for each quarter from March 2009 to March...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4...

    Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4 2.42 2010 1 2.72 2010 2 2.53 2010 3 2.61 2010 4 2.84 2011 1 2.95 2011 2 2.79 2011 3 2.93 2011 4 3.03 2012 1 3.44 2012 2 3.2 2012 3 3.3 2012 4 3.36 2013 1 3.79 2013 2 3.56 2013 3 3.74 2013 4 3.8 2014 1 4.24 2014 2 3.87 2014 3 4.15 2014 4 4.18 2015 1 4.8...

  • Suppose you had the following information about the CPI in nation ABC. CPI for each year...

    Suppose you had the following information about the CPI in nation ABC. CPI for each year from 2010-2015 was 85.5, 95.2, 100.0, 108.8, 115.3, and 121.1. a. Calculate inflation from 2010-2011, 2011-2012, 2012-2013, 2013-2014, and 2014-2015. Calculate the rate of inflation to 3 decimal points. Show all work. 5. Suppose you had the following information about the CPI in nation ABC. CPI for each year from 2010-2015 was 85.5, 95.2, 100.0, 108.8, 115.3, and 121.1. a. Calculate inflation from 2010-2011,...

  • s Below is 10 years' data on the Manager's Salary Index (MSI). Year 2008 2009 2010...

    s Below is 10 years' data on the Manager's Salary Index (MSI). Year 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 MSI 93 100 Change in MSI 3.9% 5.0 115 126 1.2 8.3 5.1 12.0 4.5 138 145 170

  • You purchased 100 shares of McDonald's Corp. common stock on 04/01/2009 for $57.49 per share. On...

    You purchased 100 shares of McDonald's Corp. common stock on 04/01/2009 for $57.49 per share. On December 29, 2017 you sold the 100 shares for $172.12 per share. Dividend payment dates and amounts per share for the period of time you owned the stock are shown below. PLEASE SHOW EXCEL FUNCTIONS/FORMULAS (A) Calculate your annual rate of return on this investment. (B) Calculate your annual rate of return without including the dividends in the calculation. You will need to use...

  • Part C: Assorted short questions C1. Multiple choice while the short-run C.1.1 The long-run model determines...

    Part C: Assorted short questions C1. Multiple choice while the short-run C.1.1 The long-run model determines output and model determines and inflation, a. potential, long-run inflation, current output; current b. potential, unemployment; current output; long-run c. current; long-run inflation, unemployment; current d. potential; unemployment; unemployment; current e. current, unemployment; potential output; current | СРІ Quarter Sep-2016 Dec-2016 Mar-2017 Jun-2017 Sep-2017 Dec-2017 Mar-2018 Jun-2018 Sep-2018 Dec-2018 1 109.4 110.0 110.5 110.7 111.4 112.1 112.6 113.0 113.5 114.1 C.1.2 The table above...

  • Using the Consumer Price Index (CPI) detailed in the table below, Year CPI CPI Year 2003...

    Using the Consumer Price Index (CPI) detailed in the table below, Year CPI CPI Year 2003 1989 1990 1991 1992 1993 1994 1995 124.0 130.7 136.2 140.3 144.5 148.2 152.4 156.9 160.5 163.0 2004 2005 2006 2007 2008 2009 2010 184.0 188.9 195.3 201.6 207.3 215.3 214.5 218.1 224.9 229.6 233.0 236.7 237.0 240.0 1996 1997 1998 1999 2000 2011 2012 2013 2014 166.6 172.2 177.1 179.7 2001 2002 2015 2016 Instructions: Enter your responses rounded to one decimal place...

  • Using the data in the table below, calculate the CPI and the inflation rate in each...

    Using the data in the table below, calculate the CPI and the inflation rate in each year, using 2010 as a base year. Instructions: Round your answers to one decimal place. Year Cost of basket () 2010 2011 2012 2013 2014 2015 CPI Inflation rate 20,000 21,600 22,800 26,150 28,845 32,500

  • Using the data in the table below, calculate the CPI and the inflation rate in each...

    Using the data in the table below, calculate the CPI and the inflation rate in each year, using 2010 as a base year. Instructions: Round your answers to one decimal place. CPI Inflation rate Year 2010 2011 2012 2013 cost of basket ($) 18,000 21,500 22,500 26,150 28,850 32,500 2014 2015

  • 7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year,...

    7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year, the 2nd column is the unemployment rate, and the 3rd column is the inflation rate. Plot the data using a scatter plot and argue whether in your opinion, the Phillips Curve has validity. 2001 5.7 1.6 2002 6.0 2.4 2003 5.7 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 4.1 3.0 0.7

  • What is the correlation between year and student population? Year 2006 = 8,860 Students 2007 =...

    What is the correlation between year and student population? Year 2006 = 8,860 Students 2007 = 9,056 2008 = 9,050 2009 = 9,429 2010 = 9,407 2011 = 9,352 2012 = 9,608 2013 = 10,107 2014 = 10,382 2015 = 10,340 2016 = 10,805 2017 = 11,034 2018 = 11,639

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT