The following data are the front and rear leg rooms (in inches) for 10 different compact sports

Question:

The following data are the front and rear leg rooms (in inches) for 10 different compact sports utility vehicles

image text in transcribed

1. Since the data involve two variables and a third labeling 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 click OK. Highlight or type the Input range (the data in the second and third columns) into the Descriptive Statistics Dialog box (Figure 2.19(a)). Type an Output location, make sure the boxes for “Labels in First Row” and “Summary Statistics” are both checked, and click OK. The summary statistics (Figure 2.19(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, Q1 and Q3, are not given in the Excel output in Figure 2.19(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 (05min, 15first quartile, 25median, 35third quartile, or 45max) in the box marked “Quart.” The quartile (calculated using this textbook’s method) will appear in the cell you have chosen. Using the two quartiles, you can calculate the IQR and construct a box plot by hand