Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bike sharing systems are new generation of traditional bike rentals where whole process from membership, rental and return back has become automatic. Through these systems,

Bike sharing systems are new generation of traditional bike rentals where whole process from membership, rental and return back has become automatic. Through these systems, user is able to easily rent a bike from a particular location and return it back at another position (location). Bike-sharing rental process is highly correlated to the environmental and seasonal settings. For instance, weather conditions, precipitation, day of week, season, hour of the day, etc. can affect the rental behaviors. The core data set is related to the two-year historical log corresponding to years 2011 and 2012 from Capital Bikeshare system, Washington D.C., USA which is publicly available at http://capitalbikeshare.com/system-data.

Data description (column name definitions):

Date: Date.

Season: Season (1 to 4).

Year: Year (2011 to 2012).

Month: Month (1 to 12).

Holiday: Weather a particular day is a holiday or not. (1: Holiday, 0: Nonholiday)

Weekday: Day of the week (1: Monday, 7: Sunday).

WorkingDay: If day is neither weekend nor holiday is 1, otherwise is 0.

Weather:

1: Clear, Few clouds, Partly cloudy, Partly cloudy

2: Mist + Cloudy, Mist + Broken clouds, Mist + Few clouds, Mist

3: Light Snow, Light Rain + Thunderstorm + Scattered clouds, Light Rain + Scattered clouds

4: Heavy Rain + Ice Pallets + Thunderstorm + Mist, Snow + Fog

Temp: Temperature in Celsius.

ATemp: Feeling temperature in Celsius.

Humidity: Humidity.

WindSpeed: Wind speed.

Casual: Count of casual users.

Registered: Count of registered users.

Count: Count of total bike riders including both casual and registered.

Descriptive Data Analysis:

Given the above described data we would like to have a good understanding of the variables that are being used. Use R to analyze the data and answer the following question:

Find the average of bike riders (Count) for each weekday and calculate the percentages.

Day

Weekday

Average of bike riders

Percentage

1

Mon

2

Tue

3

Wed

4

Thu

5

Fri

6

Sat

7

Sun

Plot a line plot in R to show the results from (a). (x axis represents Weekday, and y axis represents the average of bike riders for each weekday).

What is the total number of casual bike riders in 2012?

What is the average temperatures for each season (1 to 4)?

What is the average daily bike riders for each month in 2011? Plot a line plot in R to show your results. (x axis represents Month, and y axis represents the average daily bike riders for each month).

Month (in 2011)

Average daily bike riders for each month

1

2

12

Find the correlation coefficient of Temp and Count.

answer should contain a minimum of 1) questions; 2) answers for each question; 3) corresponding R codes and outputs in the console; 4) supporting charts and graphs (screenshots are okay).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago