Reference no: EM13798330
Question 1:
Below are data 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 onmotor vehicles and parts? On housing and utilities?
Attachment:- excel.xlsx
Identify problems of vagueness overgenerality and ambiguity
: Identify problems of vagueness, overgenerality, and ambiguity in the following passages. You'll notice that many of the examples are comical, whether or not the writer intended them to be so.
|
Calculate the surface tension of blood plasma
: In order to lift a wire ring of radius 2.25 cm from the surface of a container of blood plasma, a vertical force of 1.30 X 10-2 N greater than the weight of the ring Is required. Calculate the surface tension of blood plasma from this information
|
How teams are managed in major league baseball
: How did Billy Bean, General Manager of the Oakland Athletics use Statistics to redefine how players are evaluated and how teams are managed in Major League Baseball?
|
Contrast transaction exposure and economic exposure
: Transaction versus Economic Exposure. Compare and contrast transaction exposure and economic exposure. Why would an MNC consider examining only its "net" cash flows in each currency when assessing its transaction exposure
|
Relationship between motor vehicles and parts expenditure
: 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).
|
The surface of the insect''s body and penetrate
: Insects do not have lungs as we do, nor do they breathe through their mouths. Instead, they have a system of tiny tubes, called tracheae, through which oxygen diffuses into their bodies. The tracheae begin at the surface of the insect's body and pene..
|
Assignment client interaction strategy
: Assignment Client Interaction Strategy
|
What are important moments celebrated in somones life
: What are important moments celebrated in somone's life? What are the traditions for the birth of the baby, birthdays, and funerals?
|
Individuals who re-sell tickets at the event
: Suppose you bought a concert ticket from Ticketmaster for $50, but when you got to the concert scalpers (individuals who re-sell tickets at the event) were selling tickets in the same seating area as yours for $25. What is probably true?
|