Combining data for analysis

General
1

Hey guys,

I am not entirely sure how to explain this but I am trying to only use data with certain inputs so that I may make a regression. Specifically, I want to regress "Price" on "Italy" from the year "2011", then compare that regression with other countries and years to see how the inputs would vary price.

Screen Shot 2022-03-21 at 4.04.40 PM
Screen Shot 2022-03-21 at 4.04.40 PM2554×463 123 KB

The column "Italy" shows TRUE for each row that was made from Italy.

My question is, how can I code so that I can regress "Price" on the country of Italy and the Year of 2011?

Note there's 8666 observations in this data set, all ranging from years 1991-2012 and with about 16 different countries of which these bottles of wine were made.

Data: Red.csv

2

Something like

lm(price ~ (year == 2011) + Italy, data = red)

?

1 Like
3

Yes that was it! Thank you.

4

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.