Course Name Semester Homework CVE 350- Transportation Engineering Fall 2024 1 Problem: Determining Speed Characteristics from a Set of Speed Data [10 points] The table below shows the speed data collected on an urban highway during a traffic speed study. Develop the frequency histogram and the frequency distribution of the data and determine: 1. The arithmetic mean speed 2. The standard deviation 3. The median speed 4. The pace (range within which most vehicles are traveling) 5. The mode or modal speed 6. The 85th-percentile speed Car No. Speed Car (km/h) No. Speed Car Speed Car Speed (km/h) No. (km/h) No. (km/h) 1 32.5 13 44.6 25 48.7 37 52 2 40.1 14 49.3 26 50.6 38 59 3 36.4 15 47.2 27 55.4 39 54.3 4 50.8 16 52.1 28 53.1 40 61 5 38.9 17 42.7 29 60.2 41 47.7 6 55.5 18 44.2 30 49.9 42 58.2 7 43.3 19 51 31 57.5 43 46.9 8 46.8 20 47.9 32 62.5 44 50 9 39.7 21 41.5 33 40.8 45 48.3 10 50.2 22 53.6 34 44.5 46 45.4 11 56.4 23 50.9 35 58.3 47 51.9 12 34.7 24 48.4 36 49.2 48 60.1 Note: Use Microsoft Excel to solve the problem and calculate the required speed characteristics. Be sure to clearly show your steps in the solution. The histogram of observed vehicles' speeds and the cumulative frequency distribution curve must also be included.
Course Name Semester Homework CVE 350- Transportation Engineering Fall 2024 1 Problem: Determining Speed Characteristics from a Set of Speed Data [10 points] The table below shows the speed data collected on an urban highway during a traffic speed study. Develop the frequency histogram and the frequency distribution of the data and determine: 1. The arithmetic mean speed 2. The standard deviation 3. The median speed 4. The pace (range within which most vehicles are traveling) 5. The mode or modal speed 6. The 85th-percentile speed Car No. Speed Car (km/h) No. Speed Car Speed Car Speed (km/h) No. (km/h) No. (km/h) 1 32.5 13 44.6 25 48.7 37 52 2 40.1 14 49.3 26 50.6 38 59 3 36.4 15 47.2 27 55.4 39 54.3 4 50.8 16 52.1 28 53.1 40 61 5 38.9 17 42.7 29 60.2 41 47.7 6 55.5 18 44.2 30 49.9 42 58.2 7 43.3 19 51 31 57.5 43 46.9 8 46.8 20 47.9 32 62.5 44 50 9 39.7 21 41.5 33 40.8 45 48.3 10 50.2 22 53.6 34 44.5 46 45.4 11 56.4 23 50.9 35 58.3 47 51.9 12 34.7 24 48.4 36 49.2 48 60.1 Note: Use Microsoft Excel to solve the problem and calculate the required speed characteristics. Be sure to clearly show your steps in the solution. The histogram of observed vehicles' speeds and the cumulative frequency distribution curve must also be included.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
Related questions
Question
Problem: Determining Speed Characteristics from a Set of Speed Data
The table below shows the speed data collected on an urban highway during a traffic speed
study. Develop the frequency histogram and the frequency distribution of the data and
determine:
1. The arithmetic mean speed
2. The standard deviation
3. The median speed
4. The pace (range within which most vehicles are traveling)
5. The mode or modal speed
6. The 85th-percentile speed.
![Course Name
Semester
Homework
CVE 350- Transportation Engineering
Fall 2024
1
Problem: Determining Speed Characteristics from a Set of Speed Data [10 points]
The table below shows the speed data collected on an urban highway during a traffic speed
study. Develop the frequency histogram and the frequency distribution of the data and
determine:
1. The arithmetic mean speed
2. The standard deviation
3. The median speed
4. The pace (range within which most vehicles are traveling)
5. The mode or modal speed
6. The 85th-percentile speed
Car
No.
Speed Car
(km/h) No.
Speed
Car
Speed
Car
Speed
(km/h)
No.
(km/h)
No.
(km/h)
1
32.5
13
44.6
25
48.7
37
52
2
40.1
14
49.3
26
50.6
38
59
3
36.4
15
47.2
27
55.4
39
54.3
4
50.8
16
52.1
28
53.1
40
61
5
38.9
17
42.7
29
60.2
41
47.7
6
55.5
18
44.2
30
49.9
42
58.2
7
43.3
19
51
31
57.5
43
46.9
8
46.8
20
47.9
32
62.5
44
50
9
39.7
21
41.5
33
40.8
45
48.3
10
50.2
22
53.6
34
44.5
46
45.4
11
56.4
23
50.9
35
58.3
47
51.9
12
34.7
24
48.4
36
49.2
48
60.1
Note: Use Microsoft Excel to solve the problem and calculate the required speed
characteristics. Be sure to clearly show your steps in the solution. The histogram of
observed vehicles' speeds and the cumulative frequency distribution curve must also be
included.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd2ab8249-aeda-4ea9-8a17-c1ed65c71bb7%2Fb2275339-a701-4b01-a5a8-d91d243c9b0c%2Fql7zhb_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Course Name
Semester
Homework
CVE 350- Transportation Engineering
Fall 2024
1
Problem: Determining Speed Characteristics from a Set of Speed Data [10 points]
The table below shows the speed data collected on an urban highway during a traffic speed
study. Develop the frequency histogram and the frequency distribution of the data and
determine:
1. The arithmetic mean speed
2. The standard deviation
3. The median speed
4. The pace (range within which most vehicles are traveling)
5. The mode or modal speed
6. The 85th-percentile speed
Car
No.
Speed Car
(km/h) No.
Speed
Car
Speed
Car
Speed
(km/h)
No.
(km/h)
No.
(km/h)
1
32.5
13
44.6
25
48.7
37
52
2
40.1
14
49.3
26
50.6
38
59
3
36.4
15
47.2
27
55.4
39
54.3
4
50.8
16
52.1
28
53.1
40
61
5
38.9
17
42.7
29
60.2
41
47.7
6
55.5
18
44.2
30
49.9
42
58.2
7
43.3
19
51
31
57.5
43
46.9
8
46.8
20
47.9
32
62.5
44
50
9
39.7
21
41.5
33
40.8
45
48.3
10
50.2
22
53.6
34
44.5
46
45.4
11
56.4
23
50.9
35
58.3
47
51.9
12
34.7
24
48.4
36
49.2
48
60.1
Note: Use Microsoft Excel to solve the problem and calculate the required speed
characteristics. Be sure to clearly show your steps in the solution. The histogram of
observed vehicles' speeds and the cumulative frequency distribution curve must also be
included.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Recommended textbooks for you


Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON

Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning


Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON

Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning

Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education


Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning