Question

In: Economics

City Q P I A Psub Pop 1 32.92 1.89 32.4 4.38 2.08 98.7 2 28.51...

City Q P I A Psub Pop
1 32.92 1.89 32.4 4.38 2.08 98.7
2 28.51 1.94 29.9 4.12 2.06 104.5
3 33.94 1.99 29.1 5.06 2.15 105.1
4 33.45 2.04 28.6 5.36 2.18 106.9
5 35.68 2.09 30.2 5.38 2.18 108.9
6 29.01 1.89 31.4 3.47 1.99 115.2
7 30.68 1.94 30.3 4.06 2.05 117.8
8 43.14 1.99 30.4 5.29 2.17 120.2
9 20.84 2.04 28.6 3.39 1.98 120.8
10 31.27 2.09 26.3 5.12 2.16 122.7
11 35.45 1.89 26.5 4.44 2.09 122.9
12 32.14 1.94 29.5 4.18 2.06 124.6
13 43.02 1.99 29.1 5.57 2.2 125.8
14 34.73 2.04 31.2 3.57 2 131.9
15 43.14 2.09 23.8 6.43 2.39 133.1
16 33.17 1.89 28.8 3.95 2.04 135.6
17 41.59 1.94 29.3 4.04 2.05 136.5
18 32.1 1.99 27.4 4.36 2.08 141.8
19 45.74 2.04 27.8 5.81 2.23 144.8
20 35.92 2.09 30.2 4.63 2.11 150.1

I have collected real data on the sale of a microwavable cup of soup across 20 different cities for the same time period (a month). The variables in the dataset are:

Quantity sold in the city for that month: Measured in thousands of units

Price: measured in dollars

Average Income in the city: Measured in thousands of dollars

Ads: Average number of ads run in stores for that city during that month.

Price of a substitute product: measured in dollars

Population of the city: measured in thousands of people

The dataset is on Canvas and, using Excel or any other statistical software, please answer the following questions:

  1. Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well.
  2. Take the logs of the variables, and estimate the demand function.
    1. Interpret the R-square.
    2. Interpret the coefficients for logP and logPsub
    3. Interpret the p-values associated with each independent variable
  3. Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining?
  4. How sensitive are our consumers to changes in the rival good’s price? Explain in detail.
  5. Suppose we decide to charge a per ounce price of .07, while at the same time our rival charges a price of .05. All else equal, what would you expect sales to be? How confident are you in your forecast? Explain.
  6. Suppose we are charging a price of .065 per ounce and our current marginal cost per ounce is .05. Are we maximizing profits at this price? If not, should we raise or lower price? Why?

Solutions

Expert Solution

The descriptive statistics and the plot of price and substitute's price versus sales is shown below.


Related Solutions

Let p and q be propositions. (i) Show (p →q) ≡ (p ∧ ¬q) →F (ii.)...
Let p and q be propositions. (i) Show (p →q) ≡ (p ∧ ¬q) →F (ii.) Why does this equivalency allow us to use the proof by contradiction technique?
1. Determine if the following deduction rule is valid: p∨q ¬p _______ ∴ q 2. Determine...
1. Determine if the following deduction rule is valid: p∨q ¬p _______ ∴ q 2. Determine if the following is a valid deduction rule: (p∧q)→r ¬ p ∨ ¬ q ________ ∴     ¬r 3. Suppose p and q are (possibly molecular) propositional statements. Prove that p and q are logically equivalent if any only if p↔q is a tautology.
1. Show that the argument (a) p → q       q → p       therefore p...
1. Show that the argument (a) p → q       q → p       therefore p V q       is invalid using the truth table. ( 6 marks ) (b) p → q       P       therefore p        is invalid using the truth table. ( 6 marks ) (c) p → q       q → r        therefore p → r         is invalid using the truth table. ( 8 marks )
Given the sample results: Pop 1 Pop 2 x ̄1 = 54 x ̄2 = 50...
Given the sample results: Pop 1 Pop 2 x ̄1 = 54 x ̄2 = 50 s1 = 10.5 s2 = 11.0 n1 = 11 n2 = 16 (a) Find a 98% CI for μ1 − μ2. (b) Perform the Hypothesis Test (α = 0.01) : H0 : μ1 = μ2; Ha : μ1 > μ2 (c) Explain how you could use part (a) to answer part (b).
1. suppy curve PQ=4 (1) P=4, Q=?, TR=?, the price elascity=? (2) P=3 Q=?, TR=?, the...
1. suppy curve PQ=4 (1) P=4, Q=?, TR=?, the price elascity=? (2) P=3 Q=?, TR=?, the prics elascity=? 2. suppy curve P=4/root(Q) (1) P=4, Q=?, TR=? The price elascity=? (2) P=3 Q=?, TR=? The price elascity=? I want detailed explanation, thank you very much??
Supply and Demand Use the following equations: (1) P = 4 + Q (2) P =...
Supply and Demand Use the following equations: (1) P = 4 + Q (2) P = 12 – 3Q a. Please show steps: a. Which equation represents the supply curve, and which represents the demand curve? How do you know? b. What is the equilibrium price and quantity in this market? c. Graph the supply and demand curves for these equations. d. Suppose the price is $8. What is the new Qs and Qd? What type of disequilibrium situation exists,...
1. m •   (n • p) 2. (q   ⊃ ~t) • (~m v q) 3.   ~t...
1. m •   (n • p) 2. (q   ⊃ ~t) • (~m v q) 3.   ~t ⊃ z     : .     z
Q. Let A, B independent events, with P(A) = 1/2 and P(B) = 2/3. Now C...
Q. Let A, B independent events, with P(A) = 1/2 and P(B) = 2/3. Now C be an event with P(C) = 1/4, and suppose that P(A|C) = 1/3, P(B|?̅) =7/9, P(A∩B|?̅) = 7/18. (a) Calculate the P(A∩B) (b) Calculate the P(A|?̅) and P(B|C) (c) Calculate the P(A∩B|C) (d) Show if P(A∩B|C) equals P(A|C)P(B|C) or not.
Derive the mirror equation. ( 1/p + 1/q = 2/R ) pshyics : optics
Derive the mirror equation. ( 1/p + 1/q = 2/R ) pshyics : optics
1. Suppose that the market demand is described by P = A – B(Q+q) where P...
1. Suppose that the market demand is described by P = A – B(Q+q) where P is the market price, Q is the output of the incumbent firm, and q is the output of the potential entrant to the market. The incumbent’s total cost function is C(Q) = c1Q, whereas the cost function of the entrant is C(q) = c2q+F. a. If the entrant firm observes the incumbent producing Q* units of output and expects this output level to be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT