User Account

All Pages

What are the r squares for the equations

Assignment Help Econometrics
Reference no: EM131131313

Excel Assignment

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 on motor vehicles and parts? On housing and utilities?

Attachment:- Excel Assignment.xls

Reference no: EM131131313

Questions Cloud

Calculate the elasticities for each independent variable : Compute the elasticities for each independent variable. Determine the implications for each of the computed elasticities for the business in terms of short-term and long-term pricing strategies. Provide a rationale in which you cite your results.
Explain both the classical and keynesian points of view : Explain both the classical and Keynesian points of view.
Discuss whether the implementation of vouchers will lead : Discuss whether the implementation of vouchers will lead the best students to leave public school, which could lead to a decline in education for the students left behind in the public schools.
Who is the antagonist if bartleby is the protagonist : Who is the antagonist if Bartleby is the protagonist? Even if there's not a typical antagonist, what is Bartleby working against
What are the r squares for the equations : What are the R squares for the equations? Which one is better? Can you provide an economic rationale to explain the difference? How well did the equations predict values for 2011 and 2012?
Labor force participation rates : Women in the Economy Please answer the following questions in your text The Economics of Women, Men, and Work (2010).Labor Force Participation Rates
Describe a key conflict in the play : Respond to one of the following, providing specific textual references to illustrate your ideas: Describe a key conflict in the play and how it corresponds to a character's development
What is the nominal exchange rate between the two countries : During the following year West Bubble has 10% domestic inflation and East Bubble has 20% domestic inflation. Two ordinary soap bars are still traded for a deluxe soap bar. At the end of the year what has happened to the nominal exchange rate? Whic..
What is the real value of japan''s net exports : The real exchange rate falls to 3 barrels of oil per camera. Although the decline in the real exchange rate makes oil more expensive in terms of cameras, in the short run there is relatively little change in the quantities of exports and imports, ..

Reviews

Write a Review

Econometrics Questions & Answers

  Design a simple econometric research project

Design a simple econometric research project

  Multiplicative decomposition method

Multiplicative decomposition method

  Market for cigarettes

The Australian government administers two programs that affect the market for cigarettes.

  Solve the forecast model

Solve the forecast model

  What are the marginal abatement cost functions

What are the marginal abatement cost functions for each of the two areas? Calculate the loss in the two areas due to over-control (for the rural area) and under-control (for the urban area).

  Write the t statistic for testing the null hypothesis

Explain why this model violates the assumption of no perfect collinearity.  Write the t statistic for testing the null hypothesis

  What is economics system

What is economics system? What are the types of economics system? Briefly explain each type of economics system by giving examples of nations that are close to each type

  Multiple choice questions related to market concentration

Determine when a competitively produced product generates negative externalities in production, the industry will,

  Calculating number of units produced by firm

Assume a company has the following production function: Q = 100 K.5 L1 . Currently, the company hires 1,000 workers and employs 100 units of capital.

  Question about mobile commerce

M-commerce also known as mobile commerce is being lumped in with several strategic internet plans. Explain some of the industries that are likely to use mobile commerce and how it is working for them.

  Calculating the average days past due and average flow time

Auto Data manufactures custom engineering testing machine. The following 5-orders are currently in the design department:

  Mechanism of an english auction and second price auction

Briefly discuss the difference between mechanism of an oral or English auction and a Vickrey or second price auction.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd