Ask Microeconomics Expert

Assignment

1. Let's examine the history of LSUS undergraduate enrollment vs. its tuition and fees. Download the "A3Q1 LSUS enrollment data" Excel file (in CSV format if you don't have Excel); in it you will see historical information on LSUS undergraduate enrollment, total credit hour production, and tuition and fees.

Calculate annual elasticities for both types of quantity variables (i.e., you will have an elasticity of price vs. headcount, and one of price vs. credit hour). You will get an error message in your calculations a few times when the tuition doesn't change, since the elasticity calculation will be trying to divide by zero; just delete those in your Excel table so that the cells are blank. The first headcount elasticity will be calculated based on the 1992 and 1993 values of tuition and headcount and should be about -0.122; the first credit hour elasticity will also be based on the 1992 and 1993 values and should be about -0.226). Calculate the average elasticity for headcount (from 1993-2016), and the average elasticity for credit hour (from 1993-2016).

Many administrators argue that, to increase revenue to LSUS to cover budget shortfalls, tuition should be raised. Comment on this suggestion, using the evidence you've uncovered.

2. Copy and paste the following data into Excel:

P

Q

$4.80

1170

$4.53

1235

$3.98

1337

$3.72

1442

$3.49

1548

a. Run OLS to determine the inverse demand function (P = f(Q)); how much confidence do you have in this estimated equation? Use algebra to then find the direct demand function (Q = f(P)).

b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination.

c. What is the point price elasticity of demand when P=$3.98? What is the point price elasticity of demand when P=$3.81?

d. To maximize total revenue, what would you recommend if the company was currently charging P=$4.53? If it was charging P=$3.81?

e. Use your indirect demand function to determine an equation for TR and MR as a function of Q, and create a graph of P and MR on the vertical and Q on the horizontal axis.

f. What is the total-revenue maximizing price and quantity, and how much revenue is earned there? Compare that to the TR when P = $4.80 and P = $3.81.

3. Let's practice time-series forecasting of new home sales to see the newest data in the first table: Houses Sold - Seasonal Factors, Total (Excel file is sold_cust.xls). Look at the monthly data on the "Reg Sold" tab. If you have trouble with the link, I have recreated the data in moodle in the CSV file "A3Q3 Census Housing Data."

Only keep the dates beginning in January 2010, so delete the earlier observations, and use the data through Feb. 2018.Keep only the US data, both the seasonally unadjusted monthly (column B) and the seasonally adjusted annual (column G).Make a new column of seasonally adjusted monthly by dividing the annual data by 12.Make a column called "t" where t will go from 1 (Jan. 2010) to 98(Feb. 2018); make a t2 column too (since, if you look at the data, you can see sales are slightly U-shaped; hence the quadratic). Also make a column "D" that is a dummy variable equal to one during the spring and summer months of March through August.

Determine the correlation between the unadjusted and the adjusted monthly data (=CORREL(unadjust., adjust.) in Excel), and produce scatterplots (with connectors) of both. Do you think making a seasonal adjustment will be useful, given what you observe at this point?

Run four regressions: 1) seasonally unadjusted monthly as the dependent, and t and t2as the independents, 2) seasonally unadjusted monthly as the dependent, and t, t2, and D as the independents, 3) seasonally adjusted monthly as the dependent, and t and t2as the independents, and 4) seasonally adjusted monthly as the dependent, and t, t2, and D as the independents. Discuss your findings, and determine which of the four models is the best for forecasting new home sales.In interpreting your p-values, remember that, say, 1.0E-08 is 1.0 * 10^-8, which is 0.00000001. State the equation that would be used to forecast sales.

4. Bob's Underground, a limited liability corporation specializing in new rap artists (B.U. LLC, rap) has the following demand function:

Q = a + bP + cM + dPR

where Q is the quantity demanded of the most popular product B.U. sells, P is the price of that product, M is income, and PR is the price of a related product.  The regression results are:

Adjusted R Square

0.8222




Independent Variables

Coefficients

Standard Error

t Stat

P-value

Intercept

-32.32

65.77

-0.491

0.626

P

-2.46

1.38

-1.813

0.079

M

0.008

0.001

6.045

9.53E-07

PR

-2.56

1.26

-2.025

0.051

a. Discuss whether you think these regression results will generate good sales estimates for B.U. LLC, rap.

Now assume that the income is $35,000, the price of the related good is $24, and B.U. chooses to set the price of its product at $21.

b. What is the estimated number of units sold given the data above?

c. What are the values for the own-price, income, and cross-price elasticities?

d. If P increases by 4%, what would happen (in percentage terms) to quantity demanded?

e. If M increases by 3%, what would happen (in percentage terms) to quantity demanded?

f.  If PR decreases by 5%, what would happen (in percentage terms) to quantity demanded?

Attachment:- Census-Housing-Data.rar

Microeconomics, Economics

  • Category:- Microeconomics
  • Reference No.:- M92762212

Have any Question?


Related Questions in Microeconomics

Question show the market for cigarettes in equilibrium

Question: Show the market for cigarettes in equilibrium, assuming that there are no laws banning smoking in public. Label the equilibrium private market price and quantity as Pm and Qm. Add whatever is needed to the mode ...

Question recycling is a relatively inexpensive solution to

Question: Recycling is a relatively inexpensive solution to much of the environmental contamination from plastics, glass, and other waste materials. Is it a sound policy to make it mandatory for everybody to recycle? The ...

Question consider two ways of protecting elephants from

Question: Consider two ways of protecting elephants from poachers in African countries. In one approach, the government sets up enormous national parks that have sufficient habitat for elephants to thrive and forbids all ...

Question suppose you want to put a dollar value on the

Question: Suppose you want to put a dollar value on the external costs of carbon emissions from a power plant. What information or data would you obtain to measure the external [not social] cost? The response must be typ ...

Question in the tradeoff between economic output and

Question: In the tradeoff between economic output and environmental protection, what do the combinations on the protection possibility curve represent? The response must be typed, single spaced, must be in times new roma ...

Question consider the case of global environmental problems

Question: Consider the case of global environmental problems that spill across international borders as a prisoner's dilemma of the sort studied in Monopolistic Competition and Oligopoly. Say that there are two countries ...

Question consider two approaches to reducing emissions of

Question: Consider two approaches to reducing emissions of CO2 into the environment from manufacturing industries in the United States. In the first approach, the U.S. government makes it a policy to use only predetermin ...

Question the state of colorado requires oil and gas

Question: The state of Colorado requires oil and gas companies who use fracking techniques to return the land to its original condition after the oil and gas extractions. Table 12.9 shows the total cost and total benefit ...

Question suppose a city releases 16 million gallons of raw

Question: Suppose a city releases 16 million gallons of raw sewage into a nearby lake. Table shows the total costs of cleaning up the sewage to different levels, together with the total benefits of doing so. (Benefits in ...

Question four firms called elm maple oak and cherry produce

Question: Four firms called Elm, Maple, Oak, and Cherry, produce wooden chairs. However, they also produce a great deal of garbage (a mixture of glue, varnish, sandpaper, and wood scraps). The first row of Table 12.6 sho ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As