Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Collect price data for any product, input, or resource. You will need data for 20 years. The years do not have to be sequential.

image text in transcribed
1. Collect price data for any product, input, or resource. You will need data for 20 years. The years do not have to be sequential. There can be gaps, even large gaps in your data. You just need 20 years. If you stumble across a data set with more than 20 years, use them all. If you have a good data set, but are a little short of 20 years, call me to discuss. It is important that the product, input, or resource has remained relatively the same over the years you have collected. For example, milk, bacon, and eggs; oil, coal, and natural gas; plywood, cement, and shingles; etc. are roughly the same today as they were 20 years ago. While computers, cars, and televisions are vastly different. Do not pick something that has changed drastically over the last 20 years. 2. Lay your data out in Excel. At first there should be three columns. These are: Year, Price of the Item you picked, and the CPI for that year. There should be at least 20 rows, one row for every year. 3. Next, use Excel's formulas to create a new row using your nominal data and the CPI to adjust the raw (nominal) price to a new inflation adjusted price. Do this for every year. If you have done it correctly, the farther back in history you go, the farther apart will be the nominal and inflation adjusted price. 4. Next, create a graph of your raw data and your inflation adjusted prices. Years should be on the X axis while the nominal and adjusted prices should be on the Y axis. The XY Scatter plot graph is the easiest way to make this work. A line graph is not appropriate. (Do you know why?) 5. Finally, interpret your results. Has the product you picked moved roughly with inflation? Has it risen faster than inflation? Or has it risen slower that inflation? How do you know

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Economics questions