104624234_Mendonca_ws2

pdf

School

Algoma University *

*We aren’t endorsed by this school

Course

100

Subject

Statistics

Date

Apr 3, 2024

Type

pdf

Pages

8

Uploaded by AmbassadorCat5961

Report
BAN140 Introduction to Data Visualization WorkShop2 Page 1 of 8 Question 1. Click on # in the header of the first column. What is the data type of “trip duration”? Ans: The data type of trip duration is Number (whole) Question 2. Now click on the ‘Abc’ above “start station name” column. What is the data type for this column? Ans: The data type of trip duration is string. Question 3. How many variables do you have per each data type (e.g., integer, float, string, date)? Ans: There are 4 data types for the variables: number (whole), number (decimal), Date and time, String Number (whole) - trip duration, start station ID, BikeID, Birth year, Gender, End station ID (6 variables) Number (decimal) – Start station Latitude, Start station Longitude, End station Latitude, End station Longitude (4 variables) Date & Time – start time, stop time (2 variables) String – Start station name, End station name, User type (3 variables) Question 4. Click on the sorting symbol for Bikeid to sort in ascending or descending order. What is the lowest Bikeid in this table? What is the highest Bikeid in this table? Ans: The lowest BikeID is 14,648 and the highest BikeID is 39,949 Question 5. Present a detailed data exploration that includes your own analysis of the data after loading the table. The goal of this question is for you to explain the data as much as you can before starting the exploration using visualizations. (Minimum 250 words) Ans: From the dataset provided, what we can observe the trip was done month of August 2019. We can analyse the number of trips done in specific longitude and latitude done from start to end point of the station. We can also see the number of subscribers and customers starting the trip from various locations. Most of the trips were started from multiple stations and ended at multiple stations. Also, it was observed that the number of subscribers we more than the number of customers. People born in the birth year 1969 had the highest trip duration compared to the other birth years. Question 6. Does the dataset have null values? Ans: No, there is no null value in the data set. Question 7. Do you see any column that might not be useful and you can drop it? Explain the reason. Ans: The column “Birth year” might not be useful because in a trip the birth year is not an important criteria as age is just a number.
BAN140 Introduction to Data Visualization WorkShop2 Page 2 of 8 Question 8. Write the name of three fields from Dimensions. Ans: Birth year, Start station name, End station name are three fields from dimensions. Question 9. Write the name of three fields from Measures. Ans: Start Station ID, Start station Longitude, Start Station Latitude are the three fields from measures. Question 10. Question 11. What is the station name with the shortest total trip duration? Ans: NYCBS depot - Delancey is the name of the station with shortest total trip duration.
BAN140 Introduction to Data Visualization WorkShop2 Page 3 of 8 Question 12. Question 13. What type of graph did you get? Ans: The line-graph is now horizontally represented with start time in x axis and trip duration in y axis.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
BAN140 Introduction to Data Visualization WorkShop2 Page 4 of 8 Question 14.
BAN140 Introduction to Data Visualization WorkShop2 Page 5 of 8 Question 15.
BAN140 Introduction to Data Visualization WorkShop2 Page 6 of 8 Create the Visualizations Trip Duration per birth year. To create this graph use the variables birth year and trip duration. The goal is to find what is the birth year with the longest trip duration. Question 16 . Ans: The birth year is 1969 and the trip duration is 50,97,06,403
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
BAN140 Introduction to Data Visualization WorkShop2 Page 7 of 8 Create the Visualizations Trip Duration per user type. Question 17.
BAN140 Introduction to Data Visualization WorkShop2 Page 8 of 8 Deliverables : Add this declaration to your submission file: I, Gelasia Mendonca declare that the attached assignment is our own work in accordance with the Seneca Academic Honesty Policy . I/We do not copy any part of this assignment, manually or electronically, from any other source including web sites, unless specified as references. I do not distribute my work to other students. Name Task(s) 1 Gelasia Mendonca Workshop 2 Using Blackboard, submit a PDF file and the Tableau file Save your group work as < 104624234 >_< Mendonca >_ws2.pdf < 104624234 >_< Mendonca >_ws2.twbs SENECA’S ACADEMIC HONESTY POLICY As a Seneca student, you must conduct yourself in an honest and trustworthy manner in all aspects of your academic career. A dishonest attempt to obtain an academic advantage is considered an offense and will not be tolerated by the College.

Related Documents

Week 7 Homework Problems.docx
3B. Error Theory - Part 2.pdf
R Code Discussion 3_4.pdf
Res Meth & Stats l-Intro to JASP.docx
412612Test1.docx
104624234_Mendonca_ws5.pdf
6_CaRedoxReport_Ella Keheley.pdf
ENV 220 Creating Graphs Template.docx
HW 6 - FA21-1.pdf
EPI540_Midterm2_2024-1.pdf
BEIR VII Phase 2 Essay - Jan. 30 @ 6_32 pm.docx
IMG_0173.png
Recommended textbooks for you
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Text book image
Intermediate Algebra
Algebra
ISBN:9781285195728
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Text book image
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Text book image
Intermediate Algebra
Algebra
ISBN:9781285195728
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Text book image
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
SEE MORE TEXTBOOKS