Purchase Solution

Find Shortest Commute Time

Not what you're looking for?

Ask Custom Question

I need to measure minutes to and from work versus the time of day I leave. The objective is to find the time of the day that takes the least amount of time to get to work from the data given.

I would like the results to include a bell curve if possible. What would be the best form of measure: linear regression or null hypothesis. Discuss confidence intervals usefulness based on the number of data points.

Purchase this Solution

Solution Summary

The solution presents an analysis of the data to answer the question "What departure time has the shortest average commute time?"

Solution Preview

Your goal is to find the time of the day that takes the least amount of time to get to work from the data given. In other words, you want find the average length of a one-way commute for each of your departure times (4 am, 9 am, 11 pm, etc.) and figure out which departure time gives you the shortest commute.

----------------------------

First, let's see if times vary by day:

[see Excel workbook]

It seems as if Sunday has the shortest commutes. You leave on Sundays at 9 am (one week at 8 am) and return at 8 pm (one week at 7 pm). So, if it turns out that the shortest commute is either at 9 am or 8 pm, you might want to consider if the quick commute is a result of the time or the day of the week.

----------------------------

Now, onto the real question. Let's look at the data sorted by time:

Time Average Average (no bad ...

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.