{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment 4

# Assignment 4 - Assignment 4 Explore the data using relevant...

This preview shows pages 1–3. Sign up to view the full content.

Assignment 4 Explore the data, using relevant tools. (1) I use crosstab in Excel. As I notice that this data contains both the alternatives and purpose of the trips, I use income as a constraint to analysis between different purposes of trips compared with different type of alternatives. It is a new way to collapse when there are multiple choices. In Table 1.1, in Car segment, we notice, business people will have more percentage when their incomes are between 50 and 70. Whereas, it is interesting to find the income around 30 may have the largest probability to use car for purpose of recreation. It will be more interesting if the number of sample is larger. (2) Estimate the relationship between alternatives and trip purpose (Table 1.2). We find that business is the top 1 purpose of trips. The passengers who take air are mostly (74.07%) have trip purpose in business. Meanwhile, people will use rail as a purpose for commute most. Also, people will go for business by rail a lot too. And it is interesting to find people will use car over the purpose of recreation in a percentage of 93.66%. Table 1.2 Crosstab between trip purposes and alternatives Commute Business Recreation Other Sum Rail 21.74% 55.90% 1.86% 20.50% 100.00% Bus 8.33% 27.08% 12.50% 52.08% 100.00% Air 11.11% 74.07% 0.00% 14.81% 100.00% Car 16.33% 34.88% 14.01% 34.77% 100.00% Sum 16.62% 38.31% 11.98% 33.08% 100.00% Commute Business Recreation Other Sum Rail 17.77% 19.82% 2.11% 8.42% 13.59% Bus 2.03% 2.86% 4.23% 6.38% 4.05% Air 1.52% 4.41% 0.00% 1.02% 2.28% Car 78.68% 72.91% 93.66% 84.18% 80.08% Sum 100.00% 100.00% 100.00% 100.00% 100.00% (3) Estimate the relationship between income and alternatives. Lower income people may prefer to take bus than higher one. To the contrary, lower income people won’t choose air as an alternative. And for rail and car, they share the same distribution by income, which reach top around income of 50 and remain in a high percentage between 30 and 70. Table 1.3 Crosstab between alternatives and income

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Alternative Rail Bus Air Car Sum 15 7 13 0 60 80 30 21 15 0 223 259 50 43 6 5 266 320 70 28 6 7 172 213 90 26 3 9 99 137 130 36 5 6 129 176 Sum 161 48 27 949 1185 (4) Estimate whether trip starts or ends in Chicago. It is very interesting to find, the people who have trip start or end in Chicago will have little chance using car rather than using rail. See in Table 1.4. For analysis this phenomenon, I create another table (Table 1.5), which illuminates the relationship between alternatives and whether Wisconsin resident or not. For resident of Wisconsin, only 18% of them travel by rail, and for non-resident of Wisconsin, the percentage is less. The reason why so many people choose to go to Chicago by rail, maybe it is really convenience, even more convenience than car.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}