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...
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....
We consider data in the following table, summarizing sales of a product (in thousands). For each...
We consider data in the following table, summarizing sales of a product (in thousands). For each of the questions, justify your answer. Year Quarter Sales 2015 1 2 3 4 4.95 4.25 6.15 6.65 2016 1 2 3 4 5.85 5.35 6.95 7.55 2017 1 2 3 4 6.15 5.75 7.65 7.95 (3.1) Assuming the given time-series shows evidence of seasonality, Determine the estimate sales values. (5) (3.2) What is the value of the root mean squared error for the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT