A school is conducting a survey of students to learn more about how they get to school. Students were asked how they travel to school, how long it takes them to get to school, what time they arrive at school, and for a description of their most significant challenges when traveling to school. Several rows of the data collected are shown in the table below. Student ID How Travel How Long Time Arrive Biggest Challenges 738192 Car 10 minutes 7:30 am None 781401 Car 20 minutes 7:45 am 72001 5 hours Car 7:40 am 74012 Sister sometimes sleeps in and I miss my bus Bus 10-20 minutes 7:35 am 75441 Walk 1 hour 7:30 am 73109 Walk 20 mins 7:45 am 76120 Bus twenty minutes 7:35 am 73012 Car 15 min 7:20 am Waking up! Which column of data might be able to be visualized or analyzed but first would need to be cleaned? A) How Travel B) Time Arrive C How Long Biggest Challenges © O O O

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter4: Analyzing And Charting Financial Data
Section: Chapter Questions
Problem 3.9CP
icon
Related questions
Question
(a) A school is conducting a survey of students to learn more about how they get to school. Students were asked how they travel to school, how long it takes them to get to school, what time they arrive at school, and for a
description of their most significant challenges when traveling to school. Several rows of the data collected are shown in the table below.
Student ID How Travel How Long
Time Arrive Biggest Challenges
738192
Car
10 minutes
7:30 am
None
781401
Car
20 minutes
7:45 am
72001
Car
5 hours
7:40 am
74012
Bus
10-20 minutes 7:35 am
Sister sometimes sleeps in and I miss my bus
Walk
1 hour
75441
7:30 am
73109
Walk
20 mins
7:45 am
76120
Bus
twenty minutes
7:35 am
73012
Car
15 min
7:20 am
Waking up!
Which column of data might be able to be visualized or analyzed but first would need to be cleaned?
How Travel
B Time Arrive
(© How Long
O Biggest Challenges
Transcribed Image Text:(a) A school is conducting a survey of students to learn more about how they get to school. Students were asked how they travel to school, how long it takes them to get to school, what time they arrive at school, and for a description of their most significant challenges when traveling to school. Several rows of the data collected are shown in the table below. Student ID How Travel How Long Time Arrive Biggest Challenges 738192 Car 10 minutes 7:30 am None 781401 Car 20 minutes 7:45 am 72001 Car 5 hours 7:40 am 74012 Bus 10-20 minutes 7:35 am Sister sometimes sleeps in and I miss my bus Walk 1 hour 75441 7:30 am 73109 Walk 20 mins 7:45 am 76120 Bus twenty minutes 7:35 am 73012 Car 15 min 7:20 am Waking up! Which column of data might be able to be visualized or analyzed but first would need to be cleaned? How Travel B Time Arrive (© How Long O Biggest Challenges
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Primary components of process planning
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage