Overview
You will be tasked to answer analytical questions relevant to the topics covered in class (i.e. Descriptive Statistics, inferential statistics such as confidence intervals, 1- and 2- sample hypothesis testing, etc.) In this project, you will demonstrate your ability to understand such topics, use technology to manipulate data and calculate statistics, and ultimately communicate your findings in a professional manner. This will be facilitated through a set of professionally formatted sections. (all in 1 excel document) Project Background
Bikeshare, also known as bike rental or bike sharing, is a system in which bicycles are made available for shared use to individuals on a short-term basis. Typically, bikeshare systems are designed to provide users with a convenient, affordable, and healthy mode of transportation in urban areas. In a typical bikeshare system, users can locate and rent bikes from self-service stations located throughout the service area. The bikes are equipped with locks and can be unlocked using a mobile app or a membership card. Users can ride the bikes for a specified amount of time and then return them to any available station within the system. Bikeshare systems have become increasingly popular in recent years, particularly in cities around the world. They offer a sustainable and efficient way to get around congested urban areas, reduce traffic congestion, and promote physical activity. This data set contains data and information for specific rides in a prior month in 2024 for the city of Washington D.C. (this was the latest version of the data available)
All personally identifying information was removed from the data. A unique data identifier called ride_id is used to differentiate specific records. The overall goal will be to better understand the bikeshare market in Washington, D.C. and for the student to accurately manipulate data, calculate statistics, run hypothesis testing using excel, and communicate findings in an understandable way. The dataset Capital Bikeshare Data.xlsx is comprised of 4 tabs. The first is Data Dictionary which lists out the variables and gives their definitions. The second is data which is the raw data that will be used for your analysis. The other two tabs are used specifically for Section D and E respectively. Variable Description ride_id Unique numerical identifier for specific ride/rental rideable_type The type of bike used in the ride (“docked_bike” “classic_bike” or “electric_bike”) started_at The date and time that the bike rental started day_of_week_start The day of the week that the bike rental was initiated (1 = Sunday, 2 = Monday, etc.) ended_at The date and time that the bike rental ended time_spent The amount of time that passed between the start and end of the rental (minutes) start_station_name The name of the docking station where the ride started start_station_id The id number of the docking station where the ride started. end_station_name The name of the docking station where the ride ended end_station_id The id number of the docking station where the ride ended. start_lat The latitude where the ride started. start_lng The longitude where the ride started. end_lat The latitude where the ride ended. end_lng The longitude where the ride ended. distance The distance between the starting point and ending point. Member_casual The type of customer that is using the bike. (“member” or “casual”) Guidelines and Requirements The following section is to be done in accordance with the Brightspace quiz called “Bikeshare Data Project.” Please go to our Brightspace class, then to Assessments – Quizzes and Exams – Bikeshare Data Project and Click Start Quiz. Section A – Data Dictionary & Variable Identification
Bikeshare Dataset Analysis Project Business Statistics Provide a data dictionary with the correct variable types identified. You will categorize the variables in the data as (1) Qualitative or Quantitative, and (2) Nominal, Ordinal, Interval, or Ratio level of measurement. Complete this is in the Excel file and in the BrightSpace Quiz. Section B – Descriptive & Visual Statistics Give Descriptive Statistics in table format for the raw data set (“data” tab). The 5 variables that you will evaluate are rideable_type, day_of_week_start, time_spent, distance, and member_casual. Make sure to include appropriate statistics given the correct variable type (Quantitative or Qualitative) a. Quantitative - Mean, Median, Mode, Standard Deviation, Variance, Range, Count (“n”), 99% confidence interval (either Z-based or t-based) b. Qualitative – Frequencies, Relative Frequencies For each variable, give a relevant visualization. Describe notable characteristics of the distributions such as shape of the quantitative distribution (skew) and other things of note. a. Quantitative – Histogram b. Qualitative – Bar Chart or Pie Chart Section C – One-sample hypothesis testing Perform/Document 7-step hypothesis test to test if there is sufficient evidence that time spent on a ride is less than 15 minutes. Assume ? = .01. Section D - Two-sample hypothesis testing Perform/Document 7-step hypothesis test to test if there is statistically significant difference in the amount of time spent on a ride between members and casual riders. Assume ? = .05. Section E – ANOVA Perform/Document 7-step hypothesis test to test if there is significant statistical evidence that the time spent on a ride is dependent on the day of the week. Assume ? = .01. Section F – Correlation Generate a scatterplot of the variables time_spent and distance. Also, generate the correlation of these variables. (either by using the data analysis toolpak or an excel function). Qualitatively describe the correlation of these variables. What might this mean? (*** OPTIONAL***) Section G – Dashboard
Bikeshare Dataset Analysis Project Business Statistics Come up with 3 data visualizations or KPIs that you think would be applicable for a manager at Capital Bikeshare to have on either a daily or weekly dashboard. Note that one or more of these may be visualizations or statistics that you already have calculated. Name the visualizations, explain why they should be on a dashboard for a manager, and show them in an excel table called “Dashboard.” Submit your .xlsx file to the assignment box by the due date. Note that the file should be complete with all of the answers and excel functions live. I strongly suggest you watch the walkthrough video that I have provided, and I strongly encourage you to come to me with any questions you have. Do not delay in reaching out with questions so that you are on the right track and give yourself the best chance for success. Bikeshare Dataset Analysis Project - Project Checklist Points Available Section A – Data Dictionary & Variable Identification ? Correctly answered statistical questions in Brightspace 30 Section B – Descriptive & Visual Statistics ? Included table(s) of all descriptive statistics correctly calculated ? Included appropriate visualizations and interpretation of variables distributive shape/skewness ? Correctly answered statistical questions in Brightspace 45 Section C – One-Sample Hypothesis Testing ? Professionally and correctly displayed statistical output in excel ? Correctly answered statistical questions in Brightspace 35 Section D – Two-Sample Hypothesis Testing ? Professionally and correctly displayed statistical output in excel ? Correctly answered statistical questions in Brightspace 35 Section E – ANOVA ? Professionally and correctly displayed statistical output in excel ? Correctly answered statistical questions in Brightspace 35 Section F – Correlation ? Professionally and correctly displayed statistical output in excel ? Correctly answered statistical questions in Brightspace 20 Section G – Dashboard ? Professionally and correctly displayed dashboard in excel ? Correctly answered statistical questions in Brightspace