Inflation and Analyses of Monetary Policies ECO561 WEEK 4, economics homework help

Anonymous

Question Description

Good Evening,

I need this assignment by Sunday 9pm. There is a excel part and a 700 word analysis. I was choosing Starbucks coffee.

Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products.

Use an internet search or the University Library to locate information on the Consumer Price Index (CPI). Internet sites you might find useful include the Bureau of Labor Statistics (BLS) and the Federal Reserve of St. Louis FRED web site although you are allowed to use other sources.

Develop a minimum 700-word analysis of inflation by including the following:

  • Choose a product or service you currently consume/use, such as apparel or educational services, that is included in the CPI's "market basket." Find the annual CPI index numbers for your chosen good or service for the years 1995, 2005, 2010, and 2015. Enter those index numbers in an Excel® file and calculate the percent change (inflation rates) in those index numbers from 1995 to 2005, from 1995 to 2010, and from 1995 to 2015.
  • Analyze the trends in overall inflation over the last five years and whether your income has kept pace with inflation. How has inflation over the last five years affected you and/or your family?
  • Discuss how a business manager, such as a human resources manager, might use CPI statistics.

Cite a minimum of three scholarly, peer-reviewed references.

Format your paper consistent with APA guidelines.

Tutor Answer

textsformoney
School: University of Virginia

Hello,the attachment below is the answer.Thanks for giving your time.Incase of anything let me know.Thank you please

1

Running head: CONSUMER PRICE INDEX

Consumer Price Index

Name
Tutor
Course
Institution
Date

CONSUMER PRICE INDEX

2
Consumer Price Index

Question 1

Choose a product or service you currently consume/use, such as apparel or educational
services, that is included in the CPI's "market basket." Find the annual CPI index numbers for
your chosen good or service for the years 1995, 2005, 2010, and 2015. Enter those index
numbers in an Excel® file and calculate the percent change (inflation rates) in those index
numbers from 1995 to 2005, from 1995 to 2010, and from 1995 to 2015.

Food At Home
The item decided for investigation or analysis from the CPI 'market basket' is a sub-class
of the food category and is known as 'foot at home.' It is comprised of things, for example,
grains, bread shop items, meats, poultry, angle, eggs, natural products, vegetables drinks, sugars
and desserts. This classification was picked due to its pertinence, reasonableness and
straightforwardness in surveying its effect in connection with our assessed normal month-tomonth and yearly utilization at home. This thing makes up what are named as unpredictable
classifications and is barred from the center buyer value record together with items found in the
vitality class. This unpredictability is pleasing in the arrangement exhibited underneath for the
period under survey (Jo, J., and Lusk, J. L., 2016).
Base Year

Subsequent Year

Food at Home

Annual Average
Percentage Change

1995

2005

2010

2015

148.42

189.8

215.84

242.25

0%

28%

45%

63%

CONSUMER PRICE INDEX

3

Annual Average
Percentage Change

63%

45%

28%

0%

INDEX

148.42

189.8

215.836

242.25

FOOD AT HOME CPI ANNUAL AVERAGE

1995

2005

2010

2015

148.42

189.8

215.836

242.25

0%

28%

45%

...

flag Report DMCA
Review

Anonymous
Thanks for the help.

Anonymous
Outstanding. Studypool always delivers quality work.

Anonymous
Tutor was very helpful and took the time to explain concepts to me. Very responsive, managed to get replies within the hour.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors