(Randomized Block Design) Refer to the cell phone study in Example 11.8, in which the effect of usage level on cost was studied for four different companies.

Enter the data into columns A–E of an Excel spreadsheet, using column A for usage labels and row 1 for company labels, just as shown in the table above.
1. Use Data ➤ Data Analysis ➤ Anova: Two-Factor Without Replication to generate the Dialog box in Figure 11.17(a). Highlight or type the Input Range (the data in the first five columns) into the first box and check “Labels” if necessary. Change the significance level if needed, and click OK. You can adjust the output, possibly changing the labels “Rows” and “Columns” to “Usage” and “Company,” as shown in Figure 11.17(b).
2. The observed value of the test statistic for treatments (companies) is F 51.841 with p-value5.240 indicating that there is no significant difference among the four companies.
The test for blocks (usage) is highly significant, with p-value5.000.

Transcribed Image Text:

Usage Level A B Company C D Low 27 24 31 23 Middle 68 76 65 67 High 308 326 312 300