The American Community Survey of New York data describe a family’s economic, housing, and demographic information such as yearly incomes, family type (married, female head
The American Community Survey of New York data describe a family's economic, housing, and demographic information such as yearly incomes, family type (married, female head, male head, etc), number of people, number of children, if the family is living on FoodStamp (1=Yes, 0=No), number of people who are currently employed, etc. Use this data set to answer the following questions:
Questions:
1. Choose an appropriate model to determine if there is family income (i.e., FamilyIncome in the data set) difference among different types of families (i.e., FamilyType in the data set) in the state of New York?
2. Choose an appropriate model to determine if there is family income (FamilyIncome) difference between families with kids and families without kids? (Note: There is currently no column holding data about whether a family has kids. You may want to use the with() function in R to create a new column to hold the binary answers.)
Click Here for How to Use the with() Function.
3. Choose an appropriate model, and use FamilyIncome, NumChildren, NumPeople, NumWorkers to predict the probability that a family is living on FoodStamp.
(Note: please ignore the warning message such as glm.fit: fitted probabilities numerically 0 or 1 occurred if you see one)
Please save the screenshots of the data analysis results and your interpretations of the results into a Word document, and name it as "MyAssignment1". Thank you!
Acres | FamilyIncome | FamilyType | NumBedrooms | NumChildren | NumPeople | NumRooms | NumUnits | NumVehicles | NumWorkers | OwnRent | YearBuilt | HouseCosts | ElectricBill | HeatingFuel | Insurance | Language | FoodStamp |
10-Jan | 150 | Married | 4 | 1 | 3 | 9 | Single detached | 1 | 0 | Mortgage | 1950-1959 | 1800 | 90 | Gas | 2500 | English | 0 |
10-Jan | 180 | Female Head | 3 | 2 | 4 | 6 | Single detached | 2 | 0 | Rented | Before 1939 | 850 | 90 | Oil | 0 | English | 0 |
10-Jan | 280 | Female Head | 4 | 0 | 2 | 8 | Single detached | 3 | 1 | Mortgage | 2000-2004 | 2600 | 260 | Oil | 6600 | Other European | 0 |
10-Jan | 330 | Female Head | 2 | 1 | 2 | 4 | Single detached | 1 | 0 | Rented | 1950-1959 | 1800 | 140 | Oil | 0 | English | 0 |
10-Jan | 330 | Male Head | 3 | 1 | 2 | 5 | Single attached | 1 | 0 | Mortgage | Before 1939 | 860 | 150 | Gas | 660 | Spanish | 0 |
10-Jan | 480 | Male Head | 0 | 3 | 4 | 1 | Single detached | 0 | 0 | Rented | Before 1939 | 700 | 140 | Gas | 0 | English | 0 |
10-Jan | 520 | Male Head | 3 | 2 | 3 | 8 | Mobile home | 0 | 0 | Mortgage | 1980-1989 | 270 | 130 | Wood | 100 | English | 1 |
10-Jan | 550 | Male Head | 3 | 1 | 2 | 5 | Single detached | 1 | 1 | Rented | 2007 | 800 | 1 | Gas | 0 | English | 1 |
10-Jan | 1400 | Female Head | 3 | 1 | 4 | 9 | Single detached | 2 | 1 | Mortgage | Before 1939 | 710 | 150 | Gas | 1000 | English | 0 |
10-Jan | 1400 | Female Head | 3 | 2 | 3 | 7 | Single detached | 1 | 1 | Mortgage | 1980-1989 | 1500 | 300 | Electricity | 0 | English | 0 |
10-Jan | 1730 | Married | 5 | 0 | 2 | 8 | Single detached | 3 | 0 | Mortgage | 2000-2004 | 1500 | 170 | Gas | 600 | English | 0 |
10-Jan | 1800 | Female Head | 3 | 3 | 6 | 6 | Single attached | 1 | 0 | Rented | Before 1939 | 500 | 150 | Electricity | 0 | English | 1 |
10-Jan | 1850 | Female Head | 3 | 2 | 4 | 7 | Single detached | 3 | 1 | Rented | 1970-1979 | 500 | 170 | Electricity | 0 | English | 1 |
10-Jan | 2000 | Married | 3 | 0 | 3 | 6 | Single detached | 2 | 1 | Mortgage | 1970-1979 | 2200 | 170 | Oil | 750 | English | 0 |
10-Jan | 2000 | Married | 5 | 6 | 8 | 8 | Single detached | 0 | 1 | Mortgage | 2000-2004 | 900 | 2 | Wood | 0 | Other European | 0 |
10-Jan | 2600 | Male Head | 3 | 3 | 4 | 5 | Single detached | 1 | 0 | Mortgage | 1980-1989 | 1300 | 110 | Gas | 600 | Other European | 1 |
10-Jan | 2730 | Married | 4 | 0 | 4 | 9 | Single detached | 4 | 2 | Mortgage | 1950-1959 | 530 | 140 | Oil | 750 | Spanish | 0 |
10-Jan | 3430 | Married | 4 | 0 | 4 | 7 | Single detached | 1 | 0 | Mortgage | Before 1939 | 580 | 160 | Oil | 600 | Other European | 0 |
10-Jan | 3500 | Married | 2 | 0 | 2 | 4 | Mobile home | 3 | 1 | Mortgage | 2000-2004 | 500 | 110 | Oil | 460 | English | 0 |
10-Jan | 3580 | Female Head | 3 | 2 | 3 | 4 | Single detached | 1 | 1 | Mortgage | 2000-2004 | 200 | 80 | Gas | 400 | English | 0 |
10-Jan | 3600 | Female Head | 3 | 2 | 6 | 6 | Single detached | 2 | 0 | Rented | 1980-1989 | 500 | 240 | Oil | 0 | English | 1 |
10-Jan | 3660 | Female Head | 2 | 0 | 2 | 6 | Single detached | 2 | 0 | Mortgage | 1940-1949 | 550 | 130 | Wood | 640 | English | 1 |
10-Jan | 3700 | Female Head | 2 | 1 | 3 | 6 | Single detached | 2 | 1 | Rented | 1950-1959 | 600 | 80 | Gas | 0 | English | 0 |
10-Jan | 4000 | Married | 2 | 0 | 2 | 6 | Single detached | 2 | 1 | Mortgage | 1970-1979 | 680 | 100 | Oil | 700 | English | 0 |
10-Jan | 4400 | Female Head | 3 | 2 | 3 | 5 | Single detached | 0 | 1 | Rented | Before 1939 | 1200 | 120 | Gas | 0 | Spanish | 0 |
10-Jan | 4500 | Female Head | 3 | 1 | 2 | 9 | Single detached | 1 | 0 | Mortgage | 1980-1989 | 1500 | 200 | Oil | 600 | English | 0 |
10-Jan | 4550 | Female Head | 2 | 1 | 2 | 5 | Single detached | 0 | 1 | Rented | 1950-1959 | 1400 | 100 | Gas | 0 | Spanish | 0 |
10-Jan | 4970 | Female Head | 3 | 1 | 3 | 7 | Single detached | 1 | 1 | Rented | 1940-1949 | 400 | 70 | Gas | 0 | English | 1 |
10-Jan | 5000 | Female Head | 4 | 0 | 2 | 6 | Single detached | 1 | 0 | Mortgage | 1980-1989 | 800 | 200 | Gas | 500 | Other European | 0 |
10-Jan | 5000 | Female Head | 4 | 1 | 3 | 8 | Single detached | 3 | 1 | Mortgage | 1990-1999 | 1600 | 280 | Oil | 1000 | English | 0 |
10-Jan | 5140 | Female Head | 2 | 1 | 3 | 3 | Mobile home | 1 | 1 | Rented | 1970-1979 | 400 | 80 | Oil | 0 | English | 0 |
10-Jan | 5200 | Female Head | 2 | 3 | 4 | 4 | Single attached | 1 | 1 | Rented | 1960-1969 | 1000 | 120 | Gas | 0 | Other | 1 |
10-Jan | 5500 | Female Head | 2 | 2 | 3 | 3 | Single detached | 1 | 0 | Rented | 2000-2004 | 500 | 50 | Oil | 0 | English | 1 |
10-Jan | 5500 | Married | 3 | 3 | 5 | 5 | Single detached | 2 | 1 | Rented | 1970-1979 | 450 | 60 | Wood | 0 | English | 1 |
10-Jan | 5610 | Female Head | 3 | 0 | 2 | 7 | Mobile home | 1 | 1 | Mortgage | 1990-1999 | 200 | 140 | Gas | 400 | English | 0 |
10-Jan | 5700 | Female Head | 4 | 2 | 5 | 6 | Single detached | 0 | 0 | Rented | 1960-1969 | 830 | 80 | Gas | 0 | English | 1 |
10-Jan | 5800 | Married | 3 | 0 | 2 | 6 | Single detached | 2 | 0 | Mortgage | 1950-1959 | 900 | 400 | Electricity | 2000 | English | 0 |
10-Jan | 6180 | Married | 4 | 0 | 2 | 8 | Single detached | 3 | 1 | Mortgage | 2000-2004 | 440 | 160 | Oil | 880 | Other European | 0 |
10-Jan | 6300 | Married | 3 | 2 | 4 | 6 | Single detached | 2 | 0 | Rented | 1960-1969 | 950 | 160 | Oil | 0 | English | 0 |
10-Jan | 6750 | Female Head | 4 | 0 | 4 | 7 | Single detached | 3 | 0 | Rented | Before 1939 | 500 | 60 | Oil | 0 | English | 1 |
10-Jan | 6800 | Female Head | 3 | 2 | 5 | 6 | Single detached | 2 | 0 | Rented | Before 1939 | 600 | 150 | Oil | 0 | English | 1 |
10-Jan | 6990 | Married | 5 | 7 | 9 | 7 | Mobile home | 1 | 0 | Rented | 1970-1979 | 500 | 400 | Oil | 0 | English | 1 |
10-Jan | 7000 | Female Head | 3 | 0 | 3 | 7 | Mobile home | 1 | 1 | Rented | 1980-1989 | 800 | 200 | Oil | 0 | English | 0 |
10-Jan | 7000 | Married | 3 | 3 | 6 | 5 | Single detached | 2 | 1 | Mortgage | 1990-1999 | 1400 | 300 | Other | 1700 | Spanish | 0 |
10-Jan | 7200 | Female Head | 5 | 0 | 3 | 9 | Single detached | 3 | 0 | Mortgage | 1990-1999 | 530 | 270 | Oil | 2600 | English | 0 |
10-Jan | 7200 | Married | 5 | 0 | 2 | 11 | Single detached | 1 | 0 | Rented | 1940-1949 | 300 | 40 | Oil | 0 | English | 0 |
10-Jan | 7600 | Male Head | 4 | 0 | 2 | 7 | Single detached | 2 | 0 | Mortgage | Before 1939 | 470 | 230 | Gas | 640 | English | 0 |
10-Jan | 8000 | Female Head | 3 | 2 | 4 | 8 | Single detached | 2 | 1 | Mortgage | 1980-1989 | 200 | 170 | Wood | 120 | English | 1 |
10-Jan | 8000 | Male Head | 4 | 1 | 3 | 9 | Single detached | 4 | 1 | Mortgage | Before 1939 | 890 | 100 | Coal | 450 | English | 0 |
10-Jan | 8400 | Female Head | 2 | 1 | 2 | 4 | Single detached | 0 | 0 | Rented | 1940-1949 | 1300 | 170 | Electricity | 0 | Spanish | 1 |
10-Jan | 8400 | Female Head | 3 | 1 | 2 | 5 | Mobile home | 1 | 0 | Rented | 1980-1989 | 400 | 100 | Gas | 0 | English | 1 |
10-Jan | 8600 | Male Head | 4 | 1 | 4 | 7 | Single detached | 2 | 1 | Rented | 1940-1949 | 550 | 180 | Gas | 0 | English | 1 |
10-Jan | 8700 | Married | 5 | 3 | 5 | 10 | Mobile home | 3 | 1 | Mortgage | 1990-1999 | 330 | 280 | Gas | 0 | English | 0 |
10-Jan | 8800 | Female Head | 3 | 0 | 2 | 5 | Single attached | 0 |