: 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
-
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...
-
The Mistine case provides an example of an international company competing against a well know brand: Avon. It follows the company from small start-up to one of the largest Asian direct sellers. It...
-
What are the three stages associated with most P/M sintering operations?
-
Prove that the constant \(a\) in Eq. (8.82) is positive for common boundary conditions. c dW(x) W(x) dx4 = 1 dT(t) T(t) dt = a = w (8.82)
-
Longchamps Electric is faced with a capital budget of $150,000 for the coming year. It is considering six investment projects and has a cost of capital of 7%. The six projects are listed in the...
-
Home Depot's cash conversion cycles are reported as follows: Days sales outstanding (DSO) + Days inventory outstanding (DIO) - Days payable outstanding (DPO) Cash conversion cycle Sales (Revenues)...
-
Explain, using ample evidence from The Cowshed , how the Cultural Revolution in China was both an overreaction to Western imperialism and a form of authoritarian control of the Chinese population.
-
Lexington is the payroll accountant at All's Fair Gifts. The employees of All's Fair Gifts are paid semimonthly. Asa comes to Lexington on April 7 and requests a pay advance of $1,000, which Asa will...
-
Vista Company manufactures electronic equipment. It currently purchases the special switches used in each of its products from an outside supplier. The supplier charges Vista $6.50 per switch....
-
Factory Overhead Controllable Variance Lo-bed Company produced 4,000 units of product that required four standard hours per unit. The standard variable overhead cost per unit is $3.00 per hour. The...
-
You are interested in obtaining a sample of 50% females and 50% males. The population of CAS undergraduate majors is made up of 80% females and 20% males. -Describe how you would use a systematic...
-
Your term paper should focus on practical information about your career choice as a Arabic teacher that can be used to make sure this is the direction you actually want to go in, such as salary...
-
Assume Eq. 6-14 gives the drag force on a pilot plus ejection seat just after they are ejected from a plane traveling horizontally at 1300 km/h. Assume also that the mass of the seat is equal to the...
-
Stevenson Company's trial balance as of December 31, 2022 shows \($35,000\) for inventory; but the balance sheet shows \($33,000.\) Assuming no inventory shrinkage, what is the most likely reason for...
-
Amanda Company started business at the beginning of 2022. The company applies the lower-of-cost- or-net-realizable-value rule to its inventory as a whole. Inventory cost and market value as of the...
-
Which one of the following costs is not included in inventory for manufacturing firms? a. Raw materials used in production b. Raw materials unused and stored in the warehouse c. Salary paid to the...
Study smarter with the SolutionInn App