Question
(5 points) Write 3-4 sentences describing the data using the summary statistics you calculated. Describe the average values of the variables as well as their
(5 points) Write 3-4 sentences describing the data using the summary statistics you calculated. Describe the average values of the variables as well as their standard deviations and min and max values?
(5 points) Create a table with linear regression results for the four variables contained in the data set with average daily beer sales as the dependent variable and the other three variables as the independent variables.
d. (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
e. (3 points) Write the demand curve below based on your regression results (Qbeersold = Estimated constant - (Coefficient)pbeer) 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. 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started