Data Analysis with Microsoft Excel: Updated for Office 2007

394 Statistical Methods

To answer this question, let’s look at hotel prices in four major cities: New

York City, Chicago, Denver, and San Francisco. For each city, a random sam-

ple of eight hotels was taken from the TripAdvisor.com website (February

2008) and stored in the Hotel workbook. The workbook contains the follow-

ing variables as shown in Table 10-1:

To open the Hotel workbook:

1 Open the Hotel workbook from the Chapter10 folder.

2 Save the workbook as Hotel ANOVA. The workbook appears as

shown in Figure 10-1.

Table 10-1 The Hotel Workbook

Range Name Range Description

City A2:A33 City of each hotel

Hotel B2:B33 Name of hotel

Stars C2:C33 TripAdvisor.com rating (February 2008), on a

scale from 1 to 5

Price D2:D33 The room price

Figure 10-1

The Hotel

workbook

New York

Chicago

Denver

San Francisco