: Go to FRED database at https://fred.stlouisfed.org and search for the following data: Real Personal Consumption...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
: Go to FRED database at https://fred.stlouisfed.org and search for the following data: "Real Personal Consumption Expenditures", "Real Gross Private Domestic Investment", and "Real Gross Domestic Product" when obtaining ratios. (use these terms exactly, and then check that the data is as described above: seasonally adjusted, real, quarterly, etc.). Hint: for each figure start by looking only for one of the above series, such as consumption or investment (do not plot GDP, since that is needed to obtain the ratios only in Figure 2), and then click on it to obtain the plot. Again, make sure you are choosing the correct format of the series. Then click on "edit" to add additional data and to manipulate each series to obtain a ratio. Step 2: To add the other time series click on "add line" and specify the series that you want to add. Again, make sure to get the correct series (quarterly & seasonal adjusted). Step 3: For Figure 2: Convert each series to a ratio since the goal is to obtain "consumption to gdp ratio" & "investment to gdp ratio". To do this you will need to have both Consumption and Investment in your figure (so basically as you did for Figure 1), and then you will need to "customize the data", which is done by first clicking on edit graph and then scrolling down to where it states "customize the data". Follow the instructions on FRED (note that this is where you want to "add" real GDP and then write the formula to modify/customize the series and obtain the ratio; you will need to do that both for Consumption and for Investment). Check that you have quarterly data for all series before customizing. Lastly, when you customize data, at first your results on the figure may look odd since the units of the variables that are still in levels (in real $) are NOT the same as the units of the variables that have been "customized" to ratios; so customize both C and I to get the right figure. Step 4. Download the figure. Step 5: provide a discussion of the data (what you observe across time), how the two series differ in magnitude (in each figure), etc. Make sure to discuss the past as well as the last few quarters and to incorporate specific numerical values into your narrative. The goal is to describe the data as you see it in the diagram; you don't need to explain any events that may have caused the movements. Must be 250 to 300 words. [7 points.] This question will require that you use the FRED database. The link is posted on iLearn. Your goal in this question is to obtain TWO diagrams with two variables (on the same graph). The first figure will have Personal Consumption Expenditure & Private Gross Investment, and the second figure will have the above variables expressed as % of GDP: i.e. Consumption to GDP ratio & the Investment to GDP ratio. The figures use similar data, and both figures requires TWO series to be plotted on the SAME diagram. Note that to obtain the RATIOS you will need to use data on real Consumption, real Investment, AND real GDP; the ratios must be generated in FRED directly using the three series. Both ratios (Consumption to GDP ratio & Investment to GDP ratio) must be plotted on a single diagram. Lastly, a discussion of the data must be submitted along with your diagram. See below for further instructions. Before starting, I strongly recommend watching the video on Canvas on how to navigate the FRED website. Note: you are not required to do everything I do in the video; the video is designed to introduce students to FRED and to give you an idea what can be done when navigating FRED; it is not designed for this specific assignment, but it will be helpful to you. If you have questions you should email me or stop by my office hours. Data characteristics: Use data from 1970 to the present; seasonally adjusted; and at quarterly frequency. Figure 1: Plots Consumption and Investment (in $). Both time series must be plotted on a single diagram. Figure 2: Plots the Consumption to GDP ratio & Investment to GDP ratio (in %). Both time series must be plotted on a single diagram. : Go to FRED database at https://fred.stlouisfed.org and search for the following data: "Real Personal Consumption Expenditures", "Real Gross Private Domestic Investment", and "Real Gross Domestic Product" when obtaining ratios. (use these terms exactly, and then check that the data is as described above: seasonally adjusted, real, quarterly, etc.). Hint: for each figure start by looking only for one of the above series, such as consumption or investment (do not plot GDP, since that is needed to obtain the ratios only in Figure 2), and then click on it to obtain the plot. Again, make sure you are choosing the correct format of the series. Then click on "edit" to add additional data and to manipulate each series to obtain a ratio. Step 2: To add the other time series click on "add line" and specify the series that you want to add. Again, make sure to get the correct series (quarterly & seasonal adjusted). Step 3: For Figure 2: Convert each series to a ratio since the goal is to obtain "consumption to gdp ratio" & "investment to gdp ratio". To do this you will need to have both Consumption and Investment in your figure (so basically as you did for Figure 1), and then you will need to "customize the data", which is done by first clicking on edit graph and then scrolling down to where it states "customize the data". Follow the instructions on FRED (note that this is where you want to "add" real GDP and then write the formula to modify/customize the series and obtain the ratio; you will need to do that both for Consumption and for Investment). Check that you have quarterly data for all series before customizing. Lastly, when you customize data, at first your results on the figure may look odd since the units of the variables that are still in levels (in real $) are NOT the same as the units of the variables that have been "customized" to ratios; so customize both C and I to get the right figure. Step 4. Download the figure. Step 5: provide a discussion of the data (what you observe across time), how the two series differ in magnitude (in each figure), etc. Make sure to discuss the past as well as the last few quarters and to incorporate specific numerical values into your narrative. The goal is to describe the data as you see it in the diagram; you don't need to explain any events that may have caused the movements. Must be 250 to 300 words. [7 points.] This question will require that you use the FRED database. The link is posted on iLearn. Your goal in this question is to obtain TWO diagrams with two variables (on the same graph). The first figure will have Personal Consumption Expenditure & Private Gross Investment, and the second figure will have the above variables expressed as % of GDP: i.e. Consumption to GDP ratio & the Investment to GDP ratio. The figures use similar data, and both figures requires TWO series to be plotted on the SAME diagram. Note that to obtain the RATIOS you will need to use data on real Consumption, real Investment, AND real GDP; the ratios must be generated in FRED directly using the three series. Both ratios (Consumption to GDP ratio & Investment to GDP ratio) must be plotted on a single diagram. Lastly, a discussion of the data must be submitted along with your diagram. See below for further instructions. Before starting, I strongly recommend watching the video on Canvas on how to navigate the FRED website. Note: you are not required to do everything I do in the video; the video is designed to introduce students to FRED and to give you an idea what can be done when navigating FRED; it is not designed for this specific assignment, but it will be helpful to you. If you have questions you should email me or stop by my office hours. Data characteristics: Use data from 1970 to the present; seasonally adjusted; and at quarterly frequency. Figure 1: Plots Consumption and Investment (in $). Both time series must be plotted on a single diagram. Figure 2: Plots the Consumption to GDP ratio & Investment to GDP ratio (in %). Both time series must be plotted on a single diagram.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these economics questions
-
Edge Company produces two models of its product with the same machine. The machine has a capacity of 160 hours per month. The following information is available. Selling price per unit Variable costs...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
e) Based on your investigation of the data set create two well-formatted tables that illustrate some important features of the data. Your tables should have informative labels and a readable number...
-
This case provides a history of Chevrolet, a review of its product line and marketing program, and a discussion of Chevrolets competitiveness against its rivals. There are many ways to approach this...
-
The following table shows the U.S. market share for smartphone manufacturers in 2013 according to the research firm comScore. The table also shows the frequency of purchases of smart phones by brand...
-
Consider a bank that conducts businesses in three stages. At stage 0, the bank lends to thirty poor clients, lending \($1,000\) per person. In stage 1, each individual borrower repays \($1,200.\) The...
-
How can Trip 7 prevent future supply chain uncertainties?
-
Find the value of the expression. log $32 O A. O B. OC. 43 53 32 54 O D.
-
During a cesarean section, an incision is made through allEXCEPT which of the following? linea alba perimetrium superficial fascia decidua basalis
-
How should a principal auditor evaluate the work of a component auditor?
-
Why are some auditors not satisfied with letters received from legal counsel?
-
Name three types of transactions an auditor must be alert to for proper classification and disclosure.
-
If a lawyer refuses to furnish corroborating information regarding litigation, claims, and assessments, the auditor should a. Honor the confidentiality of the client-lawyer relationship. b. Seek to...
-
Brown accepted an engagement to audit the 19X5 financial statements of XYZ Company. XYZ completed the preparation of the 19X5 financial statements on February 13, 19X6, and Brown began the field work...
-
Altira Corporation provides the following information related to its inventory during the month of August 2024: August 1 Inventory on hand-5,600 units; cost $7.10 each. August & Purchased 22,400...
-
After graduating from college and working a few years at a small technology firm. Preet scored a high-level job in the logistics department at Amex Corporation. Amex sells high-quality electronic...
-
Identify the issues related to performance evaluation using DCF models.
-
Identify relevant cash flows for DCF analyses.
-
Andrea Boss, Inc. is interested in using its activity-based costing system to improve its operating efficiency and its profit margins by applying activity-based management techniques. As part of this...
Study smarter with the SolutionInn App