2011_09_01_Class_Project_4_Excel_data_plotting

# 2011_09_01_Class_Project_4_Excel_data_plotting - in...

This preview shows pages 1–2. Sign up to view the full content.

ENGR_160_Fall_2011_Section_E1_Prof_Alleman Class Project @ 1 September 2011 (Tuesday) Learning Topic: 1) Learn how to create dual plots 2) Learn how to revise plots using ‘select data’ Team Member Names: 1) _________________________________ 2) _________________________________ Step Effort 1 Download the I5_data_29_31_August_flow_speed.xls file 2 Open the file Note that column A has a date and time stamp Note that the data is provided for I-5 traffic information on flow and speed every 0.5 seconds (i.e., 20 data sets per 10 second interval) 3 Note that columns B to G (i.e., 6 columns) show speeds on each of these six lanes of the highway, in miles per hour Note that columns H to M (i.e., 6 columns) show flow values on each of these six lanes,

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: in vehicles per minute 4 Establish the max, min, and average speeds for each six lane columns Type your answers here: Lane Min Max Average 1 2 3 4 5 6 5 Establish the max, min, and average flows for each of the six lane column Type your answers here: Lane Min Max Average 1 2 3 4 5 6 6 Create a plot which shows both the speed and flow for lane ‘E’ plus …for the data given on 29 August Save this plot on a Word file Repeat for 30 August Repeat for 31 August ENGR_160_Fall_2011_Section_E1_Prof_Alleman Print your Word file…and staple it to this answer sheet which you will then turn in!...
View Full Document

## This note was uploaded on 12/30/2011 for the course ENG 160 taught by Professor J.alleman during the Fall '11 term at Iowa State.

### Page1 / 2

2011_09_01_Class_Project_4_Excel_data_plotting - in...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online