# Anova

#### tyrankj

##### New Member
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

Could someone explain how to use a ANOVA two way test in EXCEL, MEGASTAT or MINITAB???

#### tyrankj

##### New Member
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

Could someone explain how to use a ANOVA two way test in EXCEL, MEGASTAT or MINITAB???
Explain steps in details.....Need help asap!!

#### Mahi

##### New Member
Hi,

Data should be entered in to the excel sheet in the following pattern: (Column A to D & Row 1 to 4)
A B C D
1 Route 1 Route 2 Route 3
2 Driver 1 24 21 27
3 Driver 2 28 27 25
4 Driver 3 18 13 19