m1 <- lm(income ~ own_rent, data = listings_filtered )
m2 <- lm(income ~ own_rent + area, data = listings_filtered )
m3 <- lm(income ~ own_rent + area + marital, data = listings_filtered )
m4 <- lm(income ~ own_rent + area + marital + highest_income_gender, data = listings_filtered )
m5 <- lm(income ~ own_rent + area + marital + highest_income_gender + highest_income_religion, data = listings_filtered)
m6 <- lm(income ~ own_rent + area + marital + highest_income_gender + highest_income_religion + hhwork, data = listings_filtered )
m7 <- lm(income ~ own_rent + area + marital + highest_income_gender + highest_income_religion + hhwork + hedqual8, data = listings_filtered )
m8 <- lm(income ~ own_rent + area + marital + highest_income_gender + highest_income_religion + hhwork + hedqual8 + HIHSIC, data = listings_filtered )
m9 <- lm(income ~ own_rent + area + marital + highest_income_gender + highest_income_religion + hhwork + hedqual8 + HIHSIC + outdoor, data = listings_filtered )
m10 <-lm(income ~ own_rent + area +marital + highest_income_gender + highest_income_religion + hhwork + hedqual8 + HIHSIC + outdoor + health_general, data = listings_filtered )
m10_log <- listings_filtered %>%
lm(income ~ own_rent + area +
marital + highest_income_gender + highest_income_religion + hhwork + hedqual8 + HIHSIC + outdoor + health_general, data = .)
- When I use this algorithm, I get a table like this
But * I want a table like this
Model 1 Model 2 Model 3 Model 4 Model 5 Model 6
(Intercept) 142.58* 192.54* 117.82* 91.88* 74.90 151.12*
(1.44) (44.04) (43.19) (42.57) (42.38) (44.50)
Room Type
Room_TypePrivate room -81.35* -89.65* -76.03* -52.16* -41.21* -37.00*
(2.40) (2.46) (2.47) (2.70) (2.84) (2.95)
Room_TypeShared room 100.77* -54.22* -33.33 -14.44 0.27 49.56*
(16.23) (20.46) (20.04) (19.76) (19.70) (24.69)
Property Type
Property_TypeApartment -52.25 -51.64 -53.82 -48.89 -48.76
(44.02) (43.07) (42.43) (42.22) (41.53)
Property_TypeBarn -67.54 -50.70 -64.38 -47.51 -33.14
(103.16) (100.93) (99.42) (98.94) (92.79)
Property_TypeBed and breakfast -20.90 -23.92 -28.83 -26.23 -34.35
(45.55) (44.57) (43.90) (43.69) (43.39)
Property_TypeBoat 382.46* 384.82* 393.77* 401.80* 404.89*
(103.16) (100.92) (99.41) (98.93) (92.78)
Property_TypeBoutique hotel 195.48* 185.77* 181.36* 180.93* 87.33
(46.27) (45.27) (44.59) (44.37) (57.01)
Property_TypeBungalow -47.33 -50.14 -58.01 -54.19 -43.35
(45.95) (44.96) (44.29) (44.07) (43.51)
Property_TypeCabin -82.99 -70.69 -59.81 -63.95 -56.95
(87.96) (86.06) (84.77) (84.36) (79.44)
Property_TypeCamper/RV -106.82* -51.09 -56.04 -57.42 -49.35
(53.43) (52.32) (51.54) (51.29) (52.84)
Property_TypeCampsite -106.54 -31.82 -70.93 -63.47
(139.08) (136.10) (134.08) (133.42)
Property_TypeCasa particular (Cuba) -52.89 -49.67 -54.70 -50.05 -39.45
(103.13) (100.89) (99.38) (98.90) (124.42)
Property_TypeChalet -117.54 -100.70 -49.34 -53.12 -47.35
(139.08) (136.07) (134.05) (133.40) (124.48)
Property_TypeCondominium -44.54 -46.91 -50.78 -47.89 -49.59
(44.79) (43.82) (43.17) (42.96) (42.56)
Property_TypeCottage -57.72 -55.56 -63.57 -57.87 -58.09
(47.58) (46.55) (45.86) (45.64) (45.12)
Property_TypeEarth house -63.54 -75.65 -76.61 -64.08
(139.08) (136.07) (134.03) (133.38)
Property_TypeFarm stay -122.54 -105.70 -86.86 -71.26 -60.51
(139.08) (136.07) (134.03) (133.38) (124.46)
Property_TypeGuest suite -90.40 -88.65 -79.03 -71.39 -68.70
(47.73) (46.70) (46.00) (45.78) (45.21)
Property_TypeGuesthouse -2.37 4.62 11.09 12.04 -10.52
(48.09) (47.05) (46.35) (46.12) (46.87)
Property_TypeHostel 202.45* 221.42* 213.04* 204.43* 230.75*
(48.74) (47.69) (46.98) (46.76) (48.41)
Property_TypeHotel -8.72 4.14 -5.12 -15.12 -16.31
(69.53) (68.02) (67.01) (66.68) (79.44)
Property_TypeHouse -34.07 -46.66 -55.08 -48.75 -53.34
(44.14) (43.18) (42.54) (42.33) (41.67)
Property_TypeHut -72.89 -127.56 -107.15 -99.13 -98.82
(139.06) (136.06) (134.03) (133.37) (124.45)
Property_TypeLoft -62.68 -58.94 -52.47 -48.30 -40.30
(49.35) (48.28) (47.56) (47.32) (46.02)
Property_TypeOther -60.12 -53.76 -60.78 -57.49 -59.37
(57.21) (55.97) (55.13) (54.86) (54.51)
Property_TypeServiced apartment 11.97 3.78 5.58 10.22 -40.77
(45.58) (44.59) (43.93) (43.71) (43.24)
Property_TypeTent -45.28 -10.74 -11.61 -8.99 -4.60
(73.60) (72.02) (70.94) (70.59) (66.91)
Property_TypeTiny house -80.99 -68.69 -46.97 -41.48 -40.68
(87.96) (86.06) (84.78) (84.36) (92.79)
Property_TypeTownhouse -32.50 -51.91 -61.28 -56.11 -49.99
(44.60) (43.64) (42.99) (42.78) (42.08)
Property_TypeVilla -5.35 -16.93 -31.70 -30.33 -25.53
(49.78) (48.71) (47.98) (47.75) (46.69)
Property_TypeWindmill -72.54 -55.70 -36.86 -21.26 -10.51
(139.08) (136.07) (134.03) (133.38) (124.46)
R2 0.08 0.12 0.15 0.18 0.19 0.19
Adj. R2 0.08 0.11 0.15 0.18 0.18 0.19
Num. obs. 13647 13647 13647 13647 13647 11136
*p < 0.05
What should I do?