Test Bank for Modern Business Statistics with Microsoft Excel 5th Edition by Anderson Sweeney and Williams

Test Bank for Modern Business Statistics with Microsoft Excel 5th Edition by Anderson Sweeney and Williams CHAPTER 2—DESCRIPTIVE STATISTICS: TABULAR AND GRAPHICAL DISPLAYS MULTIPLE CHOICE 1. The minimum number of variables represented in a bar chart is a. 1 b. 2 c. 3 d. 4 ANS: A 2. The minimum number of variables represented in a histogram is a. 1 b. 2 c. 3 d. 4 ANS: A 3. Which of the following graphical methods is most appropriate for categorical data? a. ogive b. pie chart c. histogram d. scatter diagram ANS: B 4. In a stem-and-leaf display, a. a single digit is used to define each stem, and a single digit is used to define each leaf b. a single digit is used to define each stem, and one or more digits are used to define each leaf c. one or more digits are used to define each stem, and a single digit is used to define each leaf d. one or more digits are used to define each stem, and one or more digits are used to define each leaf ANS: C 5. A graphical method that can be used to show both the rank order and shape of a data set simultaneously is a a. relative frequency distribution b. pie chart c. stem-and-leaf display d. pivot table ANS: C 6. The proper way to construct a stem-and-leaf display for the data set {62, 67, 68, 73, 73, 79, 91, 94, 95, 97} is to a. exclude a stem labeled ‘8’ b. include a stem labeled ‘8’ and enter no leaves on the stem c. include a stem labeled ‘(8)’ and enter no leaves on the stem d. include a stem labeled ‘8’ and enter one leaf value of ‘0’ on the stem ANS: B 7. Data that provide labels or names for groupings of like items are known as a. categorical data b. quantitative data c. label data d. generic data ANS: A 8. A researcher is gathering data from four geographical areas designated: South  1; North  2; East  3; West  4. The designated geographical regions represent a. categorical data b. quantitative data c. directional data d. either quantitative or categorical data ANS: A 9. Data that indicate how much or how many are known as a. categorical data b. quantitative data c. label data d. category data ANS: B 10. The ages of employees at a company represent a. categorical data b. quantitative data c. label data d. time series data ANS: B 11. A frequency distribution is a. a tabular summary of a set of data showing the fraction of items in each of several nonoverlapping classes b. a graphical form of representing data c. a tabular summary of a set of data showing the number of items in each of several nonoverlapping classes d. a graphical device for presenting categorical data ANS: C 12. The sum of frequencies for all classes will always equal a. 1 b. the number of elements in a data set c. the number of classes d. a value between 0 and 1 ANS: B 13. In constructing a frequency distribution, as the number of classes are decreased, the class width a. decreases b. remains unchanged c. increases d. can increase or decrease depending on the data values ANS: C 14. If several frequency distributions are constructed from the same data set, the distribution with the widest class width will have the a. fewest classes b. most classes c. same number of classes as the other distributions since all are constructed from the same data d. None of the other answers are correct. ANS: A 15. Excel's can be used to construct a frequency distribution for categorical data. a. DISTRIBUTION function b. SUM function c. FREQUENCY function d. COUNTIF function ANS: D 16. A tabular summary of a set of data showing the fraction of the total number of items in several nonoverlapping classes is a a. frequency distribution. b. relative frequency distribution. c. frequency. d. cumulative frequency distribution. ANS: B 17. The relative frequency of a class is computed by a. dividing the midpoint of the class by the sample size. b. dividing the frequency of the class by the midpoint. c. dividing the sample size by the frequency of the class. d. dividing the frequency of the class by the sample size. ANS: D 18. The sum of the relative frequencies for all classes will always equal a. the sample size b. the number of classes c. one d. 100 ANS: C 19. A tabular summary of data showing the percentage of items in each of several nonoverlapping classes is a a. frequency distribution b. relative frequency distribution c. percent frequency distribution d. cumulative percent frequency distribution ANS: C 20. The percent frequency of a class is computed by a. multiplying the relative frequency by 10 b. dividing the relative frequency by 100 c. multiplying the relative frequency by 100 d. adding 100 to the relative frequency ANS: C 21. The sum of the percent frequencies for all classes will always equal a. one b. the number of classes c. the number of items in the study d. 100 ANS: D 22. In a cumulative frequency distribution, the last class will always have a cumulative frequency equal to a. one b. 100% c. the total number of elements in the data set d. None of the other answers are correct. ANS: C 23. In a cumulative relative frequency distribution, the last class will have a cumulative relative frequency equal to a. one b. zero c. 100 d. None of the other answers are correct. ANS: A 24. In a cumulative percent frequency distribution, the last class will have a cumulative percent frequency equal to a. one b. 100 c. the total number of elements in the data set d. None of the other answers are correct. ANS: B 25. The difference between the lower class limits of adjacent classes provides the a. number of classes b. class limits c. class midpoint d. class width ANS: D 26. A graphical device for depicting categorical data that have been summarized in a frequency distribution, relative frequency distribution, or percent frequency distribution is a(n) a. histogram b. stem-and-leaf display c. ogive d. bar chart ANS: D 27. A graphical device for presenting categorical data summaries based on subdivision of a circle into sectors that correspond to the relative frequency for each class is a a. histogram b. stem-and-leaf display c. pie chart d. bar chart ANS: C 28. Categorical data can be graphically represented by using a(n) a. histogram b. frequency polygon c. ogive d. bar chart ANS: D 29. Fifteen percent of the students in a School of Business Administration are majoring in Economics, 20% in Finance, 35% in Management, and 30% in Accounting. The graphical device(s) that can be used to present these data is (are) a. a line graph b. only a bar chart c. only a pie chart d. both a bar chart and a pie chart ANS: D 30. Methods that use simple arithmetic and easy-to-draw graphs to summarize data quickly are called a. exploratory data analysis b. relative frequency distributions c. bar charts d. pie charts ANS: A 31. The total number of data items with a value less than or equal to the upper limit for the class is given by the a. frequency distribution b. relative frequency distribution c. cumulative frequency distribution d. cumulative relative frequency distribution ANS: C 32. Excel's can be used to construct a frequency distribution for quantitative data. a. COUNTIF function b. SUM function c. PivotTable Report