Question

In: Economics

We consider data on weekly sales for coffee. Data has n = 18 weeks of coffee...

We consider data on weekly sales for coffee. Data has n = 18 weeks of coffee sales in Q units, the deal rate (D = 1 for usual price, = 1.05 in weeks with 5% price reduction, and = 1.15 in weeks with 15% price reduction), and advertisement (A = 1 with advertisement, = 0 otherwise)

Model = log(Q) = B0 + B1D + B2A + u

estimate by OLS -> log(Q) = 0.701 (0.415) + 0.756D (0.091) + 0.242A (0.110)

Standard error is in brackets

1. Based on the estimated coefficients, a 10% price reduction is associated with a A)75.6% B)7.56% C)0.756% increase in sales

2. Based on the estimated coefficients, the efect of advertisement is approx the same as a A)5% B)15% C)30% D)45% price reduction

Solutions

Expert Solution

1).

Consider the given problem here the estimated regression model is given below.

=> Log(Q) = 0.701 + 0.756*D + 0.242*A, where “Q=weekly sales for coffee”. For usual price “D=1”, if the price reduced by 10% implied “D=1.1”, => change of “D” is “0.1”, => the relative change of sales is “0.756*0.1 = 0.0756”. So, the percentage change in sales is “0.0756*100 = 7.56%”. The correct answer is “B”.

2).

Here “A=1” with advertisement and “=0” otherwise. The change of “A” is “1”, => the relative change in sales is “0.242”. Now, let’s assume price reduced by 30%, => the relative change in sales is “0.756*0.3 = 0.2268”. So, approximately the effect of advertisement is equivalent to the 30% reduction in price. So, the correct answer is “C”.


Related Solutions

We consider data on weekly sales for coffee. Data has n = 18 weeks of coffee...
We consider data on weekly sales for coffee. Data has n = 18 weeks of coffee sales in Q units, the deal rate (D = 1 for usual price, = 1.05 in weeks with 5% price reduction, and = 1.15 in weeks with 15% price reduction), and advertisement (A = 1 with advertisement, = 0 otherwise) Model = log(Q) = B0 + B1D + B2A + u estimate by OLS -> log(Q) = 0.701 (0.415) + 0.756D (0.091) + 0.242A...
1. A restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks...
1. A restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks are shown below. Time Period Observation 1 1,586 2 1,622 3 1,417 4 1,310 5 1,228 6 1,342 7 1,580 8 1,303 9 1,283 10 1,559 11 1,386 12 1,586 13 1,665 14 1,638 15 1,361 MSE values based on the two- and three-period moving average are 33,931.58 and 31,048.14, respectively. Find the best single exponential smoothing model by evaluating the MSE from 0.1...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t X t X t X t X t X t X 1 9.8 7 36.4 13 53.4 19 99.2 25 105.3 31 141.3 2 9.0 8 51.0 14 66.6 20 90.4 26 116.7 32 151.8 3 10.5 9 51.1 15 70.6 21 91.2 27 113.2 33 151.1 4 20.6 10 46.9 16 76.4 22 94.9 28 120.5 34 156.4 5 28.1 11 50.5 17...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t X t X t X t X t X t X 1 9.8 7 36.4 13 53.4 19 99.2 25 105.3 31 141.3 2 9.0 8 51.0 14 66.6 20 90.4 26 116.7 32 151.8 3 10.5 9 51.1 15 70.6 21 91.2 27 113.2 33 151.1 4 20.6 10 46.9 16 76.4 22 94.9 28 120.5 34 156.4 5 28.1 11 50.5 17...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t X t X t X t X t X t X 1 9.8 7 36.4 13 53.4 19 99.2 25 105.3 31 141.3 2 9.0 8 51.0 14 66.6 20 90.4 26 116.7 32 151.8 3 10.5 9 51.1 15 70.6 21 91.2 27 113.2 33 151.1 4 20.6 10 46.9 16 76.4 22 94.9 28 120.5 34 156.4 5 28.1 11 50.5 17...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t X t X t X t X t X t X 1 9.8 7 36.4 13 53.4 19 99.2 25 105.3 31 141.3 2 9.0 8 51.0 14 66.6 20 90.4 26 116.7 32 151.8 3 10.5 9 51.1 15 70.6 21 91.2 27 113.2 33 151.1 4 20.6 10 46.9 16 76.4 22 94.9 28 120.5 34 156.4 5 28.1 11 50.5 17...
A company has recorded data on the weekly sales for its product (y) and the unit...
A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). The data resulting from a random sample of 7 weeks follows. Use Excel’s Regression Tool to answer the following questions. A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). The data resulting from a random sample of 7 weeks follows. Use Excel’s Regression Tool to...
Suppose we have the following annual sales data for an automobile dealership: Year                Sales            &n
Suppose we have the following annual sales data for an automobile dealership: Year                Sales                Trend 2009                121                     1 2010                187                     2 2011                165                     3 2012                134                     4 2013                155                     5 2014                167                     6 2015                200                     7 2016                206                     8 2017                221                    9 2018                231                 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique to...
Dry Goods Sales The data is for weekly sales in the dry goods department at a...
Dry Goods Sales The data is for weekly sales in the dry goods department at a Wal*Mart store in the Northeast.  Peak values, I.e. spikes, usually occur at holiday periods.  Week 1 is the first week of February 2002.  To show continuity, week 1 of 2003 is represented as week 54 since week 53 represents the end of fiscal 2002 and start of the 2003 fiscal year. Dollar values are adjusted in order to disguise true sales figures, but trends in the data...
A company has recorded data on the weekly sales for its product (y) ($10), the unit...
A company has recorded data on the weekly sales for its product (y) ($10), the unit price of the competitor's product (x1), and advertising expenditures (x2) ($10). The data resulting from a random sample of 7 weeks follows. Use Excel's Regression Tool to answer the following questions: Week Price Advertising Sales 1 .33 5 20 2 .25 2 14 3 .44 7 22 4 .40 9 21 5 .35 4 16 6 .39 8 19 7 .29 9 15 1....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT