Citibike Trip data (Excel)
1. Generate a map that shows each station. For each station, it should also easily and intuitively show how many trips start at that station and how long the average trip that starts at that station is. Attach your figure, with a short description as Figure 1.
2. We know that the average Citibike trip is 805 seconds. Is the average trip that starts on the island of Manhattan shorter or longer than 805 seconds? Is this difference statistically significant? Give the p-value and interpret it. (You may want to generate the data you need in Tableau, and then use Excel to calculate the statistics).
3. Set a filter to only include trips that End at station ID# 2006 (it is at the South end of Central Park). Show a figure that shows where the trips that end at station #2006 start, and how long those trips usually take. Try to get this figure to show as much information about the trips as possible. Attach this figure as Figure 2. Describe the figure in a short paragraph. What does this figure tell us? Which station has the most? What areas have the most? Which areas have the least?
4. Now, let’s examine only the trips that start at station #323. Make a graph that shows as much as you can about trips that start at station 323. Attach this as Figure 3. Answer the following questions in Table 1:
a) What is the average trip duration for stations starting at station 323?
b) What is the standard deviation? (Again, make sure you have filtered out all trips longer than 2700 seconds).
c) How many trips were there in June 2016 that started at station 323?
d) At how many different stations did people drop off their bikes after starting the trip at station 323?