ChVIIExamplesofMR.pptx

(1)

VII. Examples of Multiple Regression

a. Omitted Variables and Fixed Effects – price elasticity regressions

(2)

a.Omitted Variables and Fixed Effects

(3)

In the above regression, we are “pooling” across all of the 86 stores and dumping them into the same regression with 14745 observations. This sounds great. We obtain dramatically greater precision. However, the set of stores could be different. In particular, “large” stores are pooled with “small” stores. We measure store size with ACV – All

Commodity Volume which is the total dollars sales for all product.

(4)

(5)

Note: acv matters (it should!) but does not

(6)

Some would argue that price promotions create a

response that is different than a change the “regular” or “shelf” price. That is, consumers “stock up” on

sale and that much of this increase in sales is simply future purchases made at the time of the sale –

forward buying.

(7)

(8)

But size is not the only characteristic of stores. It could be that prices are systematically higher/lower in stores with a greater total demand for Tide 128oz. For example, stores in the suburbs are often facing stiff competition from Target/Walmart and they also have high demand for the larger size of Tide.

Dominick’s uses a set of price zones and in those zones with warehouse format competition, the prices of many items are lower.

(9)

a. Omitted Variables and Fixed Effects

We could add dummy variables for each store (well 85 stores). As we saw before, this can be done

automatically for any categorical variable as long as it is what R calls a “factor.”

This is called a “fixed” effects regression approach. The idea is that anything that is store specific would be captured in these store coefficients including a relationship between prices and demand.

Note: if you want to make a standard numerical variable into a factor (we don’t have to do this because store is already a factor).

(10)

(11)

(12)

a. Omitted Variables and Fixed Effects

What might you expect? Higher prices with higher

(13)

b. Model Selection: Equity Premium Puzzle

There is a very large literature in finance that addresses the following question:

Why is there such a huge premium on equities versus so-called “risk-free” assets like Treasury Bills?

Let’s look at some data from Welch and Goval, “A Comprehensive Look at The Empirical Performance of Equity Premium Prediction,” RFS(2008). Data

updated to 2009.

(14)

Let’s look only at data from 1927 to 2009.

Puzzle: Is the premium of 7.63% per year worth the

(15)

(16)

(17)

(18)

Often investment in market out-performs the T bill, but not always. What is the probability that T bill portfolio will outperform?

(19)

The finance literature has tried to “explain” or predict the equity premium, using regressions of the form:

What sort of variables have been used to predict?

1. Book to Market ratio

2. Various combinations of dividends, earnings, price as ratios 3. Bond returns and various term premia

4. Stock Issuing activity

5. Various macro variables relating to investment and

(20)

How should we compare models?

Another way of interpreting R2 is as a measure of what

is called “in-sample” prediction. MSE = mean squared error.

Mean: use average value of y to predict

Regression: use lagged value of x to predict.

R

2

= 1

−

SSE

SST

= 1

−

y

_t

− ˆ

y

_t

(

)

2

t=2 T

∑

y

_t

−

y

(

)

2

t=2 T

∑

= 1

−

MSE

reg ression

(21)

(22)

Now run the regressions and summarize R-sq and F stat (same as t with only one indep var):

(23)

But these variables could be inter-correlated:

Looks like the very predictors that look

(24)

Now, let’s delete

(25)

(26)

(27)

Glossary of R Commands

• which(x==0)_{: find the indices in x (rows) for which x}

takes on value of 0. “==“ means “equal to.”

• as.factor(x)_{: creates a factor from variable x.}

• Name[-2,]_{: the second row is deleted from a matrix or}