1. Let's examine the history of LSUS undergraduate enrollment vs. i...

  1. Home
  2. Homework Library
  3. Business
  4. Economics
  5. 1. Let's examine the history of LSUS undergraduate enrollment vs. i...

QuestionQuestion

Transcribed TextTranscribed Text

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 clasticity 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 clasticity calculation will be trying to divide by zero; just delete those in your Excel table so that the cells are blank. The first headcount clasticity will be calculated based on the 1992 and 1993 values of tuition and headcount and should be about -0.122; the first credit hour clasticity will also be based on the 1992 and 1993 values and should be about -0.226). Calculate the average clasticity for headcount (from 1993-2016), and the average clasticity 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'v 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 clasticity for each (P,Q) combination. c. What is the point price clasticity of demand when P=$3.98? What is the point price clasticity 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? c. Use your indirect demand function to determine an equation for TR and MR as a function of Q, and create a graph of Pand 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. Illustration 7.3 (p. 262-4) describes time-series forecasting of new home sales, but you can see that the data is old. Click here https://www.census.gov/construction/ors/historical data/index html) 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, 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 Sept. 2017. 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" similar to the book 's column 4 on page 262 (t will go from 1 to 93 through Sept. 2017); 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, similar to the book's column 5. 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 t as 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 and F as the independents, and 4) seasonally adjusted monthly as the dependent, and t, E. 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: bP+ cM dP, 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 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 clasticities? 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?

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.docx, Solution1.xlsx, Solution2.xlsx and Solution3.xlsx.

    $70.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Economics Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats