Purchase Solution

Bus Case Study: Randomized block ANOVA test using Excel

Not what you're looking for?

Ask Custom Question

Use the following scenario. Develop two-null hypothesis tests to ascertain if there are any statistical variances in the averages of bus route times and any statistical variance among the average performance of the bus drivers. Use the following information to conduct the test:
The three bus routes are the treatments.
The three bus drivers are the blocks.

The common element is driving time.

Route 1 Time Route 2 Time Route 3 Time
Driver 1 24 minutes 21 minutes 27 minutes
Driver 2 28 minutes 27 minutes 25 minutes
Driver 3 18 minutes 13 minutes 19 minutes

2. Using any present or past job related data, perform an ANOVA in either Excel or MegaStat. Write your null and alternate hypothesis. Post your ANOVA table. Interpret the results.

Purchase this Solution

Solution Summary

The solution performs a randomized block ANOVA test using Excel.A two-bull hypothesis test is developed to determine the statistical variances in the averages of bus route times.

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

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.

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.