Homework-Assignment2

.pdf

School

University of Utah *

*We aren’t endorsed by this school

Course

3210

Subject

Civil Engineering

Date

Apr 3, 2024

Type

pdf

Pages

5

Uploaded by BarristerRabbit3362

1 The University of Utah Department of Civil and Environmental Engineering CVEEN 5560/6560 Transportation Planning Individual Homework Assignment 2 Statistics and R practice Due Monday, February 5 th , 2024 Problem 1: Statistics Review [18 points] Below is the dwell time and total boarding and alighting (ridership) data collected for 35M Bus Rapid Transit (BRT) westbound in May 2014. The data is aggregated for the entire month at each station. Station Average Dwell Time per person Total Boarding and Alighting Dwell Time (sec) 3500 S 8010 W 13.2 191 2516.7 3500 S 7250 W 6.8 281 1922.9 3500 S 6450 W 8.3 119 991.2 3500 S 5616 W 8.2 412 3393.4 3500 S 4820 W 10.7 165 1766.8 3500 S 3980 W 6.6 281 1847.2 3500 S 3575 W 5.2 594 3090.9 3590 S 2820 W 6.4 858 5452.0 3500 S 2040 W 7.2 130 939.3 3500 S 1720 W 8.0 695 5554.4 3300 S 1226 W 9.0 144 1300.1 3300 S 940 W 6.7 397 2644.2 3300 S 210 W 105.1 2137 224612.2 Question 1: Please calculate the sample mean, variance, and standard deviation for average dwell time per person, total boarding and alighting, and dwell time. Please write out the equation and how you come to the final numbers. You will only receive partial credits if only the final result is presented (and calculated) using Excel or R. Question 2: Please calculate the correlation between Dwell Time and Total Boarding and Alighting; and correlation between Average Dwell Time per person and total boarding and alighting. What conclusion can you draw from the result?
2 Question #1:
3 Question #2 Problem 2: Preliminary Data Analysis for Household Travel Survey [12 points] Download the Household_Data collected for Utah household travel survey in 2012. Check the DataDictionary file to make sure you understand what each column
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