Travel time to work hints.

Here is a GoogleDocs Version of the assignment instructions

https://docs.google.com/document/d/1kX1gv1aBYWQMun4b-oln0geXTqPZdHczl8AmntKjCwA/edit?usp=sharing

Please copy to your own account before adjusting.

Here is the local data:

https://docs.google.com/a/wvusd.k12.ca.us/spreadsheets/d/1x6TEt5YAtbs2aG0HW9Nr81JxlLnPUHMLsaPDAzu4GuQ/edit?usp=sharing

Here is the Census data:

https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=ACS_10_1YR_B08303&prodType=table

If you would like to try r-fiddle.org you can use this code to read in the data: http://www.r-fiddle.org/#/fiddle?id=YNCxeJKQ

MAH version: Travel Time to Work (TRVLT) Performance Task Instructions

We will survey workers who are 16 years old and older about the amount of time it takes them to travel to work each day. The assignment for each of you is to ask at least two workers who do not work at home to answer this question, “On a typical day, how many minutes does it take you to travel to work?” We will collect all of your results and use the data to create a list, a table, graphs, and then analyze the data.

Session 1: Analyzing Census Data

You are a data analyst and are asked to compare local census data against national census data for the time it takes workers to travel to work each day. You will present graphical representations of this data, as well as any trends, to a county commission. The commission will then use the data you provide to make decisions about transportation needs for your community. Tasks that must be completed to analyze the data include the following:

  1. Create data displays for the local data.
  2. Create a data display for the national data.
  3. Compare the local data to the national data.

Part A: Displaying Local Census Data

Yesterday, our class gathered data on the following question: “On a typical day, how many minutes does it take you to travel to work?” The teacher will display the list (raw data) of the times gathered from the students on the board or in the form of a handout.

Submit your data to your teacher and copy the class list, raw data, below.

Travel Time to Work Local Data (in minutes)

Now, create a boxplot to summarize your local travel time to work data. Be sure to include appropriate titles, labels, scales, and values in the display. This data display will be presented to the commission.

  • Make at least 3 observations that you might want to present to the commission.

  • Now, using the data found in the local travel time to work list, make a frequency table.

    (look at national data to determine the time intervals)

  • Next, create a histogram to summarize this data. Be sure to include appropriate titles, labels, scales, and values in the display. This data display will be presented to the commission.

Part B

  1. Mr. Jones is one of the county commissioners. He will recommend conducting a study to determine the need for public transportation if over 70% of the people your class surveyed travel 35 or more minutes to work.

    • Based on your survey results, will Mr. Jones recommend conducting a study?

    • Explain your reasoning, using information in your data displays.

  2. Ms. Miller is another of the county commissioners. She thinks that the information provided from your class’ survey is not a representative sample of the people in the county.

    • Do you agree or disagree with Ms. Miller’s opinion?

    • Explain your reasoning.

  3. Provide a frequency table for the National Travel Time to Work

Session 2: Displaying National Census Data

Part C

Now you will use the national census data to help compare the local and national data. This data display, along with ones you already created, will be shared with the commission. The national data are shown in the table.

Analyzing the Local and National Census Data

The commission will want information about the percentage of people, locally and nationally, who traveled to work during each time interval.

  1. In both the local and national data tables, convert the number of people listed for each time interval into percentages. Display this information in each table. Add a column labeled “Percentage” for each table. Round each percentage to the nearest hundredth.

Part D

The county commission will need you to answer the following questions. Provide the commission with an explanation for your response to each question.

  1. How does the median local travel time compare to the median national travel time?

  2. What is the difference between the percentage of people who travel 30 or more minutes to work nationally and the percentage of people who travel 30 or more minutes to work locally?

  3. What is the most important similarity between the national data and the local data? Why do you feel it is important for the county commission to know this?

  4. What is the most important difference between the national data and the local data? Why do you feel it is important for the county commission to know this?

  5. Make two cumulative frequency graphs side by side for both the national data and the local data. You are now prepared to discuss your findings with the commission using the percentages instead of the total number of people. Use the same scale for both.
    • Make 5 observations based on what you see.
    • Argue using math data whether you think that more public transportation is needed for people in our local community.
    • Present your answer in a letter to the commission about your recommendation. Include graphs if you think it is appropriate.