Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 10 Analysis of Variance 395

We have to decide between two hypotheses.

H 0 : The mean hotel population price is the same for each city.

Ha: The mean hotel population prices are not the same.

Graphing the Data to Verify ANOVA Assumptions

It is best to begin with a graph that shows the distribution of hotel prices in

each of the four cities. To do this, you can use the multiple histograms com-

mand available in StatPlus.

To create the graphs:

1 Click Multi-variable Charts from the StatPlus menu and then click

Multiple Histograms.

2 Because the workbook is laid out with the variable values in one

column and the categories in another, verify that the Use a column

of category levels option button is selected.

3 Click the Data Values button, and select Price from the list of range

names. Click OK.

4 Click the Categories button, and select City from the range names

list. Click OK.

5 Click the Display normal curve checkbox, and verify that the

Frequency option button is selected.

6 Click the Output button, and send the output to a new worksheet

named Histograms. Click OK.

Your completed dialog box should appear as shown in Figure 10-2.

Figure 10-2

Create

Multiple

Histograms

dialog box