Exam 2: Descriptive Statistics: Tabular and Graphical Displays

To construct a bar chart using Excel's Chart Tools, choose __________ as the chart type.

To construct a histogram using Excel's Chart Tools, choose __________ as the chart type.

Develop a stretched stem-and-leaf display for the data set below, using a leaf unit of 10. 136 281 226 123 178 445 231 389 196 175 211 162 212 241 182 290 434 167 246 338 194 242 368 258 323 196 183 209 198 212 277 348 173 409 264 237 490 222 472 248 231 154 166 214 311 141 159 362 189 260

Ithaca Log Homes manufactures four styles of log houses that are sold in kits. The price ($1000s) and style of homes the company has sold in the past year are shown below. ​ Price Style Price Style Price Style \leq99 Colonial >100 A-Frame >100 Colonial \leq99 Ranch >100 Split-Level <99 Colonial >100 Split-Level \leq99 Colonial \leq99 A-Frame >100 Split-Level \geq100 Ranch \geq100 Split-Level <99 Colonial \geq100 Colonial \geq100 Ranch <99 A-Frame \leq99 A-Frame \leq99 Split-Level \leq99 Split-Level <99 Split-Level >100 Split-Level \leq99 A-Frame <99 Split-Level >100 Colonial \geq100 Ranch <99 Colonial >100 Ranch >100 Split-Level \leq99 Ranch \geq100 Split-Level <99 A-Frame \geq100 Split-Level \leq99 Colonial <99 Colonial \geq100 Colonial \geq100 Colonial >100 Ranch \leq99 Split-Level \leq99 Split-Level \leq99 Colonial ​ ​ Prepare a crosstabulation for the variables price and style.

When using Excel to create a __________, one must edit the chart to remove the gaps between rectangles.

Which of the following graphical methods is not intended for quantitative data?

A summary of the results of a job satisfaction survey follows. What is wrong with the relative frequency distribution? Rating Relative Frequency Poor 0.15 Fair 0.45 Good 0.25 Excellent 0.30

A histogram is NOT appropriate for displaying which of the following types of information?

You are given the following data on the price/earnings (P/E) ratios for 12 companies. Construct a stem-and-leaf display. Specify the leaf unit for the display. 23 25 39 47 22 37 8 36 48 28 37 26

Construct a stem-and-leaf display for the following data. Specify the leaf unit for the display. 12 52 51 37 47 40 38 26 57 31 49 43 45 19 36 32 44 48 22 18

For stem-and-leaf displays where the leaf unit is not stated, the leaf unit is assumed to equal _____.

Excel's __________ can be used to construct a crosstabulation.

The total number of data items with a value less than or equal to the upper limit for the class is given by the _____.

The age of employees at a company is an example of _____.

A(n) __________ is a graph of a cumulative distribution.

Categorical data can be graphically represented by using a(n) _____.

A graphical presentation of a frequency distribution, relative frequency distribution, or percent frequency distribution of quantitative data constructed by placing the class intervals on the horizontal axis and the frequencies on the vertical axis is a _____.

The difference between the lower class limits of adjacent classes provides the _____.

A frequency distribution is a _____.

The following is a summary of the number of hours spent per day watching television for a sample of 100 people. What is wrong with the frequency distribution? Hours/Day Frequency 0-1 10 1-3 45 3-5 20 5-7 20 7-9 5