Reference no: EM131089558
Data are attached for U.S. DPI and PCE on two major components of consumer spending, motor vehicles and parts and housing and utilities. One is a durable good and the other is comprised of housing and other services and non-durables, such as natural gas purchases. Using scatter diagrams and trendlines, generate graphs showing the relationship of each of the consumption categories to DPI and find the equation of the graph and the R squared. Use your results to answer the questions to the right.
Questions:
a) Plot the data using a scatterplot.
b) Find the equation that shows the relationship between motor vehicles and parts expenditure (PCE) and DPI (insert a linear trendline and show the equation on the scatterplot).
c) Find the equation that shows the relationship between housing and utilities expenditures (PCE) and DPI (insert a linear trendline and show the equation on the scatterplot).
d) What are the R squares for the equations? Which one is better? Can you provide an economic rationale to explain the difference?
e) Use the equations to calculate estimated values for both types of expenditures for 2011 and 2012. How well did the equations predict values for 2011 and 2012?
f) If DPI increases at a rate of 2.2% in 2013 and then at a rate of 2.6% in 2014, what are the predicted values for consumer spending on motor vehicles and parts? On housing and utilities?
Attachment:- Data.rar
|
Paragraph that describes your reason for selecting the topic
: Write a paragraph that describes your reason for selecting the topic: social media. Write an additional paragraph that describes your plan to find the information that you'll need in order to complete the project on social media.
|
|
How much are your monthly student loan payments
: To pay for your education you have taken out $28,000 in student loans. If you make monthly payments over 13 years at 6% compounded monthly, how much are your monthly student loan payments?
|
|
Advice to politicians
: David Crockett intended "Advice to Politicians" to be humor but it illustrated the truth that people must be motivated to come out and vote. Andrew Jackson's "Bank Bill Veto" also motivated voters but used a different method. What was it about Jackso..
|
|
Effect of importing second hand clothes
: What is the effect of importing second hand clothes on the economy of developing countries?
|
|
Plot the data using a scatterplot
: Data are attached for U.S. DPI and PCE on two major components of consumer spending, motor vehicles and parts and housing and utilities. Plot the data using a scatterplot
|
|
Present value of a perpetual stream of cash flows
: What is the present value of a perpetual stream of cash flows that pays $80,000 at the end of one year and grows at a rate of 7% indefinitely?
|
|
Under what circumstances is US welfare diminished
: China has emerged as one of the fastest growing and most significant trading partners for the US. How does growth in China impact welfare in the US? Under what circumstances is Chinese growth good for US welfare and under what circumstances is US wel..
|
|
What does nyse stand for
: A lot of abbreviations are used in the economics world. What does NYSE stand for?
|
|
Should he buy the antivirus software
: Jeff is a risk-neutral middle-aged American. The data on his computer is worth $2000. If his computer gets a virus, he will have to spend $600 to restore the data. Alternatively, he can purchase Norton Antivirus for $100. If he believes there is a 50..
|