Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have a question re: dummy variables and regression models in Excel. Specifically, I have a dependent variable called restaurant location revenues and need to

I have a question re: dummy variables and regression models in Excel.

Specifically, I have a dependent variable called "restaurant location revenues" and need to run a regression to determine the impact of nearby liquor stores on the each of a restaurant chain's location's revenues. I am given a column that, for each location, provides the following qualitative information.

"The restaurant location DOES NOT have a nearby liquor store"

"The restaurant location has a nearby liquor store that DOES NOT sell food"

"The restaurant location has a nearby liquor store which DOES sell food"

How would I correctly set up one (or more) dummy variables to appropriately capture the above items in a regression?

Should I create two columns, with the first assigning a "1" for any restaurant with a nearby liquor store and a second assigning a "1" for any restaurant with a nearby liquor store WHICH ALSO SELLS FOOD? Or is there another way I should be thinking about this?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course In Discrete Mathematics

Authors: John C Molluzzo, Fred Buckley

1st Edition

1478634383, 9781478634386

More Books

Students also viewed these Mathematics questions

Question

3. What values would you say are your core values?

Answered: 1 week ago