# Rapid drainage of floodwater is crucial to prevent damage during heavy rains. Several designs for a drainage canal were considered for a certain city. Each designs was tested five times, to determinehow longit took to drain the water in a reservoir. The following table pesents the drainage times, in minutes.Channel Type                      Drainage Time1                                       41.4  43.4  50.5  41.22                                       38.7   48.3  51.1  38.33                                       32.6   33.7  34.8   22.54                                       26.3    30.9  33.3   23.85                                       44.9    47.2   48.5   37.1a. Construct an ANOVA table.b. Can you conclude that there is a difference in the mean drainage times for the different channel designs? use the a=0.01 level of significance.

Question
29 views

Rapid drainage of floodwater is crucial to prevent damage during heavy rains. Several designs for a drainage canal were considered for a certain city. Each designs was tested five times, to determinehow longit took to drain the water in a reservoir. The following table pesents the drainage times, in minutes.

Channel Type                      Drainage Time

1                                       41.4  43.4  50.5  41.2

2                                       38.7   48.3  51.1  38.3

3                                       32.6   33.7  34.8   22.5

4                                       26.3    30.9  33.3   23.8

5                                       44.9    47.2   48.5   37.1

a. Construct an ANOVA table.

b. Can you conclude that there is a difference in the mean drainage times for the different channel designs? use the a=0.01 level of significance.

check_circle

Step 1

(A)

According to the provided information, drainage time for the different channel design are given. Each drainage tested for 5 times.

There is only one factor which is drainage time. So, clearly it is a one way ANOVA.

Excel software is used to construct the ANOVA Table.

Software Procedure

Step by step procedure to calculate ANOVA using Excel.

• Inter the data into worksheet
• Go to DATA > Data Analysis
• Anova : Single Factor
• Select the data into Input Range
• Select Grouped By: Row
• Select Alpha 0.01
• Click OK in each dialogue box.

The output of the ANOVA is shown below.

Step 2

B)   In order to conclude whether there is difference in the mean drainage t...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in