2011_09_01_Class_Project_4_Excel_data_plotting

2011_09_01_Class_Project_4_Excel_data_plotting - in...

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

View Full Document Right Arrow Icon
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,
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
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 Right Arrow Icon
Ask a homework question - tutors are online