Modern Business Statistics with Microsoft Office Excel 6th Edition by David R. Anderson Test bank
ANSWER: a.30
b.60%
c.16%
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data
LEARNING OBJECTIVES: MBST.ASWC.18.01.02 - 1.2
NATIONAL STANDARDS: United States - Business Program.1: - Reflective Thinking
KEYWORDS: Bloom's: Knowledge
84. Laura Naples, manager of Heritage Inn, periodically collects and tabulates information about a sample of the hotel’s overnight guests. This information aids her in planning and scheduling decisions she must make. The table below lists data on 10 randomly selected hotel registrants, collected as the registrants checked out. The data listed for each registrant are: number of people in the group; birth date of person registering; shuttle service used, yes or no; total telephone charges incurred; and reason for stay, business or personal.
ID of
RegistrantNumber of
People
in GroupBirth
Date
(mm/dd/yy)Shuttle
UsedTelephone
ChargesReason
for Stay
01105/07/59yes$ 0.00personal
02411/23/48no 12.46business
03204/30/73no 1.20business
04212/16/71no 2.90business
05105/09/39yes 0.00personal
06309/14/69yes 4.65business
07204/22/66no 9.35personal
08510/28/54yes 2.10personal
09111/12/49no 1.85business
10201/30/62no 5.80business
a. How many elements are there in the data set?
b. How many variables are there in the data set?
c. How many observations are there in the data set?
d. What are the observations for the second element listed?
e. What is the total number of measurements in the data set?
f. Which variables are quantitative?
g. Which variables are qualitative?
h. What is the scale of measurement for each of the variables?
i. Does the data set represent cross-sectional or times series data?
j. Does the data set represent an experimental or an observational study?
ANSWER: a. 10 elements
b. 5 variables
c. 10 observations
d. 4, 11/23/48, no, 12.46, business
e. 50
f. people in group, telephone charges
g. birth date, shuttle used, reason for stay
h. people in group – ratio scale, birth date – ordinal scale, shuttle use – nominal, telephone charge – ratio scale, reason for stay – nominal scale
i. cross-sectional
j. observational
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data
LEARNING OBJECTIVES: MBST.ASWC.18.01.02 - 1.2
NATIONAL STANDARDS: United States - Business Program.1: - Reflective Thinking
KEYWORDS: Bloom's: Knowledge
85. Molly Porter owns and operates two convenience stores, one on the East side of the city and the other on the South side. She has workforce-planning decisions to make and has collected some recent sales data that are relevant to her decisions. Listed below are the monthly sales ($1000s) at her two stores for the past six months.
StoreMarchAprilMayJuneJulyAugust
East102100103105109106
South727481869293
a. Is the data set cross-sectional or time series data? Explain.
b. Comment on any apparent patterns you see in the data.
ANSWER: a. Time series data for two variables: monthly sales for East store and monthly sales for South store.
b. Both stores have been experiencing an overall rise in sales during the past six months. The South store’s increase in sales (as a percentage of sales) has been greater than the East store’s increase. The increases might be temporary, due to the seasonal nature of demand. It is also possible that the increases will continue.
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data
LEARNING OBJECTIVES: MBST.ASWC.18.01.02 - 1.2
NATIONAL STANDARDS: United States - Business Program.1: - Reflective Thinking
KEYWORDS: Bloom's: Knowledge
86. The following table shows the starting salaries of a sample of recent VoTech graduates.
Income (Rounded to $1000s) Number of Graduates
25 - 2940
30 - 3460
35 - 3980
40 - 4418
45 - 49 2
a. What percentage of graduates in the sample had starting salaries of at least $40,000?
b. Of the graduates in the sample, what percentage had starting salaries of less than $35,000?
c. Based on this sample, what percentage of all VoTech graduates do you estimate to have starting salaries of at least $30,000?
ANSWER: a. 10%
b. 50%
c. 80%