The following data are the front and rear leg rooms (in centimetres) for nine different sports utility vehicles:

1. Since the data involve two variables and a third labelling variable, enter the data into the first three columns of an Excel spreadsheet, using the labels in the table. Select Data Data Analysis Descriptive Statistics, and highlight or type the Input range (the data in the second and third columns) into the Descriptive Statistics dialogue box (Figure 2.18(a)). Type an Output location, make sure the check boxes for "Labels in First Row" and "Summary Statistics" are both checked, and click OK. The summary statistics (Figure 2.18(b)) will appear in the selected location in your spreadsheet. 2. You may notice that some of the cells in the spreadsheet are overlapping. To adjust this, highlight the affected columns and click the Home tab. In the Cells group, choose Format AutoFit Column Width. You may want to modify the appearance of the output by decreasing the decimal accuracy in certain cells. Highlight the appropriate cells and click the Decrease Decimal icon (Home tab, Number group) to modify the output. We have displayed the accuracy to three decimal places.

3. Notice that the sample quartiles, Q and Q3, are not given in the Excel output in Figure 2.18(b). You can calculate the quartiles using the function command. Place your cursor into an empty cell and select Formulas More Functions Statistical QUARTILE.EXC. Highlight the appropriate cells in the box marked "Array" and type an integer (0 min, 1 = first quartile, 2 = median, 3 = third quartile, or 4 = max) in the box marked "Quart." The quartile (cal- culated using this textbook's method) will appear in the cell you have chosen. An alternative method for calculating the quartiles will be used if you select Formulas More Functions Statistical QUARTILE.INC. (NOTE: This function is called QUARTILE in Excel 2007 and earlier versions.) Using the two quartiles, you can calculate the IQR and construct a box plot by hand.

Transcribed Image Text:

Make & Model Acura MDX Front Leg Room Rear Leg Room 104.1 72.4 Buick Enclave 105.4 76.2 Chevy TrailBlazer 101.6 64.8 Chevy Tahoe Hybrid VB CVT 104.1 69.9 GMC Terrain 1L 4-cyl 109.2 78.7 Honda CR-V 104.1 74.9 Hyundai Tucson 108.0 74.9 Kia Sportage 101.6 73.7 Lexus GX 106.7 76.2 Source: "New SUV Ratings & Reliability." Copyright 2010. Consumers Union of U.S.. Inc Yonkers, NY 10703-1057, a nonprofit organization. Reprinted with permission from the August 2010 issue of Consumer Reports for educational purposes only. www.ConsumerReports.org