2. Copy and paste the following data into Excel: P Q $210.00 5415 $205.30 5553 520330 5T83 $195.30 5958 $184.80 6115 $182.70 6266 $170.10 6581 $165.90 6856 a. Run OLS to determine the demand function as P = f(Q); how much condence do you have in this estimated equation? Use algebra to invert the demand inction to Q = f(P). b. Using calculus to determine @312, construct a column which calculates the point-price elasticity for each (2Q) combination. c. What is the point price elasticity of demand when P=$210.00? What is the point price elasticity of demand when P=$1T3.25? d. To maximize total revenue, What would you recommend if the company was currently charging P=$203.T0? Ifit was charging P=$173 .25? e. Use your rst demand function to determine an equation for TR and MR as a function of M 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 = $210.00 and P = $173.25