Excel Help: Creating differences, time series graphs, table of correlations, and scatterplot

[asarge02]

[TABLE="width: 64"]
<tbody>[TR]
[TD]The file P03_15.xlsx contains monthly data on the various components of the Consumer Price Index. 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 scatterplot for each difference variable versus the difference for All Items (Y axis). Comment on any patterns or outliers you see.

Please use the URL below to access the file referenced above. Once at the URL page, select:
Student Downloads>Problem Files Zip Drive>Chapter 3> File: P03_15.xlsx.

URL: Book Companion Site

Thank you![/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[shg]

We don't do homework. Do you have a specific question?