(12 points) Interpret all coefficients including the constant you estimated in the model in the table from part c. For each of the independent variables other than the constant term, tell me what a 1 unit increase in the value would cause to happen to the dependent variable (interpret the coefficients). Be sure to take into account whether the coefficient is statistically significant in your description of the effect. e. (3 points) Write the demand curve below based on your regression results (Q_beersold = Estimated constant - (Coefficient)p_beer) assume the values of the variables other than the price of beer are equal to zero to make it easier. f. (3 points) Using the equation above assuming income and the price of liquor are = 0, create a table containing price, quantity, and total revenue that begins at a beer price = 0 and increases in $0.25 increments until it reaches $2.50. Format this table to look professional using appropriate decimal points and making labels for the columns and a title. Paste it here. g. (3 points) What price/quantity combination will maximize revenue? (Be aware that the quantity values will not turn out to be exactly even numbers). What is the maximum total revenue? h. (5 points) Create the demand curve and total revenue graphs given the demand equation from part d and table from part e of this question. (The two stacked graphs from the prior homework). Format them correctly, show quantity on the horizontal axis of both graphs and fully label the graphs for the reader. Hint: to get quantity to show along the horizontal axis in the demand curve graph, use an X Y (Scatter) type graph 3. Envision you work for a firm where the demand curve has been estimated to be Q = 1000 - 4p. (5 points each part of this question, show your work) a. What is the revenue maximizing price and quantity? Show your work to solve for p* and q* b. What is the maximum revenue? c. Draw and fully label the stacked graphs as shown this week in the videos, label the intercept of the demand curve with the vertical (P) axis, the optimal price, as well as optimal quantity on the bottom graph with Total Revenue. Insert those graphs here. d. If your firm was charging a price = 150 what is total revenue? Are you operating in the elastic, inelastic, or unit elastic portion of the demand curve? To increase revenue should you increase, decrease, or not change the price? e. If your firm was charging a price = 200 what is total revenue? Are you operating in the elastic, inelastic, or unit elastic portion of the demand curve? To increase revenue should you increase, decrease, or not change the price? f. If your firm was charging a price = 125 what is total revenue? Are you operating in the elastic, inelastic, or unit elastic portion of the demand curve? To increase revenue should you increase, decrease, or not change the price? g. Create a table with three columns, one with price (P), one showing your anticipated sales (Q), and another with total revenue (TR). Create the P column at the far left, start price at 0 and increase the price by 25 until you reach the value where quantity sold is equal to zero. You will make quantity a function of price (it will be easiest to write a formula). Format this table to look "nice" with a title for the table, column headings, format the numbers to have commas, and add any notes needed to understand what the contents. Paste this table below and replace mine once you have created an acceptable table. You will be graded on correctness and style. Example given below without a title of how to set up the columns. As an example with different numbers, part g should be structured like below but with a title, etc. as described