Cyclistic Case Study 1

April 10, 2023

I am a junior data analyst working in the marketing analytics team at Cyclistic, a bike-share company in Chicago. The director of marketing believes the company’s future success depends on maximizing the number of annual memberships.

The company has 3 pricing plans which these are:

  • Single-ride passes
  • Full-day passes
  • Annual memberships

Customers who purchase single-ride or full-day passes are referred to as casual riders. Customers who purchase annual memberships are Cyclistic members. In this case study I prefer to use Spreadsheet, R, and Google Slides. Unfortunately, company data was too big for the Spreadsheet so I decided to choose a sample dataset and work on it. The dataset has % 98 confidence level and %2 merges of error level. Sample sizes are chosen depending on the Sample Size Calculator Sheet shared with course content.

You will find the sample sizes dataset and the R codes in the files. If you prefer, you can skip this section and go directly to the presentation of the study's results. If you are a course student and want to see detailed processes you can visit my blog. Also, you can visit my blog content, which addresses the other most common question that was “Is it normal to get stuck during the first data project?”

Data were obtained directly from company records available at: https://divvy-tripdata.s3.amazonaws.com/index.html

License to use data is available at: https://www.divvybikes.com/data-license-agreement