The file S03_15.xlsx contains monthly data on the various components of the Consumer Price Index. a. Create
Question:
a. Create differences for each of the variables. You can do this quickly with StatTools, using the
Difference item in the Data Utilities dropdown list or you can create the differences with Excel formulas.
b. Create a times series graph for each CPI component, including the All Items component. Then create a time series graph for each difference variable. Comment on any patterns or trends you see.
c. Create a table of correlations between the differences. Comment on any large correlations (or the lack of them).
d. Create a scatter plot for each difference variable versus the difference for All Items (Y axis). Comment on any patterns or outliers you see.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Question Posted: