I know you can only answer so many, which is perfectly fine, thanks! a. (10 points) Prepare a table of summary statistics for all available variables listed. Each variable should have a name and a description. Include mean, standard, deviation, minimum, and maximum. Paste that table below. b. (10 points) Estimate a linear regression with sales as a function of the remaining values in your data. Create a professional looking table in the style of the example table shown in the Microsoft excel workbook included with the exam. Give it a title, make sure it has consistent decimals, make it look professional. Paste that table below. c. (10 points) For each of the independent variables in the model, interpret the effect on the dependent variable (unit sales) of a 1 unit change in the independent variable taking into account whether that variable is statistically significant.

d. (6 points) Given the regression estimates from part b, write the implied demand function for your product here. Include all estimated coefficients that are statistically significant in your model. e. (10 points) Does this firm operate in a competitive market or have some degree of market power (it can choose its price)? Based on your understanding of market characteristics, your understanding of powdered drink mixes as a consumer, and what youve seen of the data, what type of market is your drink mix company likely to be operating in. Explain why. f. (10 points) Write the demand function as only a function of the products price, given the regression output from above. (This is like #5 from the most recent case study). Create your own simpler demand function using only the variables that are statistically significant and plug in the mean value. () = + 1() + 2() + 3() + 4() Plug the mean into the equation with the coefficients that are statistically significant and add those numbers into the constant, you will end up with a familiar looking demand function that looks like this: = 1Write that function here (points awarded here) g. (10 points) Envision that you know your drink mix company has a cost function equation to c(q) = 500 + 0.1q. Now, you will be only using changes in price to calculate optimum price and quantity to maximize profits (for the other statistically significant coefficients, plug in that they are equal to zero) so you will have a demand function like: Q = constant Coefficient*(price). Start with a price equal to $0.00 and increase the price by $0.05 in each row until you reach $0.65. Using that range of prices, estimate quantity demanded, revenue, cost, and profits (have a column for each). Create a professional looking table in the style of the example table shown in the Microsoft excel workbook included with the exam. Give it a title, make sure it has consistent decimal places and make it look professional. Paste that table below. h. (4 points) What is your profit maximizing price, quantity, and maximum profit given the information from your regression model and table?

Q. =15023.7423025p Q=15023.7423025p+2117.02[44)+1353431(17) 190837 981.8185 3\$.60.855 152.54.65 q=18256.0929025p Q. =15023.7423025p Q=15023.7423025p+2117.02[44)+1353431(17) 190837 981.8185 3\$.60.855 152.54.65 q=18256.0929025p