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

  Purchase stock or bonds from a private company

Assuming that everything else is equal, a U.S. government bond that matures 10 years from now most likely pays a interest rate than a U.S. government bond that matures 30 years from now.

  Determine profit-maximizing price and level of production

You are the manager of a monopolistically competitive firm, and your demand and cost functions are given by Q = 36 - 4P and C(Q) = 124 - 16Q + Q2. a. Find the inverse demand function for your firm's product. P = - Q b. Determine the profit-maxi..

  What spends a dollar buying a first cup of coffee

In addition suppose that coffee costs $1 per cup, doughnuts cost $1 each and omar has a budget that he can spend only on doughnuts, coffee or both. How big would that budget have to be before he would spend a dollar buying a first cup of coffee.

  Find market price and quantities produced if firm 2 move 1st

Consider the same two firms as above with marginal costs 10 and 40, facing a demand p = 100 - q. a. Find the market price and quantities produced if firm 1 moved first, followed by firm 2 b. Find the market price and quantities produced if..

  Compute the internal rate of return and net present value

a firm has the oppurtunity to invest in a project having an initial outlay of $20,000. net cash inflows(before depreciation and taxes) are expected to be $5,000 per year for five years. the firm uses the straight-line depreciation method.

  Calculate elasticity of demand at profit maximizing output

The monopolist's demand function is P = $405 - $5Q, its average cost function is AVC = $20+$0.5Q, and its fixed costs are $6,000 per hour. Calculate the monopolist's profit maximization output, price and its hourly profit.

  Identify three bundles that provide a utility of 100

Linda loves buying shoes and going out to dance. Her utility function for pairs of shoes, S, and the number of times she goes dancing per month, T, is U(S,T)=5ST. It costs Linda $50 to buy a new pair of shoes, and $25 to spend an evening dancing.

  How might a social critic respond to the claim

How might a critic respond to the claim that taxes always make the allocation of resources less efficient?

  Determine which company earns more money

A certain area has 7500 workers who are willing to work at any salary. The area has two places of employment, A and B. At A, the value of the marginal production of the workers is w = 1800-0.1L At B, it is w = 1800-0.2L

  Does it make sense for interbrew to develop a global brand

What would Interbrew have to do to succeed with Stella in the major urban market closest to where you live? Will these requirement vary much between major cities? Why? Why not?

  By how much would the economys money supply increase

assume that all other banks hold only the required amount of reserves. if First national decides to reduce its reserves to only the required amount, by how much would the economy's money supply increase

  Find all nash equilibria in mixed strategies

Find all Nash equilibria (if any) in pure strategies (PNE). Your answer should include strategies and equilibrium payoffs associated with your PNE.3. Find all Nash equilibria (if any) in mixed strategies (MNE).

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