Find Shortest Commute Time
Not what you're looking for?
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.