Question
1. Find growth rate of commercial and industrial loans. Google commercial and industrial loans fed. Download monthly non-seasonally data. Use start date of January 1970.
1. Find growth rate of commercial and industrial loans.
Google commercial and industrial loans fed. Download monthly non-seasonally data. Use start date of January 1970. Download the data. Calculate the annual growth rate of the loans updating on a monthly basis. Graph the year over year change for every month. Then calculate the sample mean. Graph the sample mean on the same graph.
2. Find Household Debt Service Payments as a Percent of Disposable Personal Income
-
Google household debt service payments as a percent of disposable personal income and Fed.
-
Click the St. Louis Fed link.
-
Download the data and graph the data in Excel.
-
Calculate the annual growth rate on a quarterly basis and its two year moving average.
-
-
3. Find real growth rate in money supply.
-
Google M2 Fed. Click on first link. Click Monthly Non-Seasonally Adjusted. Download from 1970 to the present. Calculate the annual growth of M2 stock updating on a monthly basis.
-
Google CPI Index Fed. Click on first link. Click on monthly Non-Seasonally Adjusted under Consumer Price Index for All Urban Consumers: All Items. Download from 1970 to the present. Calculate the annual growth rate of CPI index updating on a monthly basis.
-
Subtract the difference between the M2 and CPI growth rate to calculate the real growth rate in M2.
-
Calculate the four year moving average of the real growth rate in M2.
-
Plot the real growth in M2 and its 4 year-moving average.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started