Citi Bike is the nation's largest bike share program, with $12,000$ bikes and $750$ stations across Manhattan, Brooklyn, Queens and Jersey City. It can be used for quick trips with convenience in mind, and it$$s also a fun and affordable way to get around town.

The following data set contains bike sharing transactions for July, August, and September $2019$:

Citibike Jul to Sep $2019.$xlsx

Download Citibike Jul to Sep $2019.$xlsx

This data set contains the following attributes:

tripduration $($seconds$)$

starttime: $($Excel date & time format$)$

stoptime: $($Excel date & time format$)$

start$\_$station$\_$id $($integer$)$

start$\_$station$\_$name $($alphanumeric$)$

start$\_$station$\_$latitude $($latitude$)$

start$\_$station$\_$longitude $($longitude$)$

end$\_$station$\_$id $($integer$)$

end$\_$station$\_$name $($alphanumeric$)$

end$\_$station$\_$latitude $($latitude$)$

end$\_$station$\_$longitude longitude$)$

bike$\_$id $($integer$)$

usertype $($Customer $=$ time based rental, Subscriber $=$ annual member$)$

birthyear $($integer$,$ yyyy$)$

gender $($integer$,$ Zero$=$unknown, $1=$male, $2=$female$)$

Assignment:

Use Tableau to analyze the above data set and create visualizations to answer the following questions:

$1.$ Analyze starting point stations and corresponding trip times. Create a geo map visualization showing the average trip duration per starting station. You can do this by having the station mark size increase with the average trip duration. $(4$ points$)$

$2.$ Analyze starting point stations to their ending point stations. Create a text table visualization that shows the average time between station points. $(3$ points$)$

$3.$ Analyze the top ten starting point stations by number of rentals. Use a horizontal bar chart for the visualization, where the row is the station and is in descending order. $(3$ points$)$

Submit your resulting Tableau workbook with data $($saved as a $.$twbx$$ file$)$ via Canvas.