Annual Members and Casual Riders Comparison

Presented by: Utah Michael Ngbede

Date: 2022-08-22

Table of Content

Annual Members and Casual Riders Comparison

​

• Objective
• Data Presentation
• Data Analysis
• Conclusion

​

Objective

Analyze how annual members and casual riders use Cyclistic bikes differently.

Data Presentation

• Data sourced from https://divvy-tripdata.s3.amazonaws.com/index.html
• Data used for this analysis;

August 2021 to July 2022.

• Each data file contains 15 columns.
• Columns of interest for analysis;

Started_at, ended_at, member_casual

Data Analysis

• Added 3 columns to aid analysis

Ride_length, day_of_week, state_of_week

• Ride_length: difference in time from start to end of ride.
• Day_of_week: day of week ride was taken with 1 being Sunday.
• State_of_week: weekday rides are TRUE, while weekend rides are FALSE.
• Weekday rides are 2,3,4,5,6
• Weekend rides are 1,7

Data Analysis (insights)

​

​

​

• The amount of member users month over month is more than that of the casual riders

Data Analysis (insights)

​

​

​

• The amount of member users month over month on weekdays and on weekends are more than that of the casual riders

​

Data Analysis (insights)

​

​

​

• Member riders spent 42 percent of the total time while casual spent about 58 percent of the total time.

Data Analysis (insights)

​

​

​

​

• The average time casual riders spend per month is more those of member riders.

Data Analysis (insights)

• The amount of member users month over month for classic bike are more than that of the casual riders
• The amount of member users month over month for electric bike are more than that of the casual riders
• Member riders do not use docked bikes.

Conclusion

• Even with more member riders, casual users spend more time on average compared with member riders.
• Over a period of one-year, casual riders spent more time in total compared member riders both on weekdays and weekends.
• Only casual riders use docked bike.
• From the analysis, if campaigns can be made to convert the casual riders to member riders, Cyclistic would make more in terms of revenue.