Attachment # 00009838 - Problem_Set3.doc
Problem_Set3.doc (63.5 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
If the price for some good increases by 10 and the quantity demanded falls by 5, (a) what is the price elasticity of demand, and (b) is this elastic or inelastic Last year the US low-cost-carrier Spirit Airlines entered the Dallas-Chicago market. The average ticket price for all airlines servicing the route fell from 200 to 180. After Spirits entry, the number of passengers increased from 700 to 800 per day (these number are hypothetical, but reasonable). Calculate the price elasticity of demand between these two points. Show the computation. An airline consulting firm as determined that the income elasticity for leisure air travel in China is 1.5. If incomes increase by 5 next year, what is the percentage change in leisure passengers expected next year Show the computation. The state operates a toll road which currently charges 1.00 per car with 100,000 cars using the road daily. The state wishes to raise an additional 10,000 per day for road maintenance. A newly hired financial analyst proposes raising the toll to 1.10 per car. The analyst reports to you. Will you accept and forward her recommendation to your boss What is the cross-price elasticity of demand between good X and good Z when Px 154 Are good X and good Z substitutes are complements The data are real US Gross Domestic Product (in billions of dollars) and Domestic Revenue Passenger Miles (in millions) for the years 1996 through 2012. Below this table is the MS Excel Summary Output regressing RPMs against GDP. Using MS Excel or another similar application, build a scatter plot and insert the regression line and equation. Next, interpret the regression output and explain the regression statistics. Be certain that the regression coefficients match those in the scatter plot equation. Finally, use the regression equation to predict RPMs for 2013 and 2014 assuming GDP grows by 3 each year from 2012. You may wish to check the actual RPMs to see how closely your estimate matched. Note To build a scatter plot in Excel, select and copy the GDP and RPM data into Excel select the data in Excel, then use Insert/Scatter to create a scatter plot. Finally, scroll down Chart Layout to select the format that creates a regression line and formula. Use the Excel Help function as needed. YearGDPRPM19968,100.2419.0719978,608.5438.4219989,089.1448.5819999,665.7472.96200010,289.7500.12200110,625.3472.60200210,980.2469.96200311,512.2492.73200412,277.0542.82200513,095.4569.24200613,857.9574.52200714,480.3592.33200814,720.3568.25200914,417.9538.98201014,958.3552.85201115,533.8563.65201216,244.6568.70 Page PAGE 2 of NUMPAGES 2 MBAA 523 Problem Set 3 Page PAGE 1 of NUMPAGES 2 Y, dXiJ(x( I_TS 1EZBmU/xYy5g/GMGeD3Vqq8K)fw9 xrxwrTZaGy8IjbRcXI u3KGnD1NIBs RuKV.ELM2fi V vlu8zH (W uV4(Tn 7_m-UBww_8(/0hFL)7iAs),Qg20ppf DU4p MDBJlC5 2FhsFYn3E69 45Z5k8Fmw- dznZ xJZp /P,)KQk5qpN8KGbe Sd17 paSR 6Q
Tutorials for this Question
  1. Davidcharles
    Tutorial # 00367751 Posted By: Davidcharles Posted on: 08/27/2016 02:32 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Problem Set Three Solutions: Excel and Tutorials...
      Get the Solution
    Attachments
    Problem_Set3.doc (70.5 KB)
    Regression_Graph.xlsx (13.13 KB)
Whatsapp Lisa