Need assignment completed
ECON 705 Open: Mar. 30, 12:00am – Apr. 1, 11:59pmRecommend latest start time: Apr. 1, 8:30pm Econ 705 Module 3 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 it you will see historical information on LSUS undergraduate enrollment, total credit hour production, and (12-hour, undergraduate) tuition and fees. (If you wish, you can verify or look up additional information here and here.) 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 when the tuition doesn't change (like in 2006-2007), since the elasticity calculation will be trying to divide by zero; delete those error values in your Excel table so that the cells are blank. The first headcount elasticity will be calculated based on the 2000 and 2001 values of tuition and headcount and should be about -0.008; the first credit hour elasticity will also be based on the 2000 and 2001 values and should be about 0.359 (yes; it is positive). Calculate the average annual elasticity for headcount (from 2000-2021), and the average annual elasticity for credit hour (from 2000-2021). 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 $107.00 8742 $105.93 8779 $104.86 9421 $100.58 9589 $96.30 9840 $93.09 9909 $89.88 10443 $84.53 10483 a.Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to 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=$100.58? What is the point price elasticity of demand when P=$91.50? d.To maximize total revenue, what would you recommend if the company was currently charging P=$105.93? If it was charging P=$91.50? e.Use your first 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? (Round your price to the nearest cent, your quantity to the nearest whole unit, and your TR to the nearest dollar.) Compare that to the TR when P = $100.58 and P = $91.50. 3.Let’s practice time-series forecasting of new home sales. Click here (https://www.census.gov/construction/nrs/historical_data/index.html) to see the newest data in the first table: Houses Sold (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 Excel file “A3Q3 Census Housing Data.” Only keep the dates beginning in January 2010, so delete the earlier observations, and use the data through February 2023. 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 158 (Feb. 2023); make a t2 column too (since, if you look at the data, you can see sales are somewhat 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 straight lines) 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 t2 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 t and t2 as 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. When 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.Your company, which specializes in running shoes for men who are growing increasingly follicly-challenged (BalderDash®), has the following demand function: Q = a + bP + cM + dR where Q is the quantity demanded of BalderDash’s most popular shoes, P is the price of that product, M is consumer income, and R is the price of a related product. The regression results are: Adjusted R Square 0.7796 Independent Variables Coefficients Standard Error t Stat P-value Intercept 21,055.04 1428.27 14.74 8.1E-16 P -83.912 19.079 -4.398 0.000 M 0.0266 0.013 2.064 0.047 R -16.6 10.664 -1.556 0.129 a. Discuss whether you think these regression results will generate good sales estimates for BalderDash. Now assume that the income is $69,100, the price of the related good is $39, and BalderDash chooses to set the price of its product at $54. b.What is the estimated number of units sold given the data above? (round to nearest unit; no decimals) c.What are the values for the own-price, income, and cross-price elasticities? d.If P increases by 6%, what would happen (in percentage terms) to quantity demanded? e.If M increases by 2%, what would happen (in percentage terms) to quantity demanded? f.If R decreases by 3%, what would happen (in percentage terms) to quantity demanded? The LSUS College of Business considers course information to be proprietary to the professor of the course. Violating this intellectual property protection by scanning, copying, website posting, or reproducing and sharing course information is considered an infraction of the MBA Honor Code and LSUS Code of Student Conduct.