please provide legible answers
A sociologist is looking at the relationship between consumption expenditures of families in the United States (Consumption in 5) family income (Income in $), and whether or not the family lives in an urban or rural community (Urban=tif urban, otherwise) She collects data on 50 families across the United States, a portion of which is shown in the accompanying table. Consumption 62,376 Urban Incone 87,622 94,899 60,286 59.219 101,029 1 Dicture Click here for the Excel Data File a. Estimate Consumption = 80+ B Income to predict consumption for a family with income of $76,000. (Round coefficient estimates to at least 4 decimal places and round final answer to the nearest whole number.) Predicted consumption appenditures b. Include a dummy variable Urban to predict consumption for a family with income of $76,000 in urban and rural communities. (Round coefficient estimates to at least 4 decimal places and round final answer to the nearest whole number.) Predicted Consumption Urban Community Rural community b. Include a dummy variable Urban to predict consumption for a family with income of $76,000 in urban and rural communities (Round coefficient estimates to at least 4 decimal places and round final answer to the nearest whole number.) Predicted Consumption Urban community Rural community c. Include Income, a dummy variable Urban and an interaction variable income Urban) to predict consumption for a family with income of S76,000 in urban and rural communities (Round coefficient estimates to at least 4 decimal places and round final answer to the nearest whole number) Predicted Consumption Urban community Rural community d. Which of the preceding models is most suitable for the data? since it has the H20 D 0 1 1 0 0 1 1 1 0 1 0 1 1 0 1 B 1. Consumption Income Urban 2 62376 87623 3 60286 94899 4 70332 106123 5 43173 60819 6 26151 51077 7 52533 89196 8 45788 62836 9 59259 72011 10 46020 64691 11 60341 98134 12 36646 69503 13 62808 88953 14 54138 87763 15 48900 68043 16 54794 91484 17 66469 112514 18 65171 86258 19 64852 100092 20 63954 105296 21 76054 22 103402 23 39368 52725 24 33714 63839 25 52288 73965 58716 75002 22 71623 94595 59024 97410 70002 81508 63269 84869 42632 102603 59012 154012 29359 48916 58030 15 58434 53840 1975 40107 17 53703 75181 6624 64426 1154 40 59754 3556 25033 1 0 1 1 95663 1 79850 1 O 1 0 1 1 1 0 O 1 NBABASA E95 71629 1 O O 1 1 55015 Urta Home Insert Draw ile Page Layout PROTECTED VIEW This file has been verified by Micros 20 A D OH 1 0 1 0 0 0 42632 102603 59042 85412 29359 48916 58030 71629 58434 53840 19785 40107 53703 76181 66244 97494 64426 134454 59754 85567 28092 55415 52142 78995 64379 87147 26239 66779 71630 114916 31883 62076 69171 123206 23949 54415 54182 102751 49147 90307 59219 101023 1 1 1 0 1 0 0 5 5 7 8 9 0 11 12 13 14 45 46 47 40 49 50 51 52 53 54 55 50 57 Da 59 60 61 02 1 1 o 1 1 1 66 OY
