Using the same website, retrieve data at the beginning of the last 20 quarters for interest rates
Question:
Using the same website, retrieve data at the beginning of the last 20 quarters for interest rates (based on the three-month Treasury bill rate) and the producer price index for all commodities and place the data in two columns of an Excel spreadsheet. Derive the change in interest rates on a quarterly basis. Then derive the percentage change in the producer price index on a quarterly basis, which serves as a measure of inflation. Apply regression analysis in which the change in interest rates is the dependent variable and inflation is the independent variable (see Appendix B for information about applying regression analysis). Explain the relationship that you find. Does it appear that inflation and interest rate movements are positively related?
Step by Step Answer: